automating image display in a dashboard

Brian.Watson

One of my stakeholders is a big fan of visual information, and when viewing a dashboard, has asked for quick, visual way to assess the project health.

I have a tentative formula for calculating that health (=IF(((COUNTIF([Risks?]:[Risks?], 1) / COUNT(Tasks:Tasks)) / 100 <= 0.1), "low risk", IF(((COUNTIF([Risks?]:[Risks?], 1) / COUNT(Tasks:Tasks)) / 100 <= 0.33), "medium risk", IF(((COUNTIF([Risks?]:[Risks?], 1) / COUNT(Tasks:Tasks)) / 100 <= 0.5), "high risk")))), I've designed three graphics that can visually communicate that status.

I can manually add a graphic to the dashboard, sure, but is there a way to display one of these three graphics based on a calculated value?

NicoLHC

Hi Why don´t you use the Metric Widget?

Brian.Watson

It's definitely a workaround. My concern is that the small icon from a health metric won't convey the information as quickly.

NicoLHC

@Brian.Watson i suggest that you build up the system in different releases that means the audience can "slowly" get used to it ….. this is the best for the change process.