Dear community,
I am plotting measurement values stored in an influxdb with Grafana as bar plot. The values are aggregated on a daily basis ( aggregateWindow(every: 1d, fn: sum). Under certain conditions the measurement drops out and the daily sum does not become meaningful. I want to set the value of those these days to a predefined value.
My idea to implement this is so far like this:
Count the entries of my measurement per day and store them in a separate value:
|> filter(fn: (r) => r._measurement == "my_measurement")
|> aggregateWindow(every: 1d, fn: count, createEmpty: false)
|> map(fn: (r) => ({ entries:r._value, Time:r._time,}))
If there are less than 1000 entries per day, the data of that day is invalid. Currently I am struggling on the correct way to implement this. I am trying this with a math-expression. “$entries > 1000” gives a 0/1 plot. But I could not figure out how to implement something like “if ($entries > 1000) then <put out $my_measurement> else $my_measurement = -1”.
Any hints on implementing this would be appreciated!
Thanks!