Very noob question, but here goes…
In the graph shown above, the “setpoint” is 90. We are permitted +/- 5 degrees, so I went into Edit mode and put two Threshholds at 85 and 95 and the result is exactly how I want the graph to look.
However, the above process was entirely manual and everyday users of this graph will not be able to edit the graphs. And the setpoint will change many times throughout the day. For example, the job next hour will have a setpoint of 120, meaning the new Threshholds are 115 and 125.
I know Threshholds cannot be dynamically assigned, so I think the next best approach would be to have a user input value representing the setpoint, and then build 2 queries (one for the “upper Threshhold” and one for the “lower Thresshold”) and then plot those on the graph. I think this can be done, but can someone give me a definite “Yes” and point me in the right direction? Thank you in advance.