In data, I have complete date time field , which is formatted in Month format then we added group by clause as below
eval Month = strftime(opdate,"%b %y")
| stats list(category) as category, list(incident) as no_of_inci, list(sum_tw) as sum_operation_time, list(eval(sum_tw/cnt_tw)) as "Average resolution time" by Month
Data is displayed
Month Category Number of incident Time avarage
Aprl 18 xyz 10 10 1
Aug 15 sdhshf 2 14 7
Dec 17 ... ....
I want result should be
Month Category Number of incident Time avarage
Aug 15 sdhshf 2 14 7
Dec 17 ... ....
Aprl 18 xyz 10 10 1
... View more