SSRS 2008 R2 KPIs with bullet graphs

Posted on SQL Server Central See other posts from SQL Server Central
Published on Wed, 22 Jun 2011 06:00:00 UT Indexed on 2011/06/22 8:28 UTC
Read the original article Hit count: 270

Filed under:

Key Performance Indicators are typically displayed in a scorecard with stop light indicators, which are either red, amber or green light icons. The limitation for these kind of indicators is that you can see the actual and target values in two different fields as well as see the status of the KPI in red, amber or green color. If the user wants to figure out the thresholds associated with the KPI, these values are generally not visible. Further, representing the threshold values in the scorecard itself defeats the purpose of the scorecard. The scorecard should display the KPI's status in the most summarized form and use a minimal amount of space on the dashboard. In this tip we would look at how to address this issue.

© SQL Server Central or respective owner