Creating a year-on-year comparator

To create a year-on-year comparator, you need to combine everything that we saw previously: Calculated FieldReference 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:

  1. Create a Parameter to choose the year. Configure it as an Integer with a List of allowable values. ...

Get Getting Started with Tableau 2018.x now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.