For this topic, I will be using the Makeover Monday ’19 Week 1 NHL dataset.
I had produced a very simple dashboard that compares the Home Attendance and Road Attendance for every NHL team, filtering by each season. The chart shown in my dashboard is a butterfly chart, if you would like to know how to produce a butterfly chart then click here.
Image 1 – Dashboard on Makeover Monday ’19 W1 filtered on Season 2001-02.
With my viz, I wanted to show, by colour, which teams had exceeded (or not) Road Attendance over Home Attendance.
How do you do this?
Firstly, the chart will look like Image 2.
Image 2 – Butterfly chart comparing NHL Road Attendance and Home Attendance.
To make the Road Attendance side of the chart change colour, create a calculated field and type as follows in Image 3.
Image 3 – Colour condition calculated field entry.
This calculated field is simply assigning corresponding string values to when you meet either [fixed road attendance] > [fixed home attendance] or [fixed road attendance] < [fixed home attendance].
The calculated field will appear in the Dimensions section in the Data pane. Drag and drop the field into Colour in the SUM([Road Attendance]) Marks card.
Image 4 – Drag the colour condition calculated field into Colour in the Marks card.
Your Road Attendance side of the chart should now change colours according to the calculated field.
Image 5 – Final outcome.