https://community.splunk.com/t5/Splunk-AppDynamics/ADQL-for-doing-UNION-query/m-p/718037#M787 <P>Appdynamics does not have union where as ther competitors like Newrelic does provide...I was loking the same but no luck</P> Mon, 24 Jun 2019 13:50:12 GMT Umervali_Niyama 2019-06-24T13:50:12Z https://community.splunk.com/t5/Splunk-AppDynamics/ADQL-for-doing-UNION-query/m-p/718036#M786 <P>I need to compute the number of distinct users across both mobile and web application.&nbsp;</P> <P>For web alone I get the number using this query -</P> <P>SELECT distinctcount(userdata.userId) FROM browser_records</P> <P>And for mobile using this -&nbsp;</P> <P>SELECT distinctcount(userdata.userId) FROM mobile_session_records</P> <P>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.</P> <P>Thanks</P> Wed, 24 Apr 2019 21:45:26 GMT https://community.splunk.com/t5/Splunk-AppDynamics/ADQL-for-doing-UNION-query/m-p/718036#M786 CommunityUser 2019-04-24T21:45:26Z https://community.splunk.com/t5/Splunk-AppDynamics/ADQL-for-doing-UNION-query/m-p/718037#M787 <P>Appdynamics does not have union where as ther competitors like Newrelic does provide...I was loking the same but no luck</P> Mon, 24 Jun 2019 13:50:12 GMT https://community.splunk.com/t5/Splunk-AppDynamics/ADQL-for-doing-UNION-query/m-p/718037#M787 Umervali_Niyama 2019-06-24T13:50:12Z