cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Creating a midnight to midnight time segment

Dudley.Wood
Producer

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")

DudleyWood_0-1637821541530.png

If I use a custom time it works

DudleyWood_1-1637821735822.png

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

DudleyWood_2-1637821893226.png

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?

 

0 REPLIES 0