2 Replies Latest reply on Oct 18, 2015 12:22 PM by Andrew Goldsmith

# recreating figure 4-18 in Tableau Your Data - displaying running % of total

sorry to ask such basic questions but i want to exactly replicate figure 4-18 but somehow the instructions in the book must leave out a couple key steps for a beginner like me.

in the attached picture, I want to change the graph on the right as follows:

1) instead of each point displaying the state's 2014 population, i want each point to show the state/s percent of running total, so california would = ~13%,

2) i want the dual axis graph to be a bar chart and line but when I select dual axis, I get a mess.

I have attached a screenshot of the current worksheet

• ###### 1. Re: recreating figure 4-18 in Tableau Your Data - displaying running % of total

Hi Andrew,

Step 1: Place the state Dimension in the Rows

Step2:  Place the measure 2014 in Columns

Step3:  Sort the state Descending order( you should have the below output)

Step4:  Place the measure 2014 in Columns next to the existing Sum(2014) measure

Step5:  Right click on the second Sum(2014) measure in the column and “select add table calculation”

Step 6: Do the below table calculation

Step 7: Right click on the Second Sum(2014) measure and choose “Dual Axis”      (Now your pane will convert to circles visualization)

Step 8: Right click on the first Measure Sum(2014) and select Marktype= Bar

Step 9: Right click on the second Measure Sum(2014) and select Marktype= Line

Step 10: click on the menu bar label “Abc” icon to show the labels for each bar and line graph data points

Step 11: click on the swap button if you want to change the vertical graph to horizontal

Also please find the attached Tableau workbook I have used.

-Indumon

• ###### 2. Re: recreating figure 4-18 in Tableau Your Data - displaying running % of total

Hi Indumon --

There is still one thing that I don't know how to do.

For the data displayed where mark type = line, currently at each point

on the line, the 2014 population for each state is visibly displayed.

See the attached screenshot.

I do not want this.

That information is already shown on the bar chart marks so I do not

need to show the same information twice.

Instead, on the line, I want to visibly display for each point on the

line a percentage.

This percentage should correspond to the "% of Total Running Sum of 2014

along State" as displayed in the little tooltip box in the attached image.

However, I don't want to force the user to hover over the data point to

see the percentage.  I want the percentage to show up next to each point

on the line graph.

Thanks so much for your help!!! I really appreciate it.