need help with a query to get count and avg(count) per day


I have given this query and it's just giving me avg(count) in the output, i'm looking for both count and avg(count) per day in the output.. any help would be appreciated. Thanks.

index=main host=src* source=ihs* | stats count by date_mday | stats avg(count)

Tags (1)
0 Karma

Esteemed Legend

Like this:

index=main host=src* source=ihs* | bucket _time span=1d | stats count by _time | addtotals col=t row=f | fillnull value=TOTAL | streamstats current=f count AS serial | eval daily_average = if(_time = "TOTAL", count/serial, "vvvvvvvvvv") | fields - serial