/profile-content.jspa?filterID=contentstatus[published]&targetUser=28547 Recent content in Tableau Community Forums en Mon, 17 Nov 2014 22:35:06 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2014-11-17T22:35:06Z en https://community.tableau.com/thread/151894 <!-- [DocumentBodyStart:4c90b031-e23d-4f1d-9ddd-b51c96cf984b] --><div class="jive-rendered-content"><p>This might be very easy but I am having a hard time to figure it out. In the screenshot below, I have 2 dimensions, cateogry (1,2,3...) and ID, a calculated field that shows the minimum measure of each ID, and another window_avg that calculates the average of these minimum measures.</p><p><a href="https://community.tableau.com/servlet/JiveServlet/showImage/2-312252-24058/untitled.JPG"><img alt="untitled.JPG" class="image-1 jive-image" height="788" src="https://community.tableau.com/servlet/JiveServlet/downloadImage/2-312252-24058/untitled.JPG" style="height: auto;" width="427"/></a></p><p>I would like to show just the "avg of min" of each category, as:</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><table border="1" class="jiveBorder" height="115.39999997615814" style="border: 1px solid #000000; width: 201.399999976158px; height: 70.3999999761581px;" width="199.39999997615814"><thead><tr><th style="border:1px solid black;border: 1px solid #000000;padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Category</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>Avg of all min measures</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">1</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">-381</td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">2</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">-378</td></tr><tr><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">3</td><td style="border:1px solid black;border: 1px solid #000000;padding: 2px;">-320</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I can not do this because I used window_avg and it would calculate based on what's shown in the "window". </p><p>any help is greatly appreciated.</p></div><!-- [DocumentBodyEnd:4c90b031-e23d-4f1d-9ddd-b51c96cf984b] --> calculation window window_avg Mon, 17 Nov 2014 22:35:06 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/151894 2014-11-17T22:35:06Z 4 years 7 months ago 3 0