Getting started with bullet charts
Bullet charts are a variation of bar charts. They compare a featured measure (the bullet) to a targeted measure (the target). They also relate the compared measures, Revenue for example, against colored regions in the background that provide additional qualitative measurements, such as good, satisfactory, and poor.
Bullet charts are often used instead of gauge charts in executive dashboards. Bullet charts can be horizontal or vertical.
A bullet chart contains the following components:
A bullet measure, which appears as the blue bar in the chart
A target measure, which appears as the black indicator in the chart
From zero to five colored regions along the numeric scale to provide information about the featured measure's qualitative state
A label that identifies the measures
A numeric scale
Getting ready
For this recipe, we will use the GO Data Warehouse (query) package.
How to do it...
In this recipe we will create a bullet chart and check some of its properties. To...
