How can i right DSL query for count of unique value in fields (Colom) for one day. where unique value is greater than 15 SQL example: select /+parallel(15)/ fruits ,count(1) from all_items where LOAD_DATE=trunc(sysdate) group by fruits having count(1)>15 ; output : 17-jan-2022 apple 16 orang…

You could use aggregation-based "Data table" visualization. Aggregation-based | Kibana Guide [7.16] | Elastic Consider the production components that are used to generate reports. An example: [image] [image] [image] You can't hide Count column.

Discuss the Elastic Stack

Unique feilds count

Elastic Stack Elasticsearch

Tomo_M (Tomohiro Mitani) January 13, 2022, 2:08pm 9

You could use aggregation-based "Data table" visualization.

An example:

You can't hide Count column.

1 Like

Topic		Replies	Views
{"min_doc_count"} on Unique Count aggregation Kibana	2	3366	May 1, 2019
Filter results on "Unique Count" aggregation Kibana	4	1270	March 5, 2020
Need query to filter two field and get the unique count bases on one field Kibana	5	5509	March 19, 2020
Display all documents with duplicated value of a given field Kibana	10	4764	June 6, 2019
Use unique count 'metric' visual combined with a filter Kibana	3	2749	July 6, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Unique feilds count

Related topics