Placeholder Image

字幕列表 影片播放

  • 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 expressingGDP figures

  • as a percentage of total.

  • Ok.

  • Which is the fastest way to do that?

  • I can either press theadd new worksheetbutton 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 pressDelete” … 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, weve decided well start from the previous visualization we created.

  • I’ll use theDuplicatebutton, and the identical sheet we saw earlier would be

  • created.

  • I need change the titles of the two sheets.

  • The first one will beGDP comparison 2016”, and the second oneGDP 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 theSUM(2016)” field and will pressRemove”.

  • All circles start having the same size because we removed the differentiating factorGDP

  • size.

  • The reason we seeSUMhere 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 andsumsall 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.

  • AwesomeLet’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 toQuick table calculation

  • and selectpercent of total”.

  • And of course, when we hover over the bubble of a given country, well 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

Hi and welcome back!

字幕與單字

單字即點即查 點擊單字可以查詢單字解釋

B1 中級

複製工作表。這是如何在Tableau中複製工作表的方法 (Duplicating sheets: This is how to duplicate a sheet in Tableau)

  • 8 1
    林宜悉 發佈於 2021 年 01 月 14 日
影片單字