I have a use case that I think would be fairly generic but, I am not getting the expected results.
Use case: An ultrasonic sensor is measuring the distance (in cm) from the top of a tank to the liquid level. I want to have a widget on the dashboard that displays the % full. The formula is straightforward.
Percent = (( Distance to liquid surface - Distance to bottom) / ( Distance when full - Distance when empty) *100
Thing is that I wanted to allow for different installations to have different tanks. So, I created raw variables for Distance to Bottom and Distance when full) and put sliders on the dashboard to allow a user to set the variables. I created a synthetic variable with the formula above which was deemed valid by the formal editor.
Think is that inputing the raw variables using the sliders or sending another data point from the device Never triggers the calculation of the “Percent”