3 Replies Latest reply on Sep 27, 2018 11:47 AM by Naveen B

    Aggregation Logic

    vengadesh palani

      Hi all

       

      I have a dataset like below, by using dataset I want to show the answer  = 7.33

      temp.png

       

      Answer  = 7.33

       

      Logic

      Step 1: Distinct ID Count based on Month Start Date

      06/01/2018 --> 7

      07/01/2018 -->  6

      08/01/2018 --> 9

       

      Step 2:

      =(7+6+9) / 3

      =22/3

      =7.33