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
On-Demand Webinarr
Discover new Splunk integrations and AI innovations for Cisco AppDynamics.


Register Now!

Observe and Explore
Dive into our Community Blog for the Latest Insights and Updates!


Read the blog here