Using this query from this post Difference Between 2 values in a query? import "math" First = from(bucket: "LB3000") |> range(start: today()) |> filter(fn: (r) => r["deviceId"] == "Okuma-LB3000") |> filter(fn: (r) => r["dataItemId"] == "Lppartcount") |> toInt() |> first() Last = from(b…

Difference reports negative value

fastxl August 30, 2024, 4:20pm 4

@scott Thanks for the help. I’d like to expand this to get a daily count for the last 7 days or any time frame. For each function by day?

Forget it. I found your work here Flux: First, Last and the differnce per day that answered this question.

Topic		Replies	Views
Migrating to flux math question flux	2	393	June 1, 2021
Flux query error => data type problems Fluxlang influxdb , chronograf , flux	1	4866	January 6, 2021
Keep on getting int != float error in flux query below Fluxlang	2	2242	May 2, 2022
Map math division and integers Fluxlang	3	1568	January 7, 2019
How to exclude the value or prevent the calcature when use difference() if previous value is null ? Sencond InfluxDB 2 influxdb , influxdata , influxql , query , flux	3	778	March 20, 2023