Conditional Charts in the Dashboard

KenR

I would like to display a KPI if a condition is true ([boolean field] = true).

Scenario: I have a helper sheet checking data entries for errors and a second helper sheet counting the errors. I would like to display a KPI on the dashboard showing the count of errors only if errors exist. The KPI then points to a report that allows the user to fix the errors.

Always displaying the KPI clutters the dashboard. Always displaying the KPI risks the metric being ignored when 99% of the time its zero - especially without a condition formatting option. By conditionally showing a Chart the dashboard is kept clean and we make best use of exception management principles. (Using a report instead of a KPI where conditional formatting works is an ugly work around that still doesn't return the desired effect.)

Displaying KPI's based on current user would be useful as well.