8 Replies Latest reply on Apr 11, 2017 7:11 AM by michael shin

    Aggregate of aggregate  (e.g., Sum of counts)

    michael shin

      Hello all. I have a metric that is tracked by DATE from the following calculated field:

       

      if [Rate%] >= .9 then 1

      else 0

      END

       

      I then wish to aggregate the view to WEEK.  As above calculation is by DATE, I'd like to sum up the daily boolean field.  So, we may have the following:

       

      Week 1:  3

      Week 2:  0

      Week 3.  5

       

      etc.

       

      Tableau is NOT letting me do a sum of the above.  Rate%  is a ratio of CountD(A) / CountD (B).  So, I am aggregating an aggregate.  Any good work-around?

       

      Mike