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)
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