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
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