Is there a way in DQL or dashboards to show the data for today and the next 7 days as 0 until we go past those days? Idea being showing each day from the Monday how many records are returned until the Sunday then the graph resets.
Eg in DQL return this table as there is only data for todays date, show 0 for the rest of the week.
I am counting bizevents since beginning of week set on beginning od Monday (@w1) .
After adding placeholders I summarize again using sum(), so placeholder are deduplicates and do nothing to existing data as 0 is neutral.