tag:blogger.com,1999:blog-3998628784041768080.post9022636198953632604..comments2024-03-28T03:27:07.147+00:00Comments on VizWiz: Makeover Monday: What characteristics are most important to British men and women?VizWizhttp://www.blogger.com/profile/11408220384219218043noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-3998628784041768080.post-80362083654027503302018-02-26T10:03:40.635+00:002018-02-26T10:03:40.635+00:00Download my workbook and unzip it. Then when you o...Download my workbook and unzip it. Then when you open it, you should be able to see how I build the join.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-64437407659752651122018-02-26T04:34:02.605+00:002018-02-26T04:34:02.605+00:00I created a calculated field called Row which has ...I created a calculated field called Row which has the value 1. When I try to do an inner join in Tableau between LooksVsPersonality and Waffle sheet of Waffle Chart Template, I do not see the Row field showing up. Can you please explain how to do the join?viz_ranbirhttps://www.blogger.com/profile/18372976554014646123noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-56967759085392322372018-02-24T11:40:29.783+00:002018-02-24T11:40:29.783+00:00Hi Tanner. You can download the workbook to see ho...Hi Tanner. You can download the workbook to see how I built it.VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-80967369017829296572018-01-10T10:53:29.016+00:002018-01-10T10:53:29.016+00:00Thank you, Andy!!! It works now! Thank you for rem...Thank you, Andy!!! It works now! Thank you for reminding for using Average!Yanhttps://www.blogger.com/profile/00352821935998765753noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-2953128826749861552018-01-10T09:39:14.486+00:002018-01-10T09:39:14.486+00:00Ah gotcha! My apologies for the misunderstanding. ...Ah gotcha! My apologies for the misunderstanding. What I do is create an inner join between the Looks vs Personality excel file and the Waffle Chart Template excel file. Since the Looks vs Personality excel file doesn't include a Number of Records field, I created a calculated field named "1" and all that is in the calculation is the number 1. I then join this 1 field to Number of VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-28987669445857055692018-01-10T08:30:31.410+00:002018-01-10T08:30:31.410+00:00Hi Andy,
Thank you for quick reply. The point is ...Hi Andy, <br />Thank you for quick reply. The point is that I couldn't get the data connection window. Whenever I click the data source button, it pops up a window to let me select the data file. Do you connect with excel or using data.world? I use the excel data, haven't connected to data.world for viewing your tableau work. Yanhttps://www.blogger.com/profile/00352821935998765753noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-27975147489618548262018-01-10T07:53:41.966+00:002018-01-10T07:53:41.966+00:00If you go into the data connection window you’ll s...If you go into the data connection window you’ll see how I joined them. I prefer this to blending. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-6568530754008595312018-01-09T21:47:01.144+00:002018-01-09T21:47:01.144+00:00Thanks a lot, Andy! I have also struggled a bit to...Thanks a lot, Andy! I have also struggled a bit to choosing the proper way of presenting the points. I have downloaded your workbook, but wonder how you join waffle sheet to original datasheet? I thought there is no need to do the data joining, but without join, I couldn't compare the sum(percentage_looks vs personality) with sum(percentage_waffle). <br />Thanks!Yanhttps://www.blogger.com/profile/00352821935998765753noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-32026119497784350202018-01-09T15:38:55.411+00:002018-01-09T15:38:55.411+00:00Cheers John!Cheers John!VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-67406251188728883962018-01-09T14:24:42.894+00:002018-01-09T14:24:42.894+00:00I'm new to the community, and just posted my 6...I'm new to the community, and just posted my 6th viz. Just contemplating 600 vizzes makes my head hurt! Your dedication to the community is amazing. Between the Makeovers, Tips, Workouts and webinars, I'm checking into your site pretty much every day. Thanks for putting so much great content out there for us!John Trefethenhttps://www.blogger.com/profile/08681639538347772226noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-57945772575494021772018-01-09T01:24:59.198+00:002018-01-09T01:24:59.198+00:00Download the workbook. Download the workbook. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-3585855917352863432018-01-09T00:45:26.437+00:002018-01-09T00:45:26.437+00:00Andy - I am just starting out with Tableau visuali...Andy - I am just starting out with Tableau visualizations and am curious how you created the above chart. Would you mind sharing? Love the representation!Anonymoushttps://www.blogger.com/profile/08692611463911756000noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-36887704348881993632018-01-09T00:44:27.315+00:002018-01-09T00:44:27.315+00:00Andy - I'm just starting out and am curious ho...Andy - I'm just starting out and am curious how you created the above visual? Would you mind sharing? Love the representation!Anonymoushttps://www.blogger.com/profile/08692611463911756000noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-49476868329434951882018-01-08T17:28:10.423+00:002018-01-08T17:28:10.423+00:00Um that’s not what it’s about. It’s about what the...Um that’s not what it’s about. It’s about what their rate as their most important. VizWizhttps://www.blogger.com/profile/11408220384219218043noreply@blogger.comtag:blogger.com,1999:blog-3998628784041768080.post-83529215059644306052018-01-08T16:14:48.288+00:002018-01-08T16:14:48.288+00:00Um... Men don't rate good look as the second m...Um... Men don't rate good look as the second most important characteristic. More men rate good look as a most important characteristic than women.<br /><br />The most popular second most important characteristic is still the sense of humor.Zahrahttps://www.blogger.com/profile/18080701170723374346noreply@blogger.com