I am trying to filter NaN value in Flux resultset, but I got the error like:
response:"error cannot compile @ 13:17-13:38: unsupported binary expression float != string "
message:“Internal Server Error”
Does there any one have idea what’s the correct value to filter data.
Query Code:
import “math”
from(bucket: “kafka_signals/oneDay”)
|> range(start: 2020-02-20T00:00:00.000000000Z)
|> filter(fn: ® =>
r._measurement == “signal” and
(r[“signal.name”] == “TCU_GPS_Data_Latitude” or r[“signal.name”] == “TCU_GPS_Data_Longitude” or r[“signal.name”] == “TCU_GPS_Data_Altitude” or r[“signal.name”] == “TCU_GPS_Data_Speed”))
|> pivot(
rowKey:["_time",“vin”],
columnKey: [“signal.name”],
valueColumn: “_value”)
|> rename(columns: {TCU_GPS_Data_Longitude: “lon”})
|> rename(columns: {TCU_GPS_Data_Latitude: “lat”})
|> filter(fn: ® => r.lon != NaN)