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.
11-24-2021 10:38 PM
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?
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form