How to use 'distinctcount' clause in ADQL

[Basam_Nath]

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

[CommunityUser · Accepted solution]

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?