I am trying to have treshold values in a time series panel change depending on another variable.
Use case: I am setting up monitoring of two off grid stations that are powered by wind generators. Those two stations are pretty similuiar, but using two different wind generators. One needs a wind of 2m/s before it starts producing electricity, the other needs 4 m/s.I am plotting forecasted wind speed and would like to show a treshold value for when we can expect them to produce electricity.
I had set up a dashboard for one of the stations, now I am rewriting this to a dashboard where I can select a station name to get an overview of one of them. This works fine, except that I cannot get the treshold values to change.
My plan was to use some SQL to get the treshold value depending on the selected station name. The first test was to just refactor the panel to use a static variable set to a number to define the treshold. I can type the in variable name for the treshold, but it will just dissapear.
$productionstart is set to 4, it is shown as 0 when I type it in, then the line will dissapear as soon as I go back to the dashboard.
So my question is:
Is there any way to dynamically set tresholds dependent on a variable in the dashboard?
Using grafana 12.3.1 running on a local rocky linux machine
(in fact, I took it for granted that I could use a variable in a treshold, so I was planning to write a questions if there was an easier way to set a variable defined by another variable than using SQL to make a lookup table)