cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

Tom.Davison
Producer

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 

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



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.

Learn more about me in the Community Member Spotlight Q & A

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

 

Thanks,

Tom