How to place the field name under each bar in a bar chart visualization?

Grafana Bar Chart Panel
1

Grafana v11.1.4 (2355de00c6) (running inside a docker container)

I would like instead of using the x axis for the time to place the field name below each corresponding bar. So that the user can automatically recognize which bar is for which sensor value.

Right now my Bar chart looks like this:

grafik
grafik1151×381 22.4 KB

Instead of the time I would like to place the names of the Values (BME280_Humidity, BME280_pressure and BME280_Temperature) below the corresponding bars.

This is how my flux query looks like:

from(bucket: "sischamo")
  |> range(start: v.timeRangeStart, stop:v.timeRangeStop)
  |> filter(fn: (r) => r._measurement == "sensor_data")
  |> filter(fn: (r) => r._field == "BME280_Humidity" or r._field == "BME280_Pressure" or r._field == "BME280_Temperature")
  |> first()
  |> drop(columns: ["_start", "_stop", "_measurement", "type", "nav_status"])
  |> pivot(rowKey: ["_time"], columnKey: ["_field"], valueColumn: "_value")

This is how my query table looks like:

grafik
grafik1167×69 8.15 KB

I would appriciate any help.

2

Check out the play.grafan.org demo:

https://play.grafana.org/d/barchart-label-rotation-skipping/barchart-label-rotation-and-skipping

i see you are pivoting to a single row with multiple columns, but the examples show the labels as a column value from each row…

3

I also tried to order all fields as rows but unfortunately if I do this with flux and pivot() I get this table:

grafik
grafik1171×721 37.3 KB

How can I fix this with flux or with a transformation?

4

try a concatenate transformation to join the multiple results?

5

How does your table looks like without ‘pivot’ line.
Can you paste screen print from that, thanks

6

This is the data table without pivot:

grafik
grafik1176×720 30.4 KB

7

@shyney7
I am afraid with that table structure i don’t think it will be possible.

closest i could get is something like this.

image 1

image
image1581×405 17.3 KB


image 2

image
image1581×214 14.8 KB

8

This is exactly what I want. How have you done it?

9

For that I think you will need to sacrifice/drop your ‘_time’ column (at the end of your query) above the yield field. Otherwise it’s not going to work.

See my table structure it doesn’t show the ‘headers’ but the values from the rows.
Maybe you can map another column “sensor type” with value/name of your headers “ BME280_Humidity” etc and after that you can use pivot