/profile-content.jspa?filterID=contentstatus[published]&targetUser=4469 Recent content in Tableau Community Forums en Wed, 05 Sep 2012 15:20:38 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2012-09-05T15:20:38Z en https://community.tableau.com/thread/119916 <!-- [DocumentBodyStart:ca74d7c1-c72f-49db-91a1-c77e5ae50ac2] --><div class="jive-rendered-content"><p>I'd like to create a table similar to the table below. I'd like the user to be able to utilize date filters and not impact the rolling averages. I tried using basic table calculations but this doesn't really use the last 7 days, just the previous 7 values. Any ideas as to how I would accomplish this?</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 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>Date</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>Metric</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>Avg (last 7 days)</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>Avg (last 30 days)</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">1/2/2012</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">10</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;">9</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">1/3/2012</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">15</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">14</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">12</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">1/4/2012</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;">14</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">10</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">1/5/2012</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">24</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">21</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">18</td></tr></tbody></table></div><!-- [DocumentBodyEnd:ca74d7c1-c72f-49db-91a1-c77e5ae50ac2] --> Wed, 05 Sep 2012 15:20:38 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/119916 2012-09-05T15:20:38Z 6 years 10 months ago 0 https://community.tableau.com/thread/117195 <!-- [DocumentBodyStart:b66026ad-13cb-4f2b-aaba-95539bc72eea] --><div class="jive-rendered-content"><p>I'm trying to understand the correlation between two dates. Our data is structured similar to the table below. I'd like to compare the metrics from one date to a second date to see if there is a correlation between the two days. I'd like to create a calculated field similar to IF Date = 2/1/2012 THEN AVG(Metric) to calculate the average metric value for the first date range. I'd do a second calculated field for 3/1/2012 so I could compare the values between two days and understand the correlation. I've been unable to create this calculated field. Any suggestions?</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><table border="1" class="jiveBorder" style="border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: rgb(0, 0, 0); border-right-color: rgb(0, 0, 0); border-bottom-color: rgb(0, 0, 0); border-left-color: rgb(0, 0, 0); border-image: initial; width: 100%;"><thead><tr><th style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Date</strong></th><th style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Element Name</strong></th><th style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Metric</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">2/1/2012</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">Element 1</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">1</td></tr><tr><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">2/1/2012</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">Element 2</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">.89</td></tr><tr><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">2/1/2012</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">Element 3</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">.92</td></tr><tr><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">3/1/2012</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">Element 1</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">1.03</td></tr><tr><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">3/1/2012</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">Element 2</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">.72</td></tr><tr><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">3/1/2012</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">Element 3</td><td style="border:1px solid black;border-image: initial;border-left-color: rgb(0, 0, 0);border-bottom-color: rgb(0, 0, 0);border-right-color: rgb(0, 0, 0);border-top-color: rgb(0, 0, 0);border-left-style: solid;border-bottom-style: solid;border-right-style: solid;border-top-style: solid;border-left-width: 1px;border-bottom-width: 1px;border-right-width: 1px;border-top-width: 1px;padding: 2px;">.99</td></tr></tbody></table></div><!-- [DocumentBodyEnd:b66026ad-13cb-4f2b-aaba-95539bc72eea] --> Tue, 24 Apr 2012 00:11:00 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/117195 2012-04-24T00:11:00Z 7 years 2 months ago 2 0