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.