/profile-content.jspa?filterID=contentstatus[published]&targetUser=17304 Recent content in Tableau Community Forums en Thu, 10 Jan 2013 14:54:46 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2013-01-10T14:54:46Z en https://community.tableau.com/thread/122675 <!-- [DocumentBodyStart:43249138-061d-4be8-9357-aa6a1a4064e3] --><div class="jive-rendered-content"><p>Good afternoon,</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I'm attempting to create an "honor roll" type of report - where I have a:</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Name</p><p> - Course 1</p><p>- Course 2</p><p>- Course 3 , etc.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>with scores listed out. What I want to be able to do is filter out any person who has a score less than X in any one of his/her assigned courses. Thus far, I can filter out the values I don't want to see - but I haven't figured out a way to filter out the person altogether.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Example: </p><p>What I see now (with filter to show grades that are 80 or better, andthe strikethrough is short hand for excluded from this view!):</p><table border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><thead><tr><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle">Students<br/></th><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Courses</strong></th><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Grades</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Student A</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"><br/></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"><br/></td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"><br/></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Course 1</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">88</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"><br/></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Course 2</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">90</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"><br/></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"><span style="text-decoration: line-through;">Course 3</span></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"><span style="text-decoration: line-through;">75</span></td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);">Student B</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);"><br/></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);"><br/></td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);"><br/></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);">Course 1</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);">99</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>What I would like to see (where the strikethrough is short hand for excluded from this view!)</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">Students<br/></th><th style="border:1px solid black;border: 1px solid #000000;padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Courses</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>Grades</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><span style="text-decoration: line-through;">Student A</span></td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><br/></td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><br/></td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><br/></td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><span style="text-decoration: line-through;">Course 1</span></td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><span style="text-decoration: line-through;">88</span></td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><br/></td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><span style="text-decoration: line-through;">Course 2</span></td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><span style="text-decoration: line-through;">90</span></td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><br/></td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><span style="text-decoration: line-through;">Course 3</span></td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;"><span style="text-decoration: line-through;">75</span></td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;">Student B</td><td style="border:1px solid black;border: 1px solid #000000;"><br/></td><td style="border:1px solid black;border: 1px solid #000000;"><br/></td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;"><br/></td><td style="border:1px solid black;border: 1px solid #000000;">Course 1</td><td style="border:1px solid black;border: 1px solid #000000;">99</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Does that make sense? I can provide more detail if needed. </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Thanks,</p><p>Talia Hudspeth</p></div><!-- [DocumentBodyEnd:43249138-061d-4be8-9357-aa6a1a4064e3] --> groups filter Thu, 10 Jan 2013 14:54:46 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/122675 2013-01-10T14:54:46Z 6 years 6 months ago 2 0