Influx 2.0 value and time pairs to display (ignoring influx timestamp)

[alexandrearmand]

hello,
i notice few things,
first :
this is the same issue in this post,

Table with Influx 2.0

Ho i see it now, i was blind ! You created a single _field for all your value, and you use a _measurement as a _field, It’s not a standard structure, you should consider to change it. You can still make this work by changing your pivot like that : from(bucket: "ShellyInfo") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_field"] == "value") |> filter(fn: (r) => r["_measurement"] == "ID" or r["_measurement"] == "fw_ver" or r["_measurement"] == "ip" or r…

i mean measurement is used as a field , and field is used as value.

second most important:
I notice you store a time field in a time series database.
if you look at any query result in influxdb you can notice every value have already a _time field , (even your time field have a time value ). this is one of the key concept of time series db.

I suggest you to stop store a time field and change your struct if you can.
if you can’t change your struc i can still help to make this working