
1. Re: Help on a calculated field
Joe Oppelt Sep 27, 2016 12:54 PM (in response to Abhishikt Dawson)if [a]='Yes' or [b] = 'Yes' or [c] = 'Yes' ... THEN 1 else 0 END
That will get evaluated for each row.
{ FIXED : COUNT([whatever field]) }
This will give you the count of rows in your data source (no matter what filters are used on your sheet. This assumes V9.0 or higher of Tableau.)
SUM([Calcinthefirstlineofthisreply])
This will give you the sum of rows that have at least one 'Yes'
The SUM calc divided by the FIXED calc will give you your percentage.

2. Re: Help on a calculated field
Shawn Wallwork Sep 27, 2016 1:07 PM (in response to Abhishikt Dawson)I interpreted this a wee bit different than Joe  he's probably right, but since I created a workbook before I saw his response, I'll attach it anyway. It's 10.0 and uses the new pivot option to reshape your data. Here's what you get:
Of course we have no idea what version of Tableau you are working on. Or what the rest of your situation really is. But take a look at the attached 10.0 workbook and see what you think.
Shawn

Pivot then calc.twbx 244.2 KB


3. Re: Help on a calculated field
Abhishikt Dawson Sep 27, 2016 1:42 PM (in response to Joe Oppelt)Thank you for the reply!
I am working on tableau 9.2 version, I think I forgot to mention that my data that is currently there in the excel sheet is taken as a pivot data in tableau.
So i need a work around to this assuming these 8 column of data are actually in a pivot.
Thanks

4. Re: Help on a calculated field
Abhishikt Dawson Sep 27, 2016 1:43 PM (in response to Shawn Wallwork)Thank you for the reply!
I am working on tableau 9.2 version, I think I forgot to mention that my data that is currently there in the excel sheet is taken as a pivot data in tableau.
So i need a work around to this assuming these 8 column of data are actually in a pivot.
Thanks