Daily totals precipitation

  • What Grafana version and what operating system are you using?
    9.4.7 on raspi_pi

  • What are you trying to achieve?
    I need a bar chart showing the summed daily precipitation amounts: 24.07: 4mm, 23.07: 7mm, 22.07: 2mm

  • How are you trying to achieve it?
    from(bucket: “data”)
    |> range(start: -7d, stop: now())
    |> filter(fn: (r) => r[“_measurement”] == “WeatherSensors”)
    |> filter(fn: (r) => r[“STATION_ID”] == “01”) |> filter(fn: (r) => r[“_field”] == “rain”)
    |> aggregateWindow(every: 1d, fn: sum)

  • What happened?
    The dates on the x axis only fit for today, otherwise it is shifted by 1 day (for yesterday it also says 24.07.)

  • What did you expect to happen?
    The correct date should also be displayed for the other days

Welcome @pcfritz

Have a read through this and see if some of the recommendations made there helps with your date display on the x-axis.