To create a year-on-year comparator, you need to combine everything that we saw previously: Calculated Field, Reference Line, and Parameter.
Your mission (if you accept it) is to build a visualization where you can see the Sales by Sub-Categories of a selected year compared to the previous year with a Reference Line. Color also helps you to quickly spot the sub-categories where the sales are lower than the past year. Here's the final result:
Quite impressive, isn't it? Let's build it! Follow the tutorial:
- Create a Parameter to choose the year. Configure it as an Integer with a List of allowable values. ...