4 Replies Latest reply on Jul 18, 2016 5:35 AM by Johnson Muthii

Creating a calcualted field from a subset of a dimension

Johnson Muthii Jul 14, 2016 5:11 AM

I have a dimension named Application status which has three sub-levels .i.e Applicant, Accepted and Enrolled. I would like to created a

new percentage field (i.e Enrolled / Accepted) called %enrolled and place it besides the enrolled column in tableau.

Attached is my work book.

Any input will be highly appreciated.

1. Re: Creating a calcualted field from a subset of a dimension

pooja.gandhi Jul 14, 2016 9:22 AM (in response to Johnson Muthii)

Hi There!

What you have is a dimension with multiple members. And what you want is unpivoted measures so they can individually be used on the view. Create separate calcs for applicants, accepted and enrolled like so:

Applicants: countd(if ([App Status]) = 'Applicants' then [Appno] end)

similar ones for accepted and enrolled. Percentage would then just be:

[Enrolled]/[Accepted]
Like Show 0 Likes(0)

Actions
2. Re: Creating a calcualted field from a subset of a dimension

Johnson Muthii Jul 15, 2016 2:43 AM (in response to pooja.gandhi)

Hello Pooja,

Thanks so much for you reply. Will try this.

Regards.
Like Show 0 Likes(0)

Actions
3. Re: Creating a calcualted field from a subset of a dimension

Johnson Muthii Jul 18, 2016 1:39 AM (in response to Johnson Muthii)

Hello Pooja,

I managed to create the calculated fields but can visualize in table form..Not sure where am going wrong.

Regards.
Like Show 0 Likes(0)

Actions
4. Re: Creating a calcualted field from a subset of a dimension

Johnson Muthii Jul 18, 2016 5:35 AM (in response to Johnson Muthii)

Hello Pooja,

I finally managed to do it, thanks so much for the directions.

Regards.
Like Show 1 Likes(1)

Actions

Tableau Community Forums