Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

How to use 'distinctcount' clause in ADQL

SOLVED
Highlighted
Builder

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
1 REPLY 1
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?


Thanks,
Radhika P




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