Creating a midnight to midnight time segment

[Dudley.Wood]

Hi There

I am trying to create day "buckets" to count the number of Completed vs Uncompleted in a  business Journey.

I am using the following ADQL query which creates the correct 24h buckets however I cannot use the custom time range as it uses specific dates instead of time ranges.

SELECT series(eventTimestamp, '24h'), completed, count(*) FROM vmttr1mobax WHERE PRIORITY = "P4" and (WORKGROUP = "RAN:FAULT MANAGEMENT:SOUTH:NMC:NMG" OR WORKGROUP = "RAN:FAULT MANAGEMENT:NORTH:NMC:NMG")

If I use a custom time it works

However if I use the standard time slot it calculates from now:

Is there a way to either select only time slots in the custom time selector or edit the ADQL query to select data in the 24h buckets from midnight to midnight?