I want to use the values() function because I want to group by fields. If I just use count by I get the correct result but it doesn't look nice. If I use the values function the counts get swapped. this is how count by returns the results:  Function                  |    Status  |  count Authentication     |     Pass     |    10 Authentication     |     Fail       |      3 this is how the values() returns the results: Function                  |    Status  |  count Authentication     |     Pass     |    3                                     |     Fail       |     10 Here is the count by search:  | stats count by Function,  Status | table Function, Status, count Here is the values search: | stats count by Function,  Status | stats values(Status) as Status, values(count) as Count by Function | table Function, Status, Count So my question is how do I group by Function while getting the correct counts for the status.   ... View more