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)

How to get the percentile of the sum of the segment transaction time?

Joy.Cristobal
Discoverer

How to get the percentile of the sum of the segment transaction time?

I'm trying to get the percentile of the total of the all the segments.transactionTime. I tried this query but it's not giving me the right numbers:

 

SELECT percentile(segments.transactionTime, 95) AS "95th Percentile Response Time (ms)" FROM transactions WHERE application = "App_Name" and transactionName = "Bt_Name"

 

 I think what I need is to get the percentile of the result of the following query:

 

SELECT requestGUID, sum(segments.transactionTime) AS 'Total Transaction Time' FROM transactions WHERE application = "App_Name" and transactionName = "Bt_Name"

 

Due to the limitations with ADQL I'm finding it hard to find a solution for this. Has anyone had the same issue or have a suggestion on how to do this?

 

Thanks!

By replying you agree to the Terms and Conditions of the AppDynamics Community.
How to get the percentile of the sum of the segment transaction time?
0 REPLIES 0