cancel
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

SOLVED
Basam.Nath
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)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
How to use 'distinctcount' clause in ADQL
1 REPLY 1
Radhika.Puthiyetath
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.