Hi, Is there a simple query to calculate the average and peak day count for last 3 months? For example let's say 3 months are Feb, March, April what i am looking for is -
Average count per day for 3 months. I mean what is the average and peak in Feb then what is the average and peak in March etc.
| bucket _time span=1d
| stats count by _time
| stats avg(count) as AverageCountPerDay by date_month
The above query is not giving any results. Any ideas?