Hello, I need a bit of help to build a split series visualization. I have an time-series index containing temperature and humidity in different locations. Here is a sample entry: { "@timestamp": "2019-02-04T00:00:00", "location": "Rome", "temperature": 26, "humidity": 43 } I want…

I think so. Which visual builder are you using? If it's a line chart -> metric: max or average humidity, whichever you're looking for Terms aggregation => temperature ordered by custom metric (avg temperature) => date histogram

Hi Jon, Thanks for the answer. I'm using Kibana and it's a line chart indeed. What you are describing is almost what I was able to come up with myself and that is: Metric: average "humidity" Buckets: Split Series: Terms aggregation on "location" order by custom metric = max "temperature" X-Ax…

This works indeed but with the expected drawback: it takes much longer to produce a result since it needs to bring everything from each shard to the coordinating node. And in production might actually cause the whole system to fail due to memory pressure. Also, if I set a lower value I won't be gua…

Split series containing top N terms sorted by numeric field

Elastic Stack Kibana

jbudz (Jon Budzenski) February 20, 2019, 4:26pm 4

Hmm, that's a tough one. Is bumping the shard_size an option? https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-bucket-terms-aggregation.html#_shard_size_3

Topic		Replies	Views
View time series for top X keywords Kibana	2	464	February 12, 2020
Selecting only top 5 values from split series Kibana	3	3381	January 25, 2018
Kibana line chart limit number of lines over date histogram Kibana	3	2709	July 6, 2017
"Split series" in "Line" visualization super slow Kibana	2	1224	July 10, 2020
Show total count on line graph when using split series bucket Kibana	3	1872	November 27, 2020

Split series containing top N terms sorted by numeric field

Related topics