/profile-content.jspa?filterID=contentstatus[published]&targetUser=30592 Recent content in Tableau Community Forums en Tue, 17 Dec 2013 15:32:18 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2013-12-17T15:32:18Z en https://community.tableau.com/thread/136832 <!-- [DocumentBodyStart:5dff4c4e-cc53-4eea-9664-56d56d3f4e31] --><div class="jive-rendered-content"><p>Hey Everyone,</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I'm sure this will be a snap for most of you...</p><p>Lets say I have a group of software testers, and I want to return their 'pass/fail' as a percentile - while only keeping the people who have failed code. In this case I want to display only "John" without filtering out his passes. His percentile should read Pass: 90.91% Fail: 9.09%</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><table border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><thead><tr><th style="border:1px solid black;border: 1px solid #000000;padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Resouce Name</strong></th><th style="border:1px solid black;border: 1px solid #000000;padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Status</strong></th><th style="border:1px solid black;border: 1px solid #000000;padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Number of Records</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">Joe</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">Passed</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">11</td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">Mark</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">Passed</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">11</td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">John</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">Passed</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">10</td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">John</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">Failed</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">1</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Thanks,</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Regards,</p><p>Tom White</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Message was edited by: Tom White Sorry, I'm new at this hole thing - as you can probably tell by the major update to my data format... </p></div><!-- [DocumentBodyEnd:5dff4c4e-cc53-4eea-9664-56d56d3f4e31] --> filter percentile urgent Tue, 17 Dec 2013 15:32:18 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/136832 2013-12-17T15:32:18Z 5 years 6 months ago 2 0