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)

How to use 'distinctcount' clause in ADQL


How to use 'distinctcount' clause in ADQL

hello folks,


I want to basically get count of distinct 'fieldname' .

When I write the following query, it won't work.


SELECT distinctcount(bb) FROM transactions WHERE application = "PROD" AND transactionName = "aaa" AND segments.userData.eReceiptIndicator = true


How can I do this?

thank you very much



Tags (2)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
How to use 'distinctcount' clause in ADQL
AppDynamics Team (Retired)

Hi @Basam.Nath


Thank you for posting your query on AppDynamics Community.


I tried to run a similar query and it worked without the last `= true' predicate.


Do you want to try and let us know if it works?

Radhika P

Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.