Show only daily differences

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    Grafana v11.6.1 on Ubuntu

  • What are you trying to achieve?
    I have a data source that reports total water consumed. One row every 5 minutes.
    I would like to display daily consumption.

I need to:

  • use only the last value for each day
  • calculate differences between current and previous day
  • show bar graph for the daily differences
  • How are you trying to achieve it?
    I have no clue how to
  • use only the last value for each day
  • calculate difference between current and previous day

Any help appreciated.

2

What is your datasource? And what does the data sample look like

3

Datasource: Checkmk

Data:
2025-07-02 00:55:00   0.391 m3
2025-07-02 01:00:00   0.391 m3
2025-07-02 01:05:00   0.391 m3
2025-07-02 01:10:00   0.391 m3
2025-07-02 01:15:00   0.391 m3
4

I solved the problem by creating a custom PHP script that reads the data from the datasource, calculates the daily values and exports them as JSON data.

1 Like