字幕列表 影片播放 列印英文字幕 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
B1 中級 複製工作表。這是如何在Tableau中複製工作表的方法 (Duplicating sheets: This is how to duplicate a sheet in Tableau) 8 1 林宜悉 發佈於 2021 年 01 月 14 日 更多分享 分享 收藏 回報 影片單字