title: Tableau - weekly average from daily data
body: <p>Using Tableau 8.1.<br>
  Daily data like this:</p>
  
  <pre><code>Date     Sales
  1-1-14     $5
  1-2-14     $2
  ...
  6-15-14    $15
  </code></pre>
  
  <p>Which can be aggregated to weeks of course</p>
  
  <pre><code>Week 1   $15
  Week 2   $12
  Week 3   $10
  Week 4   $13
  </code></pre>
  
  <p>etc.</p>
  
  <p>I would like to get the weekly average of each month<br>
  So like this:</p>
  
  <pre><code>          Weekly Average
  Month 1     (weekly average of the weekly total sales)  ($15+$12+$10+13)/4 = 12.5
  Month 2 
  Month 3 
  </code></pre>
  
  <p>Does that make sense?  If ou simply put "average" in the tableau table, it gives the average daily value PER WEEK (or month) &lt; - I don't want that.  I want the average of the weekly totals per month.</p>