Threshold level changes dynamically

[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…