Too many lines in Line Chart

Elastic Stack Kibana
1

Hi There,
i have crated a line chart visualization.
In this visualization i use date histogram for x axis and count of a value for y axis. The visualization is ok but i have too many different counts. Kibana is showing me too many lines in the chart. Is it possible to show only the top 5 counts?

2

Hi there, for a date histogram you can change the "Interval" value for your bucket aggregation to change the number of buckets (bars). Here's how switching from an interval of "Minutes" to "Hours" reduces the number of bars in an example chart:

image
image.png1695×1192 102 KB

image
image.png1697×1189 104 KB

I can also choose a custom interval to more precisely define how many bars should show up. In this example, I've chosen a custom interval of 6h. Dividing my 24 hour time period by this interval results in 5 bars.

image
image.png1699×1190 107 KB

Hope this helps,
CJ

3

Hi cj,

thank for your response.
I found another way of doing it. Maybe this will be a help if someone searches for it :slight_smile:

I have craeted a timelion visualization and set a limit.

.es(q='', split=hops.keyword:5, metric=avg:size)

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.