topic Results displayed by day in Dashboards & Visualizations

Results displayed by day

sweiland — Fri, 21 Aug 2020 07:54:57 GMT

Hi there,

I have a dashboard which splits the results by day of the week, to see for example the amount of events by Days (Monday, Tuesday, ...)

My request is like that:

Only problem with the request is that sometimes a day or two could be missing in the histogram (0 entries), and I wanted to have always the 7 days displayed (even with 0 results).

Any way to do this ? Any help appreciated! (like a left join in SQL)

Re: Results displayed by day

richgalloway — Fri, 21 Aug 2020 15:19:02 GMT

This works for me.

Re: Results displayed by day

sweiland — Fri, 21 Aug 2020 15:42:24 GMT

Hmmm nope, here is my first attempt (with my query, I miss the Sunday = 0 event), and also comparison with your query (below)

Maybe I need then a group by ?

Re: Results displayed by day

richgalloway — Fri, 21 Aug 2020 16:50:50 GMT

It looks like my query is producing the zeros you wanted, but has more than one entry for each day. I think we can correct that with stats.

Re: Results displayed by day

sweiland — Fri, 21 Aug 2020 20:42:00 GMT

Thanks, it works almost flawlessly ! 🙂

Just a problem when I put "Since start of week", Saturday is missing.. dont know why..

I would have thought that I should miss Saturday & Sunday (because I put start of week and both days are not in the request at all)

Re: Results displayed by day

richgalloway — Sat, 22 Aug 2020 16:30:49 GMT

"Start of week" is Sunday. Saturday was tomorrow so timechart thinks you only care about Sun-Fri. Try using latest=+1w@w.

Re: Results displayed by day

sweiland — Sat, 22 Aug 2020 17:21:15 GMT

Maybe I just find a way to limit the timepicker to 7 days range minimum (but did not find how), or I just do not display the panel if the range is less than 7 days

Both case I do not know how to do, but will try to find 🙂 (2nd optionis better, to hide the panel if range too short)