Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
phongnnguyen
Contributor II
Contributor II

how to use combine rangeavg with distinct

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,

0 Replies