Quick and Easy Retention Rates?

tableaucommunity@tableau.com — Thu, 22 May 2014 17:40:08 GMT

Hi All,

This is actually a question that could be generalized beyond education, but I am trying to figure out how to best incorporate retention rates into a tableau worksheet over time. My goal is to get to this:

Year 1	Year 2	Year 3
50%	60%	70%

Where each of the percentages are calculated on the fly based on a filter applied and represent the percentage of students from YEAR-1 also enrolled in YEAR (So, 50% of Students from Year 0 were also enrolled in Year 1). Currently, I have a medium sized data set that looks something like this:

SID	Program	EnrolledYear
SID1	PROG1	YEAR1
SID2	PROG1	YEAR1
SID1	PROG1	YEAR2
SID1	PROG1	YEAR3
SID3	PROG2	YEAR3
SID3	PROG2	YEAR4

I would like to take this and find a way that I could filter by PROG1 and get:

Year 2	Year 3	Year 4
50%	100%	N/A

And then subsequently filter by PROG2 in a dashboard and get the following without major hassle:

Year 2	Year 3	Year 4
N/A	N/A	100%

Any ideas on how best to do this?

Partially Redacting Information via Calculation

tableaucommunity@tableau.com — Thu, 02 Jan 2014 19:10:32 GMT

Hello all,

I am trying to find a good way doing this, but so far I not finding the answer. I need to do a count of records and display them as usual as long there are more than 10 records. I've tried:

IF sum([Number of Records]) < 10 THEN null ELSE sum([Number of Records]) END

That works, but then there is no indication that an empty cell is actually a <10 cell. That isn't quite what I want.

IF sum([Number of Records]) < 10 THEN "*" ELSE str(sum([Number of Records])) END

That works too, but then the resulting value is a string, not a number. That creates a whole new set of problems (for example, I can't format the string as a number, so no commas for thousands).

Suggestions?

Content in Tableau Community Forums

Quick and Easy Retention Rates?

Partially Redacting Information via Calculation