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

    Tableau Public dynamic project

    Thad Rainbird

      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.

      Screen Shot 2018-10-01 at 4.08.06 pm.png

       

      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
          meenu choudhary

          Hi Thad,

           

          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
            Thad Rainbird

            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?

             

                    

            YearUnited Kingdom peopleNew Zealand peopleChina peopleIndia peoplePhilippines peopleVietnam peopleItaly peopleSouth Africa peopleMalaysia peopleGermany peopleSri Lanka peopleGreece peopleKorea, Republic of (South) peopleUnited States of America peopleHong Kong (SAR of China) peopleLebanon peopleIreland peopleIndonesia peopleNetherlands peopleSingapore peopleThailand peopleFiji peopleIraq peoplePakistan peopleCroatia peopleJapan peopleTaiwan peopleIran peoplePoland peopleCanada peopleNepal peopleFormer Yugoslav Republic of Macedonia (FYROM) peopleAfghanistan peopleEgypt peopleMalta peopleBangladesh peopleTurkey peopleFrance peopleZimbabwe peopleBosnia and Herzegovina peopleCambodia peopleSerbia peoplePapua New Guinea peopleMyanmar peopleChile peopleSamoa peopleMauritius peopleBrazil peopleRussian Federation peopleSudan peopleHungary peopleCyprus peoplePortugal peopleKenya peopleSpain peopleColombia peopleAustria people Romania peopleUkraine peopleArgentina peopleSyria peopleSwitzerland peopleCzech Republic peopleEthiopia peopleSaudi Arabia peopleSweden peopleTonga peopleIsrael peopleLaos peopleEl Salvador peopleDenmark peoplePeru peopleTimor-Leste peopleUruguay peopleFinland peopleNigeria peopleSomalia peopleUnited Arab Emirates peopleCook Islands peopleBelgium peopleSlovenia peopleZambia  peopleJordan peopleSlovakia peopleKuwait peopleBhutan peopleGhana  peopleVenezuela  peopleMexico peopleCongo, Democratic Republic of peopleLatvia  peopleEritrea peopleSouth Sudan peopleNorway peopleTanzania peopleBulgaria peopleEstonia peopleSierra Leone peopleUganda peopleAlbania peopleLiberia peopleLithuania peopleBrunei Darussalam peopleSeychelles peopleMacau (SAR of China) peopleGaza Strip and West Bank peopleEcuador peopleLibya peopleSolomon Islands peopleBurundi peopleMorocco peopleMongolia peopleBelarus peopleKazakhstan peopleTrinidad and Tobago peopleMontenegro peopleOman peopleUzbekistan peopleBahrain peopleNew Caledonia peopleAlgeria peopleVanuatu peopleJersey peopleKosovo peopleArmenia peopleNamibia peopleCongo, Republic of peopleMalawi peopleBotswana peopleMoldova peopleJamaica peopleQatar peopleRwanda peopleBolivia, Plurinational State of peopleMozambique peopleGuinea peopleNiue peopleCuba peopleGuernsey peopleNicaragua peopleNauru peopleIceland peopleTokelau peopleYemen peopleGeorgia peopleTunisia peopleKiribati peopleMaldives peopleAzerbaijan peopleCote d'Ivoire peopleBermuda peopleGuyana peopleAngola peopleFrench Polynesia peopleGuatemala peopleCosta Rica peopleKyrgyzstan peopleParaguay peopleGibraltar peopleCameroon peopleSamoa, American peopleBarbados peopleUnited Kingdom investNew Zealand  investChina investIndia investPhilippines investVietnam investItaly investSouth Africa investMalaysia investGermany investSri Lanka investGreece  invest Korea, Republic of (South) investUnited States of America investHong Kong (SAR of China) investLebanon investIreland investIndonesia investNetherlands investSingapore investThailand investFiji investIraq investPakistan investCroatia investJapan investTaiwan investIran investPoland investCanada investNepal investFormer Yugoslav Republic of Macedonia (FYROM) investAfghanistan investEgypt investMalta investBangladesh investTurkey investFrance investZimbabwe investBosnia and Herzegovina investCambodia investSerbia investPapua New Guinea investMyanmar investChile investSamoa investMauritius investBrazil investRussian Federation investSudan investHungary investCyprus investPortugal investKenya investSpain investColombia investAustria investRomania investUkraine investArgentina investSyria investSwitzerland investCzech Republic investEthiopia investSaudi Arabia investSweden investTonga investIsrael investLaos investEl Salvador investDenmark investPeru investTimor-Leste investUruguay investFinland investNigeria investSomalia investUnited Arab Emirates investCook Islands investBelgium investSlovenia investZambia investJordan investSlovakia investKuwait investBhutan investGhana investVenezuela  investMexicoCongo, Democratic Republic of investLatvia investEritrea investSouth Sudan investNorway investTanzania investBulgaria investEstonia investSierra Leone investUganda investAlbania investLiberia investLithuania investBrunei Darussalam investSeychelles investMacau (SAR of China) investGaza Strip and West Bank investEcuador investLibya investSolomon Islands investBurundi investMorocco investMongolia investBelarus investKazakhstan investTrinidad and Tobago investMontenegro investOman investUzbekistan investBahrain investNew Caledonia investAlgeria investVanuatu investJersey investKosovo investArmenia investNamibia investCongo, Republic of investMalawi investBotswana investMoldova investJamaica investQatar investRwanda investBolivia, Plurinational State of investMozambique investGuinea investNiue investCuba investGuernsey investNicaragua investNauru investIceland investTokelau investYemen investGeorgia investTunisia investKiribatiMaldives investAzerbaijan investCote d'Ivoire investBermuda investGuyana investAngola investFrench Polynesia investGuatemala investCosta Rica investKyrgyzstan investParaguay investGibraltar investCameroon investSamoa, American investBarbados invest
            200111222003896001533609807011426016349022985086820864001183406064012870038980607807392079850536505309091900356702443049070284801229058690256902414022250655303102024404974013860374205181097903423018400132102878025100520502564012190259201396018580512016710509025640227201778076401411045102133014380166601203076101225013070382016207300835075101035010570100305940104201049093601950377015404960538084403510362064302630702250126013202806990179004230195031101860370139016201203630215027201960312014601460144030136013013604801440533041053076011601240104010000980470170540750620930270507006403047051058078048059029040036049043017020070420530410360310350110360470701403502316991761431321002370037712122221123875218474229164319745108741215885398515617201049794117603346700000077449400025200103500100093026700001252400188240110000000002330691700009830001200000000000000086000130000000000270150000000000000000000000000000143900000000000
            2002111455040238016999010827011836016612022771095140891901194706350012887041510628907549080970538905741091840369402639050720300101329061930273802559023100648603226027105021014600374505171011110350301900015130315902566050020259101249026110149101895055801722062202531022680178708290141704780212201467016580121107790124101326042901890756086007750103901063010130605010490105209370213041601780515054808590380037306300271090234013101380290683019800426019903240183079014401690280355022402780200031901490148015003014001501430500146051205005708301240127011001000098054018061078065095033060720680405005305907805206203504203805104502102307044053043038033035014038050090170360253439184872843105196402186144646151427555146372386873556815135337719037251394509700049494938006663000100081982000140000242170900000944000000027756021000000376000065010000142700010000014950000000000000012000000000370240000000002000000000000000000169400000000000
            20031111980409500187450119430123300169720225360101440930701206806604012904044380653507731082760543905962091760385602825052360338601419064750291902621024310642803366030205070015770377605161012520360301971017220340002643047320263001270026370154101938061601760094102495022620179809140142205130211501504016530123008010126801347049402210784087208100104201067010250630010570106009420228043202140525056208680399038806200291011024801390152029066502100043202000330017709701550207047034702360281020603210154015101540501460180149055014904840610610910126013101140105001040630210640840690960360807407208053056061077054064038047038054046022025080450540440400340360160400500110180370259735198592989128174703050193161641574062136182875412783351813593622216522233161420004641711720010980000100011145000028200002600000000147100002126930321968026000000114000010562000012070309000020960000000000000011000000020030270000000003000000000000000000252700000000000
            20041113300413980205200132790128610171980222950108410976001217906778012902047210675107832083680550206026091610401502970053460355001529067160310502603025370637403485033705104017010381305148014090368002038019620362202694043450265701282026590159601982067101773013460246302256018030987014260542021080153501662012660813012820135905620254082008710844010470107101034064301062010670943024104420242053605700874042404000615030401202640146016303206470222004360206033601720100016702180530338024702860207032301580155015801001510210152061015304450700680980126013301160107001090660380700900770970410130760750905605906207805606704205203905404802402908046056044040035037021040049012019038027638721671228527712691009962419530217248920137836227929282012435132775620256766470004914418550012448000301016035100212840000912014067327801439030018748201518490250073300026400001667501008760001000002085000000000085000350000000000230290000000003000000000000000000489400500000000
            2005111689042355022760014896013458017444022055011415010139012301070620129010511507052079850849005570060250916204307031550547703710016810695003311025860267206328036250383051320186203874051380161303746021120216803840027610392902689013330268701662020310753018110185902434022450181601085014320581021040156801680013090826013060137006110296085508720895010600107501048066801071010790949025804500280054605790876045404160606031201302820158018203606310228004380230034401660157018802270136033002570289021003260165015701640430156024016006701560402084076010801260133011801120011107407107609708101000440180770770220580610650770570670420520400540490280300200460560450390350380240410490130210380299740272482274322343334521135655142106192690033398731571924435682870419665207300005102324710013372000400016331803132700001471200010738050002001994520771904027007720003700000230901000822000120000231100000000001700060000000020050420000000003000000000000000000536200000000000
            20061130980437890251960169720141890178010218040119490105710124710738201289805595074670813608594056800605309185045810340605635039500183207181035390258602811062900382204350516502198039370511601851038060220202370040580283503592027330143202719017170209308500185402087024040223501828011640144306230209501611017010134808440134801392063903550896087209440106701078010610715010830109409600288046203320561059208860490043105970332014031501800214063061202400044302760345016001950205024101590321026302940209032601740162017008301620300172077015801850104093011601240133012101090011308106608201040870104050024078079029059064063079058067043052040055048032030023047057047039035039024042047014020039035963235711350860928850429112255232467002449593830533887302105514310452743629463002516793439001248900030210231973040504000263000100960001300287483051225100007930003670000242002000880001320000262600000013403700000650000000205260810000000003000000000000000000650600000000000
            2007114806045802027832020444015119018272021497012757011147012578078940127510647007893082310876205844061940912704783038310579904207021060711103783026690302106187039860798051620245004011050630214603834023570262704049029100357002800016220275001780021900109301889023230237302205018310126901455075702080016300168001351086501358013960699047309230890098901079010780106507760107101088095603260501037505820613087505280452060003470200344020002450117060002540043303160353016402450237025002130315027602970221032101760166017501280167032017508501630190010601010120012701340122011200114086078085010308901040520340800790410620670660810610690440530440560490320330290470580490420380400270410470170210400411702428616187010270717139067673441491317796433181459339154442434365391683388900363380415020107760003021125267000049000723000110133662400100030395500333900001224000373009074011686100073400311000030540000001460160190006900001003091706034000000004000000800000000000963400600000000
            2008116588048366031303025120016304018948021127013826011844012645085600125770737708073083310887606218065070905604951043200601004458023950702403902028280317906074041820149605165026430409305004024110386702516029600402402975035550288901867027770185702414013790194502413023440218101839013570145609320206701639016640135708840137401384074507970952093001030010890108201065085301064010830956036105270428060906300867057104820600036502603690240028201650578026800435034603550170027002530261023603110295029902350318018101770182015201700410176095016701890114011001230132013601230115001170950820910110092010605704008308204906807106908106206904905504605705303703403504805905104404004203104104802002204204419802847284170464155746144710058388570071784225585417214142463630285214324988298001888754240001507000000017294770080639103325189749807405436587201025103724790034260000109700033000011937100059000020000024290000001620210126000650000200301054106630000000000000000000000000000904100600000000
            200911800605044403449803075901750201978202081301506901247901264109206012417081350822008443089270679906857089570516004847062190490002725069370398503016034020598404320024820515702850041420493202680039320269203245039930306003538029530211702810019640266901569020120248902318021580184601454014680112202044016530164401357091301391013660821011230974097101049011010108701059092001063010710953041305650481064106380853059705060600039709603920277030301930568028600431036903600200029302680276026303070302029902480311018601980190017201750610181010801670190011801230132013801370123012103501180105092098011209601070610480840870530720720730810640710540590470570560390390400500600520440410420330420480220240420496994314751648805846370416248800394710092064747614269202445334411234129112682390011025833575001933830000025231000000166800690168664101248494023762100032328400298500000000470000138791001133800114000000000000001700000610000100400610335130000000000000000000000000001177900600000000
            201011850705177803715503295101837702037702046901559501298801262609648012252084150853308546089640709707117088500535505157063960518303060068490402503136036480589404453027200514703084041830486602955039810281203371039730317203517030050232602828020440269801655020780254402285021350184701537014890124102016016650163601373093301403013620897012600100501006010700111101096010610961010580106309520464061905240663065108380617052505990432016904210335034002470559030900435038203600224033202860288029303090304029702560307019402370193018601800700184011901690188012501300133014601380130012401120120010901030102011201000109066062086086066077075072082063070057059049057061043042048052060053047041044036045048027026043047457333440194280100201870190983994132903029200506476420410230940938951420585540276001111873546220019850000503282419500001799000015870000145044228100041327002773316701380037010002660000155560001200500137000020100000000020000007800000000013800456480000000054000000000000000000887900900000000
            20111193050543950387420337120193030207620201680161590134140125750997401211808593090090859909003078620730608766055820529906547054980341506758041390334503964057900462302781051140329704208047960316203998029770346103944032510348503065024430285202182026780170602150022000224202115018550158701532013030198001672016280138009670142601345096301264010330105601084011300109901064098401054010540952051306590557069306690826063505440602047202680444038703770285054703260390044003940362024303450304029503010313030202980261030202000290020201940187078018701310173018501250138014401450140013001290139012201160112010801120104011506907209008907208107607608206207106006105005806004404605005206105304804304504004504803202904304642902799219675122624321841848205114486216389327712782527634443774082185444409614958213393296064125713484800256570001301322025330001573000986314220153662211004360100041651800334401470090200017900001416000003041000650000411400000000180000012500000000016780390000000001000000000000000000064660070000000681
            20121209210577090401560354120206250211670199890168010139470125810103910121160897109562086380908109078074940870205855055200670905691039290667704322038250433105726047980298105094034510425904730033860401903228035930393003345034640313202620028830237702688018220222902233022190210001877016400161701434019520169201624013980100701444013440104701228010840110501103011420110301077010060105701048095705640705060307310704081606540568061105230336047904300419033305370354039204430407036602780359031503050314031503000298025502980207029102080202019108401900147017701840127014601490147014201340137014101260122012901170116010901150760790940930790850800810830620700660620550590600470480540550610540490450470410470490350330440396409284482312511010913261185127251709121118015013773634050531790155354943935565318749542201701584665062003082500017002518581000079005700495801604070348331000682903305138457306700130100139900332160192608100028850023300007875010000002100000164000025000097007171200000000000000000090000000087020080000000897
            2013121892060081042260037574021887021894019972017287014422012538010846012119094040987708810091660956407601086250606505873068620603804544066070449604600048190567304912032840507103693043670466003631040160346403706039020342303449031870282502897026370270201957023200227802203020880191601708017120158301926017070162801437010480145401356011010119901127011430112101146011050108101031010530103909550634075106460772073308070675060206270553039405140468044403620524036904010445041603760330037003280321032403210300029602530293022302780217020802020930195015801820185013501530155014701480137014401430129013001310122012201130115083085099095083091086086084063070070063061061060052053055055059055052046045043048050038040044044874033120501521090082944025505076193822899001891849072158863567017967112445839735126296520019341641436632002924700028449033174901047014900048040460190442403509010005512938054385987020220138600028200366670206919100047410251470000638400000000000000282000036000024382082915000000000000000000832000000001288400000000001037
            2014121481060577045182040792023048022709019881017598014775012417011179012035096080100400899109245092890767608489062300637507000065060523206515046420497005105056040500504016050530411404428045830387804010036280379103876035250343103228029750290602807027240230502382023130216502072019350178201758017080189001715016340147501143014520135801177012550115901193011370115401106010670104601055010330955072408110685079407480797068406240638057605150544049804730417051003960414044304210387036203810342034503380323029702940250028902600252022102180210011902030168018801840144016001610144015201360146014401340131013201270124011601160920920990960880920860890850610720690640650630620540570590570590550510490470440480490410440440476941366506643611002596583269155822098840523209263217377857547412501627113265822387449656858105133181236654000359690004237010472144614059102200565030307028003296244915101220505344201179663702340017190003410018683022577100005395044000000131870100000068000001490000250000213740852188000000000000000000600000000309590022800000001090
            201512069906058204870704428702403802328601968201787201545801236401151201185809962010221092240931708910079110837406503068520710606884059090642404858051930535505545050800460805020043800446104496041440400703838038640384303615034030326703134029510291702752024830243602341021250205301939018730180701829018590171701639015160139401472013660125401272011890123101152011590110601069010540105101026096308180855075108050767078406860649064605940573057505480508045904940436044404310427039203750384035903600343032603030292025702830267024802300231022101670206018201870184016401690168015201530136015001450136013201340126012401200118010009709809809309208808908406507207006606606506306006206105705805505105104804604804804504604405207294493684097135671315730141569472134243268155286249768531991021960261421233765719123231965020334521573912378004158400052157041280021808860973000718022505186903494293629149116058510440395983490302002359000398001092502700796000839902113410000157810000000093088730002550000200002435801264147000000000000000000130000000026985006800000000
            2016119515060723052604046883024643023675019490018145016615012432011773011664010667010431096920932508645083780825707286072250718007124063490633506005058080556505501051330504404988045610448904413043320403904027039120381603692033690335103254030550294902759026750248802361020980203001946019390191401877018360172301626015970156001528013710130801258012520124401196011660110501090010570105401032097008980896084808040796077306910684065206050604059805770563050904800468046104520430040203980385037203650348032903230291027702760261024902430239022802140208019401850184018301760174016801560153015101460139013701350130012701210119011401010100099095091089088085074072071069067067065064063061058058055052052050049049048047046045060727254678433140256041022577255025001401681628164307297971626134722748145374521628969781095265706667096724757634160127134156283864270232987153001739761927630131163015412946310223159161851283802609363111432229127364091057489053791419601873953327012262015987001392300108798010611021410236530096206880000675430200004420311092060001455000092001802291555085291870000000085000000800860000000001502780034300000003705
            • 3. Re: Tableau Public dynamic project
              Thad Rainbird

              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
                meenu choudhary

                Hi Thad,

                 

                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
                  Thad Rainbird

                  That worked perfectly, thank you so much!

                  • 6. Re: Tableau Public dynamic project
                    meenu choudhary

                    Hi Thad,

                     

                    If your problem is solved please mark my answer as correct ,so as to close the thread.

                     

                    Thank You