Discussion Feed
12-19-2018
02:46 PM
1 Kudo
Hello Brian,
Thanks for reaching out on the AppDynamics Community. I am the Product Manager for ADQL and the Events Service (which ADQL ultimately ends up querying against).
From your question, it sounds like there are two things you might be seeking two do:
View all unique values for the respective field (say that field is responseTime, since it's numeric)
View the cardinality of that field
Case 1: View all unique values for the respective field
You can view all the unique values for the respective field as such:
SELECT distinct responseTime FROM transactions LIMIT 10000
Note that you can't use braces (I stumbled over this as well when I crafted this response, and it seems you may have encountered the same issue) in older Controller versions, but we fixed this limitation in the newest Controllers (which now work with braces as well.)
Case 2: View the cardinality of a field
In this case, you'd want to issue a query like such:
SELECT distinctcount(responseTime) FROM transactions LIMIT 10000
This query will give you the cardinality of the numeric field, i.e. how many *unique* values exist in the Events Service over the specific time period.
I hope this helps - please don't hesitate to reach out again on this thread should you require any further assistance.
Happy ADQL-ing,
Stefan
... View more
11-05-2018
11:24 AM
1 Kudo
Hello@Mohammad.Younis,
Thank you for reaching out to us. I am a Product Manager at AppDynamics working on our Big Data Backend (we call it the "Events Service").
I can see two potential root causes behind why you may not see the data you'd expect in your environment.
First, metrics are computed every minute, whereas Analytics searches can run over longer time ranges. I trust that you've adjusted the time-range to reflect that, which leads me to the second potential issue.
Analytics Metrics are inherently dependent on timely ingestion of the data into the Events Service - after all, you can't query against data that's not "there" yet. Unfortunately, there have been very rare occasions where this has proven to not be the case in our SaaS environment and where we have experienced sustained lag in our system. Our Engg team is already working to build a more robust solution so this failure possibility is greatly reduced.
Should you need further info, I will be happy to coordinate a call with your account manager and myself to discuss in more detail about this functionality.
Thank you,
Stefan
... View more
Latest Activity
- Posted Re: How to get report/list of custom user data values on End User Monitoring (EUM). 12-19-2018 02:46 PM
- Got a Kudo for Re: How to get report/list of custom user data values. 12-19-2018 02:46 PM
- Got a Kudo for Re: Analytics search value is different than created metric. 11-05-2018 11:29 AM
- Posted Re: Analytics search value is different than created metric on Business iQ (Analytics). 11-05-2018 11:24 AM
Community Stats
Date Registered | 01-26-2018 10:32 AM |
Date Last Visited | 12-20-2018 03:08 PM |
Total Messages Posted | 4 |
Total Kudos Received | 2 |