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.

Dashboards

How to create an Analytic query that would show the top 5 Business Transactions with Error counts?

SOLVED
Tom.Davison
Producer

How to create an Analytic query that would show the top 5 Business Transactions with Error counts?

Hello,

 

I am trying to create an Analytic query that would show the top 5 BTs with Error counts.

 

e.g.

 

TransactionName  3

 

I'm not great at building SQL or Analytics queries. : )

 

Thanks for any help, much appreciated.

Tom 

By replying you agree to the Terms and Conditions of the AppDynamics Community.
How to create an Analytic query that would show the top 5 Business Transactions with Error counts?
2 REPLIES 2
Mario.Morelli
Architect

Hi Tom

 

You can do it this way

 

SELECT transactionName, count(*) AS "Counts" FROM transactions WHERE userExperience = "ERROR" ORDER BY Counts DESC LIMIT 5

 

This would be across all applications, you can put in additional filters if you want to limit it to a specific application etc.

 

Ciao



Learn more about me in the Community Member Spotlight Q & A
Tom.Davison
Producer

Thank you very much for the Solution on this.  Very much appreciated.

 

Thanks,

Tom