Please upload a Tableau Packaged Workbook including some sample data to get started.
I have attached the simplified workbook - the original has over 20K rows and student data, so I deleted a lot of rows, and all of the student identifiers and the additional columns.
The Goal of what I'm trying to create was manually created in Excel based on last years data, and I would really like to avoid manually creating it this year.
You need to extract your datasource, otherwise I cannot open it.
Does the new attachment work now?
The new attachment works, thanks.
It's not clear to me what you're trying to achieve from an output point of view. It seems like you may want to 'stack' your gender, disability and visible minority dimensions into the same dimension / column.
Can you please provide me with an example of the output you'd like to see based on the sample data you've provided me? I.e. what do you want the Adult 12 and Adult 12 programs to look like?
What I'd like to see is the TOTAL Enrl and WD for each program, and then for each of the gender, disability and VM, I'd like to see the numbers in those subsets:
Program Total Enrl Total WD Adult 12 7 4 Female 7 4 Disabled 0 0 Visible Minority 0 0 Adult 10 30 13 Female 17 4 Disabled 6 2 Visible Minority 2 1
If that makes sense. The numbers in the subsets will not add up to the total because a student could be in multiple subcategories.
1 of 1 people found this helpful
You can achieve this using calculated fields, but only for one measure > you won't be able to get two columns like you've laid out in the example in your prior post. I'll explain why.
Create a calculated field to represent each 'bucket' i.e. Female, Disabled etc.
I.e. CalcFemale = SUM(IF Gender='Female' then [Total Enrl] end)
CalcDisabled = SUM(IF [Disability] = 'YES' then [Total Enrl] end)
Then move Measure Names to the row shelf, and add the new calculated fields to the measure values pane;
I've only setup two calcs in my example, you can built out the missing calculations. You could also build out another set of calculations to calculated the 'Total WD' as well, but they you will end up with 8 rows per Program.
If your heart is set on having two columns like you've requested, you're going to need to undergo a pretty serious re-shaping of your dataset to support the structure you're actually after. Effectively you need to stack your different 'groups' in the same column. I.e.;
Program MetricGroup TotalEnrl TotalWD Adult12 Female 7 4 Adult12 Disabled 0 0 Adult12 Visible 0 1
This is possible without manipulating your file using Custom SQL, but honestly it's not a path I would recommend if you don't know anything about SQL and you're responsible for updating and maintaining this in the future.
Thank you! I will give this a try and see how it works. I am fluent in SQL, and use it to obtain the data set (it's taken out of our LARGE Oracle Student database) - I would be able to change how the data is extracted if needed, but not entirely sure it's worth it in the end - what we are trying to obtain is 10+ columns (I only put two in the example), broken down by WD reasons.
Your solution points me in the direction I need to head.