
hi all,
I have this workbook where I want to analyze a thanksgiving dataset. Here is the dataset thanksgiving.csv - Google Drive and here is the packaged Tableau workbook.
My problem is that I want to create a calculation that will for example, go into the dessert group, grab all the different types of desserts so that I can have them say as a dimension. Not sure if this is the right approach though to solving the problem. I will like to have a dimension with all the answers and a pane with all the questions. And then have the demographics as a set. For example. for all those who eat brownies, I wana drag and drop gender and it separate the number of male and female who had brownies.
My end goal is to generate visualizations like this http://suruchifialoke.com/2016-09-02-thanksgiving-pandas/ that will show what kind the respondents have for thanksgiving.
Thanks.
Yay - I can open it!
Yes, I think you've got the right idea with your bar charts. It might be fun to overlay shapes and use food pictures, similar to these visualizations:
Food Combo Reaction Matrix | Tableau Public
The way to get percent of total for your pie (or any chart) is to right-click on the measure and select "Quick Table Calculation" then "Percent of Total". Sometimes you have to be careful about this to make sure your percent is calculating the correct way, so I usually right-click the new calculation and select
"Compute Using" so I know it's giving me what I want (see below).
Regarding size, I just changed the drop-down at the top from "Standard" to "Entire View" and then decreased the size a little on the slider...
Package workbook attached.