
1. Re: Problems calculating 'within group' rates for a dimention with two groups.
Ivan Young May 6, 2016 3:33 PM (in response to Dawit Gelan)2 of 2 people found this helpfulHi Dawit,
Fortunately it's very easy to get rid of the No lines. Right click on the N in the legend select Hide from the menu and they are gone.
However to me your numbers look incorrect although I might be misunderstanding your requirement. For example you have 4 females in the 2009 cohort two of which graduated so I would expect a 50% rate and your graph shows 20% graduation for females. Tableau is coming up with the number by taking your 2 female grads and dividing by the 10 total students in the 2009 cohort. Changing the percentages is also pretty easy if you want to do that.
Good luck,
Ivan

2. Re: Problems calculating 'within group' rates for a dimention with two groups.
Ashish Chaudhari May 6, 2016 3:54 PM (in response to Dawit Gelan)Hi Dawit,
Please find my solution as well.
Crosstab result
Result
Please find the calculations in the workbook. Thanks for posting this one.
Thanks and Regards,
Ashish Chaudhari

ratetablecalc.twbx 32.4 KB


3. Re: Problems calculating 'within group' rates for a dimention with two groups.
Dawit Gelan May 6, 2016 10:29 PM (in response to Ivan Young)Thanks Ivan. The Hide menu is pretty helpful. I agree with the number problems as well. I made a mistake when I was building the workbook with a dummy data.

4. Re: Problems calculating 'within group' rates for a dimention with two groups.
Dawit Gelan May 6, 2016 10:30 PM (in response to Ashish Chaudhari)Thanks Ashish! I like how you calculated the rates. Very useful.

5. Re: Problems calculating 'within group' rates for a dimention with two groups.
Ashish Chaudhari May 6, 2016 10:36 PM (in response to Dawit Gelan)Hi Dawit,
Thanks for appreciating. I hope that have really helped.
I took 20mins more than Ivan. Truly credit goes to Ivan, the speed at which he replied to your query.
Thanks for giving me an opportunity to learn something different.
Regards,
Ashish Chaudhari