cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. 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.

Business iQ (Analytics)

ADQL for doing UNION query

Dev.Priya
Creator

ADQL for doing UNION query

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

Tags (1)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
ADQL for doing UNION query
1 REPLY 1

Appdynamics does not have union where as ther competitors like Newrelic does provide...I was loking the same but no luck

Tags (1)