Click the Start a free trial link to start a 30-day SaaS trial of our product and join our community as a trial customer. If you are an existing customer do not start a free trial.
AppDynamics customers and established members should click the sign in button to authenticate.
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.