On the linear dial widget if you enter a value greater than max the needle goes off the chart. How do you fix this while leaving the max value the same. i.e needle stops moving at max value, yet value in circle stays the same.
Re: How to stop needle at max
PostPosted:Sun Nov 05, 2017 7:00 am
by DashboardWidgets
Hi mr47119
The easiest way to do this is with an IF conditional statement on the Widget Calculations Page.
=IF('My Dashboard'!N11>D7,D7,IF('My Dashboard'!N11<D6,D6,'My Dashboard'!N11))
PSEUDOCODE:
IF the linear dial widget is greater than the max scale value THEN make the value the max scale value.
IF the linear dial widget is less than the minimum scale value THEN make the value the minimum scale value.
Feel free to take a look at the example attached. We've also prepared a short video that explains how we set the example up.