How To Duplicate Sheets in Tableau?

Tableau Tutorials 3 min read
duplicate a sheet
Blog / Tableau Tutorials / How To Duplicate Sheets in Tableau?

duplicate a sheet

Duplicate Sheets in Tableau

In our last tutorial, we created the visualization showing us the 2016 GDP of each country. You can easily see it in the workspace area. What we’ll do here is add a similar visualization, but for ‘2015’ and expressing ‘GDP figures’ as a percentage of a total.

Which is the Fastest Way to Do That?

You can either press the “add new worksheet” button or go to “Worksheet”, select “New worksheet” and create a new blank sheet.

new worksheet in Tableau, duplicate sheets in tableau

But sometimes that may not be the best possible solution, as we will lose many of the edits we have already made, right? So, we’ll delete the empty sheet we created. Now all you need to do is right-click and press “Delete” … And the redundant sheet’s gone.

Option "delete", duplicate sheets in tableau

By the way, it is really easy to change a sheet’s name. Just double click on it and then type the sheet’s new name – “GDP comparison”.

That’s it!

Rename sheet

How to Duplicate Sheets in Tableau?

Let’s start with the previous visualization we created. You can use the “Duplicate” button to create an identical sheet to the one we saw earlier.

Duplicate a sheet, duplicate sheets in tableau

Next, you need to change the titles of the two sheets. The first one will be “GDP comparison 2016”, and the second one “GDP Comparison 2015”. You already know how to do that. While adjusting names, you can change the title of the first visualization accordingly – “GDP Comparison 2016”. And you can do the same for the visualization on the next sheet – “GDP Comparison 2015”.

Changing name field

GDP comparison 2015

Let’s delete the 2016 data. To do that, click on the “SUM(2016)” field and press “Remove”. Now all circles have 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 the United States and “sum” 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.

Remove field, duplicate sheets in tableau

Let’s add 2015. That’s easy to do, isn’t it? You just have to drag the “2015” field in the workspace area.

drag and drop, duplicate sheets in tableau

Now, as we said, we would like to display each country’s GDP as a percentage of the total GDP observed in 2015. So, click on the tiny arrow next to the 2015 field, go to “Quick table calculation” and select “percent of total”.

percent of total, duplicate sheets in tableau

And of course, if 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%.

GDP per country, duplicate sheets in tableau

What an informative visualization! Plus, it looks so professional!

In our next tutorials, we will learn how to create a table with some custom fields and how to add a calculation to a table. It sounds fantastic, doesn’t it?

Warm up your fingers and mousepads and continue enjoying our Tableau tutorials!

Next Tutorial: How to Create a Table in Tableau

 

 

Earn your Data Science Degree

Expert instructions, unmatched support and a verified certificate upon completion!

Leave a Reply

Your email address will not be published.