Bar gauge based on influx tag value leads to wrong visualisation

Grafana InfluxDB
1

Hey there,

I am a beginner in data visualisation with grafana. I read some tutorials and wanted to create a bar gauge based on tag data in influx (state=[green | yellow | red]).

I execute the following query:

from(bucket: "myBucket")
  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)
  |> filter(fn: (r) => r._measurement == "myMeasurement")
  |> group(columns: ["state", "_measurement"], mode:"by")
  |> count(column: "_value")

And I get the correct data in the tableview:

_start               green
xxx                   15

_start               yellow
xxx                   10

_start               red
xxx                   5

But when I switch to bar gauge representation, the height of the bars is not correct (e.g. “red” is too low for value 5)

Screenshot 2020-08-31 at 16.57.37
Screenshot 2020-08-31 at 16.57.372024Ă—376 12.4 KB

Do you have any idea?

Best
Stefan

2

It looks like it’s treating the min value (red: 5) as the lower bounds for the graph, and the max value (green: 15) as the max value. Have you tried setting the Min value for the graph to be 0?

1 Like
3

I changed to the bar chart and it worked out. Maybe I have not understood the “bar gauge” chart right :wink: