Average range in qlik sense

[phongnnguyen]

Hello everybody,

I have a problem about to calculate average a range. like my example below:

Date	Equity
1	1000
2	1000
3	2000
4	500
5	500
6	3000

I want my result is a column with accumulate average UNIQUE Equity

Date	Equity	average Equity
1	1000	1000
2	1000	1000
3	2000	1500
4	500	1166.67 = (1000+2000+500)/3
5	500	1166.67
6	3000	1625

Please help me if you have any solution for this

Many Thanks,

[sunny_talwar]

Is this something you need in the script?

[phongnnguyen]

Actually, I want to set my analysis to do that. I tried to use rangeAvg but it is not working.