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