1 of 1 people found this helpful
This is a great question!
Often working with a wide data source is more difficult than working with a long data source. In this case, using the long data source will make you adjust how you treat the dimension (sociodem) as it contains quite a few values which are not all mutually exclusive. The trick is to filter to just the applicable values:
For example, here I've filtered to keep only male or female.
Also, you may have to use the drop down on [Percent/Cl] to change the data type to decimal. There are some values which will become null (because they were strings that represented ranges). If those are still important, you may want to make a copy of the field to retain the string values too.
As far as resources to understand tall vs. wide -- I've picked up a lot from these forums and I included a large section on the differences (and how to work with both) in chapter 11 of Learning Tableau </ShamelessPlug>
Hope that helps!
Thanks. This helps somewhat. I modified the excel file to add more columns, defining the groups. So, all the data in one column. All the different categorizations in various columns. One column for year, another for what type of grouping (gender, race/ethnicity) another for what type of data (percent, confidence intervals), another for the sociodemographic group within the grouping (gender-male, gender-female, RE-Asian, RE-Black, etc).
I got the chart, by using filter. Instructions and chart are attached.
I still don't know how to do the tables, though.
Can I unpivot my data in tableau? I have a file that is 100,000 rows and 40 columns in Excel. I need to unpivot on the last 20 columns for a viz my boss wants me to do.. I have done this viz with a smaller dataset that I could easily unpivot. Can I load the file to Tableau and then unpivot it?