cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Business iQ (Analytics)

Creating a midnight to midnight time segment

Dudley.Wood
Producer

Creating a midnight to midnight time segment

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?

 

By replying you agree to the Terms and Conditions of the AppDynamics Community.
Creating a midnight to midnight time segment
0 REPLIES 0