Threshold level changes dynamically

[rdineshtvk]

Panel - Stat Panel wanted to show the last value as Low, Normal, High based on Min and Max values
Problem - Data is from a manufacturing belt, which runs 2 types of articles in the line, hence min and max changes accordingly
If i want to use thershold or value mapping how use this min and max from a field to refer

[sowdenraymond]

Dynamic thresholds

I’m trying to add a dynamic threshold line to this time series. Is there a SQL formula that I can use to easily add one? The threshold options on the visualizations doesn’t show up on the graph. [time series]

Dynamic thresholds from queried fields

Found a solution by using this demo dashboard. In my JSON API query fields, I created a new field called compliance which is has two possible values green or red based on the values of value and min and max. The JSONata query looks something like this: $map(*, function($v, $i, $a) { ($v.min != null and $v.value >= $v.min) or ($v.max != null and $v.value <= $v.max) ? 'green' : 'red' }) Then use the transformation Config from query results following the same logic as the demo dashboa…

[rdineshtvk]

@sowdenraymond Thanks for your reply. Yes this should work. I have worked out using the transformations of applying below logic
Numerator = Value - Minimum(Variable)
Denominator = Maximum - Minimum
X = Numerator / Denominator
If X between 0 and 1 then Green colour, < 0 then Blue(low), >1 then Red(High)