[solved] Flux: Query for last value

InfluxDB 2
,
1

Hello,
I would like to display the current value for the current day in this chart in Grafana:

image
image414×678 17.7 KB

The values for the current day are stored in a separate measurement, “Wind-currentDay.” However, I only need the last and current value for display purposes.

The query without the daily value looks like this:

from(bucket: “iobroker_all”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “Wind-PerDay”)
|> filter(fn: (r) => r[“_field”] == “value”)

The query should contain the data from “Wind-ProDay” and additionally the current data from “Wind-currentDay.” The data from “Wind-currentDay” should then be displayed in Grafana as an additional bar.

How do I adjust the query?

2

this is how it seems to work:

from(bucket: “iobroker_all”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “Wind-ProTag”)
|> filter(fn: (r) => r[“_field”] == “value”)
|> aggregateWindow(every: 1d, fn: last, timeSrc:“_start”)
|> yield(name: “protag”)
from(bucket: “iobroker_all”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “Wind-aktuellerStand”)
|> filter(fn: (r) => r[“_field”] == “value”)
|> aggregateWindow(every: 1d, fn: last, timeSrc:“_start”)
|> yield(name: “akttag”)