I’m trying to plot a time series graph which starts at 0 on each new day. I have an increasing number ID and a timestamp TimestampStarted for each row which represents a task, and I’m able to plot a cumulative graph displaying how tasks increase over time. However, I would want to have the count start at 0 each day, and cumulatively increase as tasks get started, and would start from 0 again the next day.
In the following picture the green line is what I have, and the red line represents what I want to have.
My query is currently simply:
ID as Count,
TimestampStarted as time
ORDER BY 1
I have tried finding a solution without success, so I’m wondering if what I’m trying to achieve is even possible in Grafana, or is it maybe possible using some query magic?
Any help is appreciated, thanks!