/profile-content.jspa?filterID=contentstatus[published]&targetUser=31721 Recent content in Tableau Community Forums en Thu, 06 Mar 2014 19:07:32 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2014-03-06T19:07:32Z en https://community.tableau.com/thread/138165 <!-- [DocumentBodyStart:7c22e99c-1100-4538-b43c-5ca04f1e24a9] --><div class="jive-rendered-content"><p>Hi All, I am facing a difficulty while creating a report. Below is my sample table data.</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">item</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>date1</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">date2</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">date3</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">date4</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">date5</th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">item1</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">20</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">12</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">23</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">23</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">18</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">item2</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">34</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">45</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">54</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">22</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">22</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">item3</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">8</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">8</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">65</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">3</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">54</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">item4</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">test1</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">test2</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">test2</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">test3</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">test3</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>If you can see for item 1 for date3 and date4 the value in the cells are same. And same thing applies for other rows too (item4 in date2 and 3). My requirement is if my report see the same data as of last day's data it should give me a custom msg. As example for item1 in date4 cell it should display "no run". </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Is this possible by using tableau? Please let me know. Thanks in advance.</p></div><!-- [DocumentBodyEnd:7c22e99c-1100-4538-b43c-5ca04f1e24a9] --> comparing_values Thu, 06 Mar 2014 19:07:32 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/138165 2014-03-06T19:07:32Z 5 years 4 months ago 3 0