/profile-content.jspa?filterID=contentstatus[published]&targetUser=18068 Recent content in Tableau Community Forums en Fri, 08 Feb 2013 17:54:46 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2013-02-08T17:54:46Z en https://community.tableau.com/thread/123440 <!-- [DocumentBodyStart:e7b0584f-ecc3-4c76-b6a8-f316d556164f] --><div class="jive-rendered-content"><p style="margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;">Hi, </span></p><p style="margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;">I am trying to calculate the min, max and last value in a Date row - and sum it on higher level - but cannot manager to get it done. </span></p><p style="margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;">Even I found a couple of simmilar examples - they dont seem to fit in my case:</span></p><p style="min-height: 8pt; padding: 0px; margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;"> </span>&#160;</p><p style="margin-top: auto; margin-bottom: auto;"><span style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;"><strong>Data:</strong><br/></span></p><table border="0" cellpadding="0" cellspacing="0" width="347"><tbody><tr><td class="xl82" height="20" style="border:0px solid black;" width="80">Target Day</td><td class="xl82" style="border:0px solid black;border-left: medium none;" width="80">Forecast Day</td><td class="xl82" style="border:0px solid black;border-left: medium none;" width="80">Amount</td><td class="xl82" style="border:0px solid black;border-left: medium none;" width="107">Item</td></tr><tr><td align="right" class="xl65" height="20" style="border:0px solid black;border-top: medium none;">17.10.2013</td><td align="right" class="xl66" style="border:0px solid black;border-top: medium none;">01.01.2012</td><td align="right" class="xl67" style="border:0px solid black;border-top: medium none;">5</td><td align="right" class="xl68" style="border:0px solid black;border-top: medium none;">123</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">02.01.2012</td><td align="right" style="border:0px solid black;">5</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">03.01.2012</td><td align="right" style="border:0px solid black;">6</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">04.01.2012</td><td align="right" style="border:0px solid black;">22</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">05.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">06.01.2012</td><td align="right" style="border:0px solid black;">15</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl72" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl73" style="border:0px solid black;">07.01.2012</td><td align="right" class="xl74" style="border:0px solid black;">15</td><td align="right" class="xl75" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl76" height="20" style="border:0px solid black;border-top: medium none;">18.01.2013</td><td align="right" class="xl66" style="border:0px solid black;border-top: medium none;">01.01.2012</td><td align="right" class="xl67" style="border:0px solid black;border-top: medium none;">1</td><td align="right" class="xl68" style="border:0px solid black;border-top: medium none;">123</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">02.01.2012</td><td align="right" style="border:0px solid black;">1</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">03.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">04.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">05.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">06.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl71" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl78" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl73" style="border:0px solid black;">07.01.2012</td><td align="right" class="xl74" style="border:0px solid black;">30</td><td align="right" class="xl75" style="border:0px solid black;">123</td></tr><tr><td align="right" class="xl65" height="20" style="border:0px solid black;border-top: medium none;">17.10.2013</td><td align="right" class="xl66" style="border:0px solid black;border-top: medium none;">01.01.2012</td><td align="right" class="xl67" style="border:0px solid black;border-top: medium none;">20</td><td align="right" class="xl79" style="border:0px solid black;border-top: medium none;">456</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">02.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">03.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">04.01.2012</td><td align="right" style="border:0px solid black;">22</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">05.01.2012</td><td align="right" style="border:0px solid black;">56</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl69" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl70" style="border:0px solid black;">06.01.2012</td><td align="right" style="border:0px solid black;">55</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl72" height="20" style="border:0px solid black;">17.10.2013</td><td align="right" class="xl73" style="border:0px solid black;">07.01.2012</td><td align="right" class="xl74" style="border:0px solid black;">15</td><td align="right" class="xl81" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl76" height="20" style="border:0px solid black;border-top: medium none;">18.01.2013</td><td align="right" class="xl66" style="border:0px solid black;border-top: medium none;">01.01.2012</td><td align="right" class="xl67" style="border:0px solid black;border-top: medium none;">10</td><td align="right" class="xl79" style="border:0px solid black;border-top: medium none;">456</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">02.01.2012</td><td align="right" style="border:0px solid black;">10</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">03.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">04.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">05.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl77" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl70" style="border:0px solid black;">06.01.2012</td><td align="right" style="border:0px solid black;">20</td><td align="right" class="xl80" style="border:0px solid black;">456</td></tr><tr><td align="right" class="xl78" height="20" style="border:0px solid black;">18.01.2013</td><td align="right" class="xl73" style="border:0px solid black;">07.01.2012</td><td align="right" class="xl74" style="border:0px solid black;">20</td><td align="right" class="xl81" style="border:0px solid black;">456</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px; margin-top: auto; margin-bottom: auto;">&#160;</p><p style="margin-top: auto; margin-bottom: auto;"><span style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;"><strong>Workbook - Details:</strong><br/><a href="https://community.tableau.com/servlet/JiveServlet/showImage/2-199901-5170/Unbenannt.JPG"><img alt="Unbenannt.JPG" class="jive-image-thumbnail jive-image" height="321" onclick="" src="https://community.tableau.com/servlet/JiveServlet/downloadImage/2-199901-5170/564-321/Unbenannt.JPG" style="" width="564"/></a></span></p><p style="margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;">So I have for each Item and each Target Date a couple of ammounts...</span></p><p style="margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;">I am only interested in the MIN, MAX and the LAST Value each Target Day for each Item.</span></p><p style="min-height: 8pt; padding: 0px; margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;"> </span>&#160;</p><p style="margin-top: auto; margin-bottom: auto;"><strong><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;">Worbook - Summary:<br/></span></strong><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;">Then I want to summ all MIN, MAX, LAST values up to show a 3 LineGraph as a Summary of all ITEMS</span></p><p style="margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;"><a href="https://community.tableau.com/servlet/JiveServlet/showImage/2-199901-5174/Unbenannt_1.JPG"><img alt="Unbenannt_1.JPG" class="jive-image-thumbnail jive-image" height="345" onclick="" src="https://community.tableau.com/servlet/JiveServlet/downloadImage/2-199901-5174/579-345/Unbenannt_1.JPG" style="" width="579"/></a></span></p><p style="min-height: 8pt; padding: 0px; margin-top: auto; margin-bottom: auto;"><span lang="EN-US" style="font-family: 'Arial','sans-serif'; color: #575757; font-size: 10pt;"> </span>&#160;</p></div><!-- [DocumentBodyEnd:e7b0584f-ecc3-4c76-b6a8-f316d556164f] --> aggregation value last Fri, 08 Feb 2013 17:54:46 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/123440 2013-02-08T17:54:46Z 6 years 5 months ago 1 0