Hi, I’ve made my first query with Flux to extract data that comes from Home Assistant, like so: from(bucket: "homeassistant") |> range(start: 2022-08-10T00:00:00Z) |> filter(fn: (r) => r["entity_id"] == "previous_car_charge_distance") |> filter(fn: (r) => r["_field"] == "value") |> drop(col…

OK, I think this will work… from(bucket: "homeassistant") |> range(start: 2022-08-10T00:00:00Z) |> filter(fn: (r) => r["entity_id"] == "previous_car_charge_distance") |> filter(fn: (r) => r["_field"] == "value") |> drop(columns: ["_measurement", "_field", "_start", "_stop", "domain", "en…

How to filter out unchanged values (with difference() == 0) in Flux?

InfluxDB 2

Hukondora February 1, 2023, 12:20pm 13

Hi @grant1,

I think I have a similar issue and hope that you might be able to help with that too, so I will post it here:

Thank you!

Topic		Replies	Views
Flux and math operations Fluxlang flux	1	463	January 2, 2022
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	673	March 20, 2023
Filter data in table based on value of one column, keeping other data InfluxDB 2 influxdb , query , flux	6	3438	May 19, 2020
Filter out 0 in results in flux InfluxDB 2 flux	2	399	May 24, 2023
Flux query for multiple tables each with the last value subtracted from all values Fluxlang query , flux	5	778	February 26, 2024

How to filter out unchanged values (with difference() == 0) in Flux?

Related Topics