Hello all - is it possible via to write a TIMESERIES query that covers SINCE today UNTIL the end of the day?
For example, I can write one that covers the start of the week until the end of the week by explicitly using: SINCE monday UNTIL sunday
SELECT count(*) FROM PageView TIMESERIES 1 hour SINCE monday UNTIL sunday COMPARE WITH 1 week ago
However I’d like that for 1 day, and it should roll over at midnight e.g. SINCE today UNTIL tomorrow
This way I can see a graph of the expected trend for rest of the day against what we seen so far