Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
08-30-2021 01:43 PM - last edited on 09-21-2021 10:00 AM by Ryan.Paredez
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
Solved! Go to Solution.
08-30-2021 10:21 PM - last edited on 09-21-2021 10:00 AM by Ryan.Paredez
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
08-31-2021 05:21 AM - last edited on 09-21-2021 10:00 AM by Ryan.Paredez
Thank you very much for the Solution on this. Very much appreciated.
Thanks,
Tom
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form