[image] zanzeoo: Does anyone can help me plz Thx yes off course you need a function non_negative_difference and group by manybe one hour or whatever you like Answer from melrose on community.grafana.com
🌐
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 › 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 kWh and this can be multiplied by some constant kWh cost.
Discussions

Cumulative sum influxdb data
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 the second graph. The source sensor gets reset to zero occasionally ... More on community.grafana.com
🌐 community.grafana.com
2
0
December 13, 2021
How to - Cumulative sum for kWh that resets daily
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 to zero each day as shown in the attached screenshot. More on community.grafana.com
🌐 community.grafana.com
3
0
February 16, 2018
charts - How do I show a cumulative sum of each series in a Grafana multi series? - Stack Overflow
@Christian I eventually went a different way, creating the cumulative values in the database query and passing as little and as simple data as possible to Grafana. This was also because Grafana was crashing due to the CPU load of all these transformations. More on stackoverflow.com
🌐 stackoverflow.com
Cumulative graph?
I’m trying to work out whether, ... 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. This value may be zero, or a (usually small) positive integer. I want to display a line graph of the cumulative sum of the values ... More on community.grafana.com
🌐 community.grafana.com
2
0
April 15, 2019
🌐
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 › 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 › 79728381 › how-do-i-show-a-cumulative-sum-of-each-series-in-a-grafana-multi-series
charts - How do I show a cumulative sum of each series in a Grafana multi series? - Stack Overflow
Currently I am achieving this using the Prepare Time Series (Multi-Frame Time Series) transformation to create a frame for each category. Then I have to add a Add Field From Calculation (Cumulative Function, Total) transformation to get a new cumulative field to use, and filter out the original fields.
🌐
Grafana
community.grafana.com › t › cumulative-graph › 16385
Cumulative graph? - Grafana - Grafana Labs Community Forums
April 15, 2019 - I’m trying to work out whether, ... 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. This value may be zero, or a (usually small) positive integer. I want to display a line graph of the cumulative sum of the values ...
🌐
Grafana
community.grafana.com › elasticsearch
Transformation then cumulative sum - Elasticsearch - Grafana Labs Community Forums
March 22, 2021 - I have a graph showing 2 Elasticsearch queries “Attempted” and “Failure” as numerical data. Then I use “Add field from calculation” transformation to have a new graph line “Success”. How can I show the cumulative sum lin…
Find elsewhere
🌐
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.
🌐
GitHub
github.com › grafana › grafana › issues › 20982
running total / cumulative sum · Issue #20982 · grafana/grafana
December 9, 2019 - My data looks like this: 0 0 1 1 0 1 0 1 1 0 0 1 My graph should use these values: 0 0 1 2 2 3 3 4 5 5 5 6 I've found no way to get this so I request it here. My use case: I monitor pumps and valves. What I have in the database is 1 for ...
Author: grafana
🌐
InfluxData Community
community.influxdata.com › influxdb 1 › influxql
How to get a cumulative sum of a product from different series? - InfluxQL - InfluxData 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 kWh and this can be multiplied by some constant kWh cost.
🌐
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
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.
🌐
Grafana
community.grafana.com › stat panel
Show calculation value from two cumulative sum series - Stat Panel - Grafana Labs Community Forums
December 15, 2020 - Hello, We have two data series from our factory: A = Planned output (value = 1 every 15 minutes, otherwise empty) B = Actual output (value = 1every time a product is finished, otherwise 0) I show the actual output against the planned output in a graph using the cumulative sum for both.
🌐
Reddit
reddit.com › r/grafana › sum and integral doesn't do anything
r/grafana on Reddit: Sum and integral doesn't do anything
February 11, 2021 -

I have an InfluxDB containing a field with distances since the last measurement. If I make a graph of this field, I get a graph fluctuating around few meters, since the speed is around a few meters per second.

I want a graph of the total distance travelled, but if I choose aggregate functions SUM or INTEGRAL, I get more or less the same graph as without. For one thing, this graph should be increasing over the entire interval.

If I read the InfluxDB documentation here https://influxdbcom.readthedocs.io/en/latest/content/docs/v0.6/api/aggregate_functions/#sum, it seems that SUM is exactly what I want, yet I don't really see a difference.

🌐
Graphite
graphite.readthedocs.io › en › latest › functions.html
Functions — Graphite 1.2.0 documentation
When a graph is drawn where width of the graph size in pixels is smaller than the number of datapoints to be graphed, Graphite consolidates the values to to prevent line overlap. The cumulative() function changes the consolidation function from the default of ‘average’ to ‘sum’. This is especially useful in sales graphs, where fractional values make no sense and a ‘sum’ of consolidated values is appropriate.