I am trying to connect Elastic Search with JReport, JReport is a BI tool for analytics.
I want to do grouping on a particular field and get count of it.
Below is the SQL counterpart of it,
SELECT CUSTOMER_CODE,COUNT(TRANSACTION_REFERENCE_NO) FROM AXIA_REC_TXNS_METADATA_MST GROUP BY CUSTOMER_CODE ORDER BY 2 DESC.
How can i achieve same in elastic search?