6 Replies Latest reply on Oct 1, 2018 3:47 AM by meenu choudhary

# Tableau Public dynamic project

Hey guys, I'm starting a University project that requires us to make a dynamic and interactive visualisation. I decided Tableau as the tool, but am still working out how to use it effectively.

What I wanted to do was have 2 variables (investment from foreign countries into Australia and the number of immigrants from those countries to Australia) and see if there is a correlation between the two. I have the data for both variables for the last 15 years, so I wanted to make a bubble for every country and have the investment values on one axis and the immigration values on the other, so each countries bubble could be positioned accordingly. I also want the bubbles to be sized according to their population. I know there is a function in Tableau public to make the points move over time using the pages box, so I wanted to use that to show how the data changes over time. Here is a photo of small part of the table I made in Excel for the project, with the investment data further across in the table.

I was just wondering whether this kind of thing would be possible and if anyone had any tips on how to go about it. Thanks in advance!

• ###### 1. Re: Tableau Public dynamic project

Yes this can be done in tableau. Could you please share the mock up data.

For now below is the sample from superstore.

For your scenario, Investment value will go on Columns shelf and immigration on row shelf.

1 of 1 people found this helpful
• ###### 2. Re: Tableau Public dynamic project

Thanks so much for your fast reply, here is the data that I collected in Excel (hopefully you can see it all). Is that what you mean?

• ###### 3. Re: Tableau Public dynamic project

You can't see all the data, but if you highlight all the way across it can copy it.

Let me know if that doesn't work.

• ###### 4. Re: Tableau Public dynamic project

I copied the data and created some logic:

1. Create "Pivot" by taking selecting all the columns except "Year"

- This will help in calculating "Country Name" and the calculation for Investment and immigration will be easier.

2. Create a field that will identify whether a row holds investment or immigration data.

Invest Or People =  if CONTAINS([Pivot Field Names],'invest') then "Invest" else "People" END

3. Country Name = REPLACE(REPLACE([Pivot Field Names],"invest",""),'people','')

4. Investment value= zn(lookup(sum (if [Invest Or People]="Invest" then ([Pivot Field Values]) END),0))

This will have sum of all the investments. "ZN" is used to replace NULL with 0.

5. immigration ZN(sum(if [Invest Or People]="People" then [Pivot Field Values] END))

6. Arrange the values as shown below:

1 of 1 people found this helpful
• ###### 5. Re: Tableau Public dynamic project

That worked perfectly, thank you so much!