cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to use 'distinctcount' clause in ADQL

Basam.Nath
Builder

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

 

 

1 REPLY 1

Radhika.Puthiyetath
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?