hello, I need some help please how can I group data in this table to show them just in one row group by _type [image] my filter configuration is the following filter { mutate { add_field => { "heureDeDebut" => "" "heureDeFin" => "" "codeDeRetour" => "" } } grok { ma…

I think you can do this by using multiple top hit metrics. e.g.: [image] As opposed to multiple buckets: [image]

Thanks, but I've problem with the comma, it shows value,-,- wich aggregation did you choose ?? for the line wich content the variable a , the other variables did exist ?? like an empty string ?? or doesn't existe at all for the same line ? [image] thanks :slight_smile:

Ah, scratch that, you can't do it with top hit metric (that is the metric aggregation I choose). It may have only worked in my example because of a fluke, or because I didn't have a time field. The Top Hit metric chooses the most recent value in the document, which may be an empty string. It's alm…

Thank you so much, I choosed Top Hit and it woks :slight_smile:

Discuss the Elastic Stack

Group by data in data table kibana [Solved]

Elastic Stack Kibana

Chemse (Taloub) July 11, 2017, 3:52pm 5

Thank you so much, I choosed Top Hit and it woks

Topic		Replies	Views
Grouping documents in kibana based on a column without losing the rest columns Kibana	4	760	December 6, 2019
Creating data table using group by like clause in Kibana? Kibana	2	6458	July 6, 2017
Kibana Data Table to group by fields Kibana	3	8722	March 6, 2020
Group by data in data table using Kibana Kibana	2	13874	July 6, 2017
Group by in Kibana Lens Kibana elastic-stack-monitoring , elastic-stack-alerting , lens	1	670	April 29, 2024

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.

Group by data in data table kibana [Solved]

Related topics