3 Replies Latest reply on May 16, 2018 11:40 AM by Bryce Larsen

    Different aggregations for Day,Month and Quarter

    susheela.hegde

      Hi All,

       

      I have to display the total population for day, month, quarter, year.  total population is fixed to month.

      If I select parameter Day, total population is 400,000 for May and 420,000 for April. If I select Month, it should be same.

       

      How ever, when we select Quarter, I should get Avg of 400,000 and 420,000  and not sum. Same for the year. I cannot get this.

       

      so for quarter, it should be Avg(sum(total population for month1)+sum(total population for month2)+sum(total population for month3))

      and for the year Avg(sum (total population for 12 months or till current month)).

       

      How can we do this in tableau?

      I have attached the workbook.