2 Replies Latest reply on Oct 3, 2018 3:37 AM by Mahfooj Khan

    Double Aggregation for Tableau

    Mitsu Mehta

      Hi ,



        I have just started working on Tableau.We are creating one calculation based on the case statement e.g. count distinct customers if key=1 and type='Pass' . then i have to do total across geography. I have tried table calculation, i have tried sum(count) which is not allowed. i have tried using window_sum functions.


      with table calculation i am getting total records not the values which should come after satisfied case condition.


      Like total customers for india is 1000 but which satisfied key=1 and type='Pass' are  400 only.


      When i am using table calculation ,I am getting 1000 and not 400.


      Please help me with this.