ExcelDashboardWidgets

[srmazurk]

I would like to have multiple traffic lights set up by an area (ex. HR) where each traffic light has a different metric it is showing. The hurdle is that each traffic light will have a different threshold. Can I set up a single widget to have multiple traffic lights where each traffic light has a different measurement and upper/lower limits?

[DashboardWidgets]

Hi Srmazurk

Currently the traffic light widget contains four separate traffic lights - with a single set of cut-off thresholds that affects all four traffic lights.

However, please find below a custom traffic light widget (four traffic lights with four customizable cut-off thresholds - one for each traffic light) that we have prepared especially for you (actually the standard commercial version is set-up for individual thresholds, we just added some configuration fields).

Srmazurk Dashboard.xlsx

(17.08 KiB) Downloaded 847 times

As you are probably aware, depending on your needs it is also possible to copy either the widget or the number of traffic lights within the widget to track as many metrics as your dashboard requires. For example, here is an image of a single traffic light widget with eight traffic lights..

You can also find more information on duplicating the widgets here..

http://www.exceldashboardwidgets.com/ph ... p?f=7&t=65

I hope this helps. Please, if anything is not clear feel free to get back to us.

Good luck with your dashboard project.

Best wishes

DashboardWidgets

[DashboardWidgets]

Hi Stillbatt

It shouldn't be a problem to implement what you are requesting.

You can find a few examples of selecting a name from a drop down list and updating the data shown on the dashboard here..

http://www.exceldashboardwidgets.com/ph ... m.php?f=24

If you can give us a little more clarity in terms of exactly what you are trying to do we are happy to provide you with a working example.

Warm regards

DashboardWidgets