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