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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.