Gauges are a nifty visualisation that can show whether a target has been met or not. This is really powerful to know and showing this is such a visual way can have a huge impact on the understanding of the data. They can even be set up to change colour on this basis too.
What does a gauge look like?
A gauge looks a bit like an old fashioned petrol gauge (for those of you that are old enough). The target data figure shows in the centre with a line to show where the target figure is. If the shading stops before the target line then the target has not been met, after the line then it has.
How to create a Gauge visualisation
- Click on the Gauge icon from the visualisations pane
2. Add the numeric field to be analysed into the values box
3. Switch to the format your visual tab in the visualisations pane
4. In the gauge axis formatting set the min, max and target values. If Min and max are not set then the min will be zero and the max will be twice the value
5. The colour of the shading and the target line can be changed in Colors
6. The Data labels show the minimum and maximum values and can be turned off if not required
7. The Target label is the label shown next to the target line and can also be removed
8. The Callout value is the value from the data to be analysed
How to make the Gauge change colour
The gauge can be set to change colour depending on whether the target value is hit or not.
- Go to the Colors formatting option from Format your visual in the Visualisations pane
- Click on the fx button next to the fill color
- Change the Format style from Gradient to Rules
- Set the first rule as shown below. Assuming the target figure is 0.5, numbers between the lowest figure and 0.5 will turn red
- Click on + New rule
- Set the second rule as shown below. This will turn numbers between 0.5 and the highest figure green
Other Visualisations to show target values
It is important to show the context of any data shown on a dashboard and indicating whether a target value has been met or not is a key way to show this. Target values can also be shown using KPI visualisations or conditional formatting can be added to a column in a table. For charts a horizontal target line could be added instead.