This content has been marked as final.
Show 2 replies


2. Re: Help!!!
David Garcia Oct 20, 2018 9:12 PM (in response to Matthew Hefferon)That worked, thanks so much Matt!
For some reason Tableau is not summing correctly my information. I want to calculate the total reject % of the total rejects divided by total count, which in total should give me 7.9% based on a total of 73 rejects out of 924 total. What Tableau is calculating a reject % for each row and then summing close to 234%, instead of calculating the total rejects / the total count. What am I doing wrong? Please help! Here is my data.
Machine_Name  Shift  Day  Machine_ID  Month  Product_Code  RejectCount  TotalCount  Year 
Ironer 1  1st  16  11,325  10  211  3  3  2,018 
Ironer 1  1st  16  11,325  10  212  0  0  2,018 
Ironer 1  1st  16  11,325  10  212  1  1  2,018 
Ironer 1  1st  16  11,325  10  212  3  9  2,018 
Ironer 1  1st  16  11,325  10  212  0  19  2,018 
Ironer 1  1st  16  11,325  10  212  3  20  2,018 
Ironer 1  1st  16  11,325  10  212  0  35  2,018 
Ironer 1  1st  16  11,325  10  212  2  49  2,018 
Ironer 1  1st  16  11,325  10  212  7  56  2,018 
Ironer 1  1st  16  11,325  10  212  8  59  2,018 
Ironer 1  1st  16  11,325  10  212  8  89  2,018 
Ironer 1  1st  16  11,325  10  212  18  89  2,018 
Ironer 1  1st  16  11,325  10  212  15  99  2,018 
Ironer 1  1st  16  11,325  10  212  13  129  2,018 
Ironer 1  1st  16  11,325  10  212  3  131  2,018 
Ironer 1  1st  16  11,325  10  212  5  136  2,018 
Ironer 1  2nd  16  11,325  10  212  0  0  2,018 
73  924 
That worked, thanks so much Matt!