Gauge with dynamic maximum value

(Michael) #1

I have a data coming from logstash that shows how much space is used on a table in a database and maximum allocated capacity for a table. I want to create in Kibana gauges for every table that show how much space is currently occupied.

The problem is that maximum available space sometimes changes so the limit for a gauge has to be set as a variable and I can't figure out how to do this. I also don't know how to show only data from current day on a dashboard for a time range. Data coming from logstash looks like that:

time  table_name used_gb max_gb
25.04.18 table_1  1.2  10.4 
25.04.18  table_2  4.6  5.0 
26.04.18  table_1  1.4  14.6 
26.04.18  table_2  4.9  5.0 

(Chris Davies) #2

Hi Michael,

You should be able to do this using the Time Series Visual Builder.

If you choose "gauge", then "panel options", you can specify "1" as your max value. Then in your gauge data settings, you can compute the dynamic ratio per table. Here's a screenshot of a similar setup:

Hope that helps!

How to get count in percentage in data table of kibana
Show only last records on a chart
(Michael) #3

Thanks it works! In older Kibana instead of Bucket Script I had to use Calculation Aggregation.

(system) #4

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