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.
... View more
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.
... View more
[Deadline February 28, 2019] Apply to Participate in the Transaction Analytics Beta Program: Agentless Analytics on SaaS
The Business iQ team is working diligently to empower more customers (like you) to unlock the business value of your application data. To achieve this end, we’d like to collaborate with a small group of customers to help us take additional steps forward to design solutions with the customer in mind. We’re embarking on a limited beta release of Agentless Analytics on SaaS. If you’re interested in kicking around this offering and providing valuable feedback, please apply for the beta program, fill out the 6-question intake application. Subsequently, if your application is a good fit for the beta program we will follow up with additional steps and more information.
What is Agentless Analytics on SaaS?
Agentless Analytics allows you to collect Transaction Analytics data with the press of a few buttons. Once this data reaches our SaaS data store, you will be able to:
Track User Journeys
Run ADQL queries
Visualize long-running busin ess processes within Business Journeys
Getting started with Business iQ has never been easier. By leveraging our existing application agents, you’re able to get the most out of Transaction Analytics and collect custom data.
You may have already felt a few pain points around bringing Java-based analytics agents into your environment, particularly if you’re using .NET. Agentless Analytics can dramatically reduce your total cost of ownership by streamlining installation, maintenance, and monitoring of one or many analytics agents on top of existing application agents. Now you can confidently begin your journey with Business iQ.
If this offering is relevant to your enterprise needs, we encourage you to apply for the Transaction Analytics Beta Program on Agentless Analytics by filling in this 6-question form.
This community post mentions features that are currently beta. The development, release, and timing of any features or functionality described for AppDynamics' products remains at AppDynamics' sole discretion. AppDynamics reserves the right to change the features at any time before making them generally available as well as never making them generally available. Any buying decisions should be made based on features and products that are currently generally available.
... View more