Lift a chestnut! Tableau Trise (111): Comparison Data with a Simple Base

published: 2021-06-07

Many times, we need to understand the work schedule through the actual value and target value, the most commonly used rendering method has a dual column map and the target (target heart map).

In fact, there is a simple way to achieve data contrast analysis, which is a bead map (as shown below).

 

As can be seen from the legend, the bead map is a combination chart of a bar and a scatter, indicating the size of the actual value with a dot on a different position on the bar chart.

So how do I achieve a bead map in Tableau?

The Tableau tricks "to share the chestnuts" in this issue, and the Tableau trick to share with you is: compare data with a concise bead map.

For your convenience, we use Tableau to own supermarket data sources.

Specific steps are as follows:

1. First, we will adjust the supermarket data source to become a data source with a corresponding structure.

2. Example intended to complete the actual value of the target value, we drag the actual value and target value to column.

 

3, then, in the tag card, change the actual value to shape, and then select a graphic you like as a shape.

 

Then, adjust the size of the shape, the example selects the large circle and orange.

Select a double axis.

 

4, this step, adjusting sales in the tag card, from automatically to bar charts, and lower the color transparency of the bar chart.

 

Finally, click the synchronization axis.

 

In this way, a single bead map is completed.

 

5, finally, we will drag the province to the row, the entire bead map is completed, prettycool!

 

This issue of Tableau skills, have you get? Try it quickly!