Hi and welcome back!
In our last video, we created the visualization you see in the workspace area.
What we will do here is add a similar visualization, but for ‘2015’ and expressing ‘GDP figures’
as a percentage of total.
Ok.
Which is the fastest way to do that?
I can either press the ‘add new worksheet’ button from here or from here and create a
new blank sheet.
But sometimes that may not be the best possible solution, as we will lose a lot of the edits
we have already made, right?
I’ll delete the empty sheet we created.
All I need to do is a right click and press “Delete” … And the redundant sheet’s
gone.
By the way it is extremely easy to change a sheet’s name.
I’ll double click on it and then type the sheet’s new name - “GDP comparison”.
So, we’ve decided we’ll start from the previous visualization we created.
I’ll use the “Duplicate” button, and the identical sheet we saw earlier would be
created.
I need change the titles of the two sheets.
The first one will be “GDP comparison 2016”, and the second one “GDP Comparison 2015”.
We already know how to do that.
Ok.
Perfect.
While we are adjusting names, I’ll change the title of the first visualization accordingly
– “GDP Comparison 2016”.
And I’ll do the same for the visualization on the next sheet – “GDP Comparison 2015”.
Excellent!
Let’s delete the 2016 data.
To do that I’ll click on the “SUM(2016)” field and will press “Remove”.
All circles start having the same size because we removed the differentiating factor – GDP
size.
The reason we see “SUM” here is that Tableau needs to run some sort of math operation with
the 2016 column of data it found in Excel.
It says it sums the data, but what it really does is find the one field, which corresponds
to United States and “sums” all values related to it (there is just one value corresponding
to both United States and 2016).
So, for those of you who are familiar with Excel, Tableau performs an operation like
SUMIF in this case.
Awesome  Let’s add 2015.
That’s easy to do, right?
I have to drag the “2015” field in the work space area.
And now we said that we would like to display each country’s GDP as a percentage of the
total GDP observed in 2015.
I’ll click on the tiny arrow next to the 2015 field, go to “Quick table calculation”
and select “percent of total”.
And of course, when we hover over the bubble of a given country, we’ll be able to see
the percentage of the total world economy it accounts for.
The United States represented almost 3% of the entire global economy.
China produced 1.8% of the global output, and Germany accounted for 0.55%.
What an informative visualization!
Thanks for watching 