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
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form