Business iQ (Analytics)

Showing results for 
Search instead for 
Did you mean: 

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)
How to use 'distinctcount' clause in ADQL
AppDynamics Team (Retired)

Re: How to use 'distinctcount' clause in ADQL

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.