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?

On-Demand Webinar
Discover new Splunk integrations and AI innovations for Cisco AppDynamics.


Register Now!

Observe and Explore
Dive into our Community Blog for the Latest Insights and Updates!


Read the blog here
Top Kudoed Authors