Creating a year-on-year comparator
To create a year-on-year comparator, you need to combine everything that we have seen previously: Calculated Field, Reference Line, and Parameter.
Your mission (if you accept it) is to build a visualization where you can see the profit by region of a selected year compared to the previous year with a Reference Line. The Color also helps you to quickly spot the regions where the profit is lower than in the previous year. Here's the final result:
Quite impressive, isn't it? Let's build it! Follow this tutorial to learn how to do this:
- Create a new Parameter and name it
Select a year. Configure it as an Integer with a list of allowable values. The list is composed of four values: 2015, 2016, 2017, and 2018. - If you want to make it perfect, you can change the display of the values to remove the thousand.
- Choose 2018 as the Current value.
Your Parameter configuration window should look like this:
- Display your Parameter (right-click on it and select Show...
