3 Replies Latest reply on Jun 30, 2015 8:18 AM by alejandro.molina

Exclude results from self-evaluations

alejandro.molina Jun 29, 2015 3:50 PM

Hello Everybody.

In the attached workbook I have the results from a departamental survey.

I present the results for the Evaluated Departments based on the Evaluator Departments' ratings.

I want to exclude the results for the same department (the self-assessment), in order to show only the results from the other departments.

Thanks in advance for your help.

Regards

1. Re: Exclude results from self-evaluations

ailsa.zheng Jun 29, 2015 5:20 PM (in response to alejandro.molina)
Hi Alejandro,

I created a calculated field:

If [(Evaluated) Department]=[(Evaluator) Department] then 1 else 0 END

And then filtered out the "1" results. Let me know if that's what you need.

alejandro.twbx 52.1 KB
Like Show 0 Likes(0)

Actions
2. Re: Exclude results from self-evaluations

Shawn Wallwork Jun 29, 2015 5:20 PM (in response to alejandro.molina)

Alejandro, can you simplify your workbook to only show the problem you are struggling with? I opened your workbook expecting to find a field named 'self-assessment' but didn't see one. So I really don't know how to help you.

Oh, thanks for attaching a workbook! (Just help us focus on the problem, and eliminate everything else.)

Cheers,

--Shawn
Like Show 0 Likes(0)

Actions
3. Re: Exclude results from self-evaluations

alejandro.molina Jun 30, 2015 8:18 AM (in response to ailsa.zheng)

Thanks Ailsa. It worked pretty well. I didn´t see how easy you fixed it. I was expecting sonthing else more elaborated
Thanks any way.
Regards
Like Show 0 Likes(0)

Actions

Tableau Community