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?
User | Count |
---|---|
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form