Hello, I have that Graph: SELECT mean(“value”) FROM “Volumen_OelTank” WHERE $timeFilter GROUP BY time($interval) fill(null) which shows the Volume of my tank. Now I’d like to see how much I use like every day or every week. So I like to show the difference between a value and the value one day/7d…

For anyone that is still trying to write a query to get the difference of a value over time with InfluxDB (InfluxQL), I wrote a small blog post where I provide an example and a query based on the answers shared in this post. [image] How to calculate the difference of a value over time with …

How to: value(now) - value(some time ago) to see Difference over time?

au190 December 2, 2020, 10:10am 16

Iam searching for the same, does anybody know how to calculate such info ?
For IOT, its a basic info, I cannot beleive its not possibile a coorect caluclation of ON time.

Topic		Replies	Views
Get difference of the last hour InfluxDB	2	8931	February 28, 2019
Time series shift the timestamp for one series Time Series Panel	0	35	April 8, 2025
Show where value is under x for 7 days Dashboards influxdb , timestamp , flux	1	617	June 26, 2022
Difference between two singlestat values? Stat Panel	6	5148	November 12, 2019
Where is my last value! InfluxDB	1	2308	February 11, 2023

How to: value(now) - value(some time ago) to see Difference over time?

Related topics