Good Morning @Anaisdg ,
thx for your answer. My query is:
Fruehschicht = from(bucket: line)
|> range(start: -14d)
|> filter(fn: (r) => r._measurement =~ /_test_bottle_burst/ and r.status == “Good”)
|> hourSelection(start: 4, stop: 12,)
|> aggregateWindow(every: 24h, fn:last, )
|> map(fn:(r) => ({Fruehschicht:r._value,time:r._time }))
|> yield(name:“Fruehschicht”)
Spaetschicht = from(bucket: line)
|> range(start: -14d)
|> filter(fn: (r) => r._measurement =~ /_test_bottle_burst/ and r.status == “Good”)
|> hourSelection(start: 12, stop: 21,)
|> aggregateWindow(every: 24h, fn:last, )
|> map(fn:(r) => ({Spaetschicht:r._value,time:r._time }))
|> yield(name:“Spaetschicht”)
Nachtschicht = from(bucket: line)
|> range(start: -14d)
|> filter(fn: (r) => r._measurement =~ /_test_bottle_burst/ and r.status == “Good”)
|> hourSelection(start: 21, stop: 5,)
|> aggregateWindow(every: 24h, fn:last, )
|> map(fn:(r) => ({Nachtschicht:r._value,time:r._time }))
|> yield(name:“Nachtschicht”)
|> sort(columns: [“Fruehschicht”, “Spaetschicht”, “Nachtschicht”])
for this grafana shows me only “Fuehschicht” and “Spätschicht”.
