/profile-content.jspa?filterID=contentstatus[published]&targetUser=40656 Recent content in Tableau Community Forums en Thu, 03 Jul 2014 08:50:08 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2014-07-03T08:50:08Z en https://community.tableau.com/thread/145313 <!-- [DocumentBodyStart:feda5d65-0e20-4bf9-b4f6-fbf8be85f565] --><div class="jive-rendered-content"><p>How do I create calculated field if I want to sum up multiple values for the day and then average of the sums for a period. e.g. Say on the 1st of month I have 4 sales values and on 2nd I have 5 sales values and so on... till 30th. Now I want to sum all sales values for 1st , then 2nd&#160; , so on and want to find average for 30 days.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>i.e SUM(1st) +SUM(2nd)+.../Number Of days </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>This will give me average sales value for one day and then I can use this value in my planning.(other calculation) </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Thanks in advance.</p></div><!-- [DocumentBodyEnd:feda5d65-0e20-4bf9-b4f6-fbf8be85f565] --> Thu, 03 Jul 2014 08:50:08 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/145313 2014-07-03T08:50:08Z 4 years 12 months ago 2 0