I have this flux query:
from(bucket: “acquired_data”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._field =~ /.*${Source}_light.*/ or r._field == “${Source}_binaryError”)
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
r._field =~ /.\*${Source}_light.\*/ will return 3 values that need to be plotted.
r._field == "${Source}_binaryError" will return 1 value that is either 0 or 1.
I would like the graph to not plot the value of binaryError and only use it to determine if the other three lines should be colored red in case it is equal to 1.
Is it achievable? I’m fairly new to Grafana, maybe my approach is completely wrong and I’m making things more complex than they really are.