Duplicating sheets: This is how to duplicate a sheet in Tableau

By | August 10, 2019


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 

Leave a Reply

Your email address will not be published. Required fields are marked *