To get the greatest value for each day and graph it for a week

[dinumayu]

Hi,

Can you please assist with the query to get the greatest value (for one field) on that day and graph the data for the week 

I am currently using the below one and it gives me only the greatest value for the week in the graph

index="index_name" | search STATS_NAME=BIRTHDAY | chart values(STATS_COUNT) by _time  

[ITWhisperer]

Assuming that you want the highest value of STATS_COUNT for each day

index="index_name" | search STATS_NAME=BIRTHDAY
| bin span=1d _time
| chart max(STATS_COUNT) by _time