Is there, and if yes what is the best practice/recommended way to store threshold values as part of a measurement.
Let me give you an example what I want to achieve:
I have temperature sensor data coming in:
timestamp, location, … min_val, max_val, … value
In my query I want to check, in the where clause, if the value is within boundaries (alert) (value <=min_val and value >=max_val). If I store the min_val and max_val as tags it is treated as a string so doing the test as described doesn’t work.
I can of course, make the min_val and max_val fields (instead of tags) and I suppose the where clause then will pass. But is this the way to do it? I thought tags are the meta data for the timeseries/measurement, and aren’t min_val and max_val no meta-data?!
Any help/recommendation very much appreciated.