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,
