[image] yosiasz:
Might want to post in influxdb forum
Well … might be right. I will try it with the idea from your posted link.
But if there are any grafana based ideas I would indeed prefer them over any influxdb tweaks.
Thx. Answer from robertortel on community.grafana.com
Grafana
community.grafana.com › t › how-to-cumulative-sum-for-kwh-that-resets-daily › 5518
How to - Cumulative sum for kWh that resets daily - Grafana Labs Community Forums
February 16, 2018 - Hi, In an Influx database I have watts being logged and have a CQ that creates kWh data. I would like to graph cumulative kWh consumption during the day to show energy usage that grows throughout the day and the reset …
Stack Overflow
stackoverflow.com › questions › 69223547 › grafana-query-to-generate-a-cumulative-sum-from-the-same-time-every-day
influxdb - Grafana query to generate a cumulative sum from the same time every day - Stack Overflow
I need to present a Grafana time series graph starting at 05:00 every day. The time series graph needs to show a cumulative sum of 2 mass flow meters until 05:00 the next day, at which time it rese...
How to graph a cumulative sum of different influxdb series
Hi all, I am using grafana 10.4.1 as part of home assistant on a raspi 4 together with influxdb 1.8.10. I want to have a cumulative sum in a graph of my savings from my solar panels. That is easy in my eyes as long a the kWh cost remains constant. I do have a metric with the sum of the self-used ... More on community.grafana.com
5
0
April 4, 2024Show total consumption by day
Hello guys, I’ve a signal which is a current consumption of my home in watts. I get this value every second. I already was able to make a graph to show it over time Also another graph to show total consumption for a particular time frame selected Now what I’m trying to do is to draw a graph ... More on community.grafana.com
19
0
June 24, 2021Add all values of a day and display the result
Hello, im absolutely lost at the moment. I have a table with two colums: Date and Value 2022-09-12 22:35:01 10 2022-09-12 22:35:11 20 … So what I need: a) The sum of all values of the actual day b) The count of values per day c) as result: a)/b) (Sum of all values per day / count of values) ... More on community.grafana.com
2
0
September 12, 2022Cumulative sum over time
Hello I’m trying to simply display the cumulative sum of my rain gauge over a certain periode of time. The rain gauge has a 5min resolution , that i would like to see over one 1hour As you can see on the graphs , the cumulative sum almost work but never goes back to zero when it doesn’t ... More on community.grafana.com
3
1
January 31, 2021OneUptime
oneuptime.com › home › blog › how to create cumulative function that resets daily in grafana
How to Create Cumulative Function That Resets Daily in Grafana
December 17, 2025 - Create a base query that returns the increase per interval: # Query A: Increase per minute increase(http_requests_total[1m]) ... This creates a cumulative sum that naturally resets when a new day begins (if you set your time range to "Today so far").
Grafana
community.grafana.com › dashboards
How to graph a cumulative sum of different influxdb series - Dashboards - Grafana Labs Community Forums
April 4, 2024 - Hi all, I am using grafana 10.4.1 as part of home assistant on a raspi 4 together with influxdb 1.8.10. I want to have a cumulative sum in a graph of my savings from my solar panels. That is easy in my eyes as long a the kWh cost remains constant. I do have a metric with the sum of the self-used ...
Grafana
community.grafana.com › time series panel
Show total consumption by day - Time Series Panel - Grafana Labs Community Forums
June 24, 2021 - Hello guys, I’ve a signal which is a current consumption of my home in watts. I get this value every second. I already was able to make a graph to show it over time Also another graph to show total consumption for a particular time frame selected Now what I’m trying to do is to draw a graph ...
Grafana
community.grafana.com › dashboards
Add all values of a day and display the result - Dashboards - Grafana Labs Community Forums
September 12, 2022 - Hello, im absolutely lost at the moment. I have a table with two colums: Date and Value 2022-09-12 22:35:01 10 2022-09-12 22:35:11 20 … So what I need: a) The sum of all values of the actual day b) The count of values per day c) as result: a)/b) (Sum of all values per day / count of values) ...
Grafana
community.grafana.com › t › cumulative-sum-over-time › 42434
Cumulative sum over time - Grafana - Grafana Labs Community Forums
January 31, 2021 - Hello I’m trying to simply display the cumulative sum of my rain gauge over a certain periode of time. The rain gauge has a 5min resolution , that i would like to see over one 1hour As you can see on the graphs , the cumulative sum almost work but never goes back to zero when it doesn’t ...
Grafana
community.grafana.com › time series panel
Cumulation of values - Time Series Panel - Grafana Labs Community Forums
November 11, 2024 - Hello! I am currently working with Grafana v8.2.4 (d409b0ca16) on Microsoft 10. I tried to cumulate some values from my database, but somehow I miss a detail. My goal is to create a time series graph with process value…
Grafana
community.grafana.com › dashboards
How to do a basic summation? - Dashboards - Grafana Labs Community Forums
June 30, 2023 - What Grafana version and what operating system are you using? Running a Docker container from the grafana/grafana image, launched 6/28/23 so likely the most recent version. What are you trying to achieve? I’m trying to sum several metrics into one total number.
Reddit
reddit.com › r/grafana › how to display daily request counts instead of time series in grafana?
r/grafana on Reddit: How to Display Daily Request Counts Instead of Time Series in Grafana?
April 14, 2025 -
I have a metric in Prometheus that tracks the number of documents processed, stored as a cumulative counter. The document_processed_total metric increments with each event (document processed). Therefore, each timestamp in Prometheus represents the total number of events up to that point. However, when I try to display this data on Grafana, it is presented as time series with a data point for each interval, such as every hour.
My goal is to display only the total number of requests per day, like this:
| Date | Number of Requests |
|---|---|
| 2025-04-14 | 155 |
| 2025-04-13 | 243 |
| 2025-04-12 | 110 |
And not detailed hourly data like this:
| Timestamp | Number |
|---|---|
| 2025-04-14 00:00:00 | 12 |
| 2025-04-14 06:00:00 | 52 |
| 2025-04-14 12:00:00 | 109 |
| 2025-04-14 18:00:00 | 155 |
How can I get the number of requests per day and avoid time series details in Grafana? What observability tool can I use for this?
Grafana
community.grafana.com › t › cumulative-variable › 116983
Cumulative variable - Grafana - Grafana Labs Community Forums
March 14, 2024 - Hi, I’m new to Zammad and Grafana, and my boss has requested me to create some charts. I followed the official documentation on how to implement Zammad with Elasticsearch in Grafana to set it up. I’m currently working on a time chart and I need to set an acumulative variable that represents ...
Grafana
community.grafana.com › influxdb
Cumulative sum influxdb data - InfluxDB - Grafana Labs Community Forums
December 13, 2021 - Not sure, whether I’m in the right forum here. So please advise, if this is not the case. I’m using Home Assistant data from influxdb to display grafana charts. Basically, I would like to transform the first graph into t…
Grafana
community.grafana.com › t › cumulative-graph › 16385
Cumulative graph? - Grafana - Grafana Labs Community Forums
April 15, 2019 - Hi. I’m trying to work out whether, and if so how, the following is possible with Grafana (version 5.4.3 if it matters): I have an InfluxDB data set, which receives one numeric value per second from a data source. T…
Grafana
community.grafana.com › prometheus
How to get the cumulative/total resource usage of resources say RAM or CPU over a selected duration of time - Prometheus - Grafana Labs Community Forums
August 12, 2021 - Hi, I want to calculate the total consumption of memory/cpu usage (with underlying kubernetes infrastructure) monotonously over a period of time(lets say 3 months). I tried query like sum(container_memory_usage_bytes{namespace=~“$namespace”,pod=~“$pod”})/1024/1024/1024 I also tried to use the increase() and sum_over_time() functions to get the cumulative sum of the total resource consumed.
Grafana
grafana.com › docs › grafana › latest › panels › calculations-list
Calculation types | Grafana documentation
March 16, 2022 - The following table contains a list of calculations you can perform in Grafana.
Long-term Memory
blog.dest-unreach.be › 2020 › 08 › 16 › cumulative-graphs-prometheus
Long-term Memory – Cumulative graphs in Prometheus
August 16, 2020 - Both graphs show the same information, and for a single day, they don't differ much. But when comparing e.g. today to yesterday, I find a cumulative view much easier to read: are we ahead/behind "schedule" compared to yesterday? Especially when the power is very spikey, I find cumulative graphs much easier to interpret. Take a look for yourself: Next up: getting this idea of a cumulative graph translated into a Grafana dashboard.
Grafana
community.grafana.com › influxdb
Get daily usage from cumulative energy values, only 1 value/day, but not always added at same time - InfluxDB - Grafana Labs Community Forums
February 6, 2022 - This is the data (energy used for heating → cumulative) in the InfluxDB so far for the current month: Every day, after midnight, the usage of the previous day is produced, and added to the Influx ...