0 Replies Latest reply: Oct 19, 2018 12:26 PM by Phong Nguyen RSS

    how to use combine rangeavg with distinct

    Phong Nguyen

      Hi all,

       

      My set analysis is used to calculate average of range unique value. like my example

      Date 1: Value = 100

      Date 2: Value = 200

      Date 3: Value = 300

      Date 4: Value = 100

      Date 5: Value = 100

      So my result what i want to show is:

      Date 1: 100

      Date 2: (200+100)/2 = 150

      Date 3: (100+200+300)/3=200

      Date 4: (100+200+300)/3=200 (distinct value 100)

      Date 5: (100+200+300)/3=200 (distinct value 100)

       

      I use this analysis: rangeavg(above(sum(distinct value),0,row())) But it not my expectation result

       

      Thanks for your consider and please help me if you have any solution for that

       

      Cheers,