Hey, i have 2 time series which return Workorder IDs. The same IDs do not have the same timestamp within the two time series. Also only a few IDs from the first time series can be found in the second. Is there a way to compare the values in the two columns and post only those which cannot be fou…

@grant1 , You could use a drop() function to drop actual and setpoint. import "math" from(bucket: "bucket2") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "measurement2") |> filter(fn: (r) => r["EquipType"] == "generator") |> filter(fn: (…

Hi @Patse , Can you explain a little more about why the above does not work for your use case? Here is an example I run comparing my two CPU cores: from(bucket: "Jetson") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "exec_jetson_stats") |> …

The difference between our usecases is, that i have the data stored in 2 measurements. I have to create 2 seperate tables and use the union() function before I can use the map() function. Can this be the problem?

I would potentially consider using a join() instead. Check out this example here: union() function | Flux 0.x Documentation union() merges two or more input streams into a single output stream. This would potentially remove the need for a pivot. I see no iss…

Can you show me the output of your table after the pivot (remove the map function for now)? I want to see what the raw tables look like and the data types they hold. Many thanks :slight_smile: As my first assumption based upon your query is that you are trying to compare two values that actually wh…

[image] Jay_Clifford: pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") Thank you Jay. Very helpful info! Just to answer your original request, here is the output of the table without the map function (but with the pivot): [image] [image] I am still in the planning …

@grant1 sorry this makes alot more sense and you are correct to use actual and setpoint as tags like you intended. My confusion came from the fact that you were trying to compare the values of two tags i.e setpoint = "1000" < actual = "500" What you have done makes sense but sadly your query won’t…

@Jay_Clifford I pivoted on the tag column MeasType and I can indeed now perform conditional math on the setpoint vs. the actual. Thank you for explaining. One last question: How can one get the absolute value of the difference between setpoint and actual? The map function below works, but when I…

I figured it out. Just needed to sleep on this… |> map(fn: (r) => ({ r with alarm: if (math.abs(x: (r.setpoint - r.actual))) > 5 then true else false}))

This works for me in my original example: |> map(fn: (r) => ({ r with conditional: if math.abs(x: r.actual - r.setpoint) > 5 then true else false})) I believe the only changes you need to make is include x: variable is included within the abs function

Compare values in 2 columns

Fluxlang

grant1 November 4, 2021, 12:05am 4

@Jay_Clifford : Your example of comparing two CPU cores is very close to my query, where I wish to compare setpoint vs actual. However, I get the following error, despite that my query syntax generally mirrors yours. Any idea why mine won’t work?

Topic		Replies	Views
Trying to migrate influxql to flux InfluxDB 2	49	5091	August 30, 2021
Flux query to compare data b/w 2 tables InfluxDB 2 grafana , flux	18	1873	June 7, 2024
Can't emulate a simple query from mysql in flux (calculating extra column) Fluxlang influxdb , grafana , flux	7	1340	August 3, 2022
Having a ton of trouble with Flux and Joins Fluxlang influxdb , grafana , flux	9	1114	May 27, 2021
Find timerange based on the value of two Fields and plot annotation in range Fluxlang influxdb , grafana , query , flux	3	102	August 1, 2024

Compare values in 2 columns

Related topics