/profile-content.jspa?filterID=contentstatus[published]&targetUser=16143 Recent content in Tableau Community Forums en Thu, 04 Apr 2013 14:35:17 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2013-04-04T14:35:17Z en https://community.tableau.com/thread/124922 <!-- [DocumentBodyStart:77fd90ad-9c1a-4054-a5c2-9b2712ac7bd8] --><div class="jive-rendered-content"><p>I have a dataset that lists equipment and certain attributes of that equipment. One of those attributes is the original purchase date. Since we are on a 5 year refresh cycle, we want to determine which assets are the oldest 20% of our existing assets. The problem is that I'm having trouble creating a filter or something to do this in Tableau.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Dataset looks approximately like this:</p><p style="min-height: 8pt; padding: 0px;">&#160;</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"><strong>Serial Number</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>Building</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>Purchase Date</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">1234567890</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Main Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">1/1/2009</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">2634768779</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Secondary Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">5/6/2009</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">8056348796</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Secondary Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">3/5/2007</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">2565756854</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Our Third Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">5/6/2009</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">6843849376</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Main Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">3/5/2007</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">4809989755</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Secondary Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">5/6/2009</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">2435363456</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Main Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">1/1/2009</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">2353768433</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Main Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">10/12/2004</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">2393873222</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Secondary Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">1/1/2009</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">3546578893</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Our Third Office</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">3/5/2007</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>How can I filter out the newest N% or oldest N% so that I can break the remaining assets down by building? I have tried several methods, but I'm relatively new to Tableau, so I have no idea if I'm on the right trail or not.</p></div><!-- [DocumentBodyEnd:77fd90ad-9c1a-4054-a5c2-9b2712ac7bd8] --> dates percentages Thu, 04 Apr 2013 14:35:17 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/124922 2013-04-04T14:35:17Z 6 years 3 months ago 2 0