Advanced Charting : Scatter Pie Chart in Tableau




The previous article in the series highlighted the steps to create a waterfall chart in Tableau. Today we will discuss about a interesting chart in Tableau : Combination of scatter plot and a pie chart , a scatter pie chart. Sounds interesting , Right ?
Lets go ahead and do this using our standard dataset – Sample Superstore Data.

We will try to plot the sales and profit on the scatter plot and then try to split each circle in a pie with three marks for Categories. To achieve this we will use LOD calculation in Tableau . To understand more about LOD refer to the article here .

Step 1: Create a calculated field to calculate the sales and Profit across states.
pie1

pie2

Step 2: Drag the measure Sales for State in the Columns Shelf and the measure Profit for States in rows shelf.
Step 3: Drag state into the detail Shelf and change the mark type to pie. Bring the measure Sales for State to size. Increase the size and your worksheet will now look like this:

pie3.PNG

Our job in now almost done. Add Category to the colors pill and the measure Sales  to the Angle pill. There we go , our Scatter pie chart is now ready 🙂

Scatter Pie

 

A more interactive version can be found in the workbook here :


Hope you guys enjoyed reading this article.Comments are appreciated.

References: Namrata Sawant
Jonathan Drummey