Click the Start a free trial link to start a 30-day SaaS trial of our product and join our community as a trial customer. 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.
I am trying to create an Analytic query that would show the top 5 BTs with Error counts.
I'm not great at building SQL or Analytics queries. : )
Thanks for any help, much appreciated.
Solved! Go to Solution.
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.