Time shift on the graph

kszortyka · May 29, 2020, 12:42pm

I want to set on the Graph:

displaying the value (points) of the day from 00:00 to 00:00 and not from 02:00 to 02:00.
displaying dates on the x axis without intermediate hours (only 00:00)

$ _interval = 1d

select $__timeGroup(DATETIME, $Interval) as time, AVG(ELAPSEDMS/1000.0) AS 'SO'
FROM [TRACKINGTABLE]
where $__timeFilter(DATETIME) 
group by $__timeGroup(DATETIME, $Interval)
order by $__timeGroup(DATETIME, $Interval)