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
04-24-2019 02:45 PM - edited 04-24-2019 02:47 PM
I need to compute the number of distinct users across both mobile and web application.
For web alone I get the number using this query -
SELECT distinctcount(userdata.userId) FROM browser_records
And for mobile using this -
SELECT distinctcount(userdata.userId) FROM mobile_session_records
What I am looking for is a way to compute the distinctcount across these two combined because some users get counted twice if I simply add the output of these two queries. How can I do this in ADQL? In SQL this can be solved using a UNION.
Thanks
06-24-2019 06:50 AM
Appdynamics does not have union where as ther competitors like Newrelic does provide...I was loking the same but no luck
User | Count |
---|---|
3 | |
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