Give a chestnut! Tableau Tips (24): Do the shadow slope map

In the actual business scenario, we often encounter this situation: we want to compare the gap between the two. For example, I would like to see the profit gap between the two products in recent years.

How to achieve data comparison and can focus on it? You can try to make a shadow slope map~

The "Take a Chestnut", Ada's Tableau technique to share with you is: Do a shadow slope map.

Step 1：create a line graph

Drag and drop discrete dates to the column ribbon and filter, select the year to compare, drag and drop the profit to the row ribbon, and add the category to the tag card details.

Step 2：create a calculated field

I want to compare the gap between office supplies and furniture, so I created a field about office supplies and furniture profits.

 Step 3：create a new line graph

Drag and drop the new office supplies profit field to the line function area, and drag the furniture profit to the left axis.

Step 4： create a double axis

And change the metric tag card to the zone and pull the category away from the metric tag card.

Step 5： Losing furniture profits from the profit of office supplies

Since we use area charts, office supplies profits are stacked on top of furniture profits, even if they are synchronized, pushing the shadow area above the slope map. In order to solve this problem, we need to subtract furniture profits from the profit of office supplies.

Finally, the furniture profit was replaced by white, and then a proper adjustment was made to make a shadow slope map.

Today's Tableau tips, are you getting it? Open your Tableau and try it out!