Hi,
I am trying to create a dashboard showing the amount of events split up in working and non-working hours joined by a sparkline showing the trend over the last 7 days in two different charts. For the working hours, specifying (date_hour>6 AND date_hour<18) together with span=1d works quite fine. However, for the non-working hours I would like to have a bin starting at 6pm and ending the next day at 6am. Using span=24h I get a binning starting at 2am.
My search so far looks like:
*"some search"* (date_hour<6 OR date_hour>18) | fillnull value=novalue | timechart count span=24h
Is it possible to fix the starting point of the binning in a timechart?
Thanks!
... View more