Home Page Knowledge Base Support Forum Free Downloads

How to stop needle at max

Please post your comments related to configuring the ExcelDashboardWidgets spreadsheets here.

Moderator: DashboardWidgets

How to stop needle at max

Postby mr47119 » Mon Sep 01, 2014 2:47 pm

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.
mr47119
 
Posts: 1
Joined: Fri Aug 29, 2014 11:50 am

Re: How to stop needle at max

Postby DashboardWidgets » Thu Sep 04, 2014 9:14 pm

Hi mr47119

The easiest way to do this is with an IF conditional statement on the Widget Calculations Page.

Here is the IF statement in Excel and Pseudocode.

Code: Select all
=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.



MinMax Linear Dial Widget.xlsx
(28.82 KiB) Downloaded 330 times

Please note that the unlocked version of this widget can be downloaded in the Commercial License Holder's Forum here...

viewtopic.php?f=25&t=337

Warm regards

DashboardWidgets
DashboardWidgets
 
Posts: 332
Joined: Mon May 30, 2011 7:06 pm


Return to 1. Configuring the Spreadsheets



Who is online

Users browsing this forum: No registered users and 1 guest

cron