on my home labb I somehow had my influxdb upgraded to 2.0 and now all my queries cant be used anymore. So I´m trying to learn the Flux queries.
one example is that I have temperature data from different devices.
I´m graphing with Grafana.
This below will give a table with timestamp and friendly_name of the device. If I would like to have this for a graph and include the field temperature, how would that query look like?
I would like to have one line in the graph per device(friendly_name) and display the field temperature with the accual data.
from(bucket: "mqtt") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "zigbee2mqtt") |> filter(fn: (r) => r["_field"] == "friendly_name") |> yield(name: "last")
I will also add some information about the setup: