Gauge bar not uses full column width

Grafana Dashboards
1

Hello,

  • What Grafana version and what operating system are you using?
    Grafana 9.3.1 on Linux Debian GNU/Linux 10 (buster) using InfluxDB2 data

  • What are you trying to achieve?
    user a gauge bar chart to present 24h windows of water usage and calculated price

  • How are you trying to achieve it?
    Flux language - script and overwrites

  • What did you expect to happen?
    the bar with the highest value in the last 14 days uses the full column width

  • Can you copy/paste the configuration(s) that you are having problems with?
    see below script and result. If I delete the 3.6563 multiplier for getting the price, all works good.
    I tested also by dividing by 10, then also the bars use the full window.
    It looks like, that the column width “auto mode” uses the resulting costs value _cost for the width calculation and not the _value one.
    Is this a bug or do I have to solve this in a different way?

a) Script

import "timezone"
option location = timezone.location(name: "Europe/Berlin")

from(bucket: "SmartHome")
  |> range(start: -14d)
  |> filter(fn: (r) => r["_measurement"] == "watermeter.verbrauch" and r["_field"] == "value")
  |> difference()
  |> aggregateWindow(every: 24h, fn: sum, timeSrc: "_start")
    |> map(fn: (r) => ({ r with  _cost: r._value * 3.6563}))

B) result

image
image2069×1329 269 KB

C) Overwrite for this column

image
image601×712 44 KB

Thanks for any idea.

2

Hallo gnomi, wie ich sehe hast du auch AI on the edge im Einsatz bessergesagt das watermeter, richtig?

Speicherst du auch nur den geänderten Value Wert in der Influxdb?

Wäre es möglich das du dein Dashboad zur verfügung stellst?

Kämpfe aktuell auch mit der Auswertung und hab noch nicht wirklich einen Schimmer was Sinn macht.