To create a year-on-year comparator, you need to combine everything that we have seen previously: Calculated Field, Reference Line, and Parameter.
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...