How to get the return time?

[#1]

Hi All,

I have the following records:

LOAD * Inline
[Region,MemberId, BuyDate
Brazil,1,2010/10/01
Brazil,1,2010/10/05
Brazil,1,2010/10/10
Brazil,2,2010/11/01
Brazil,2,2010/11/03
]

Now I want to calculate after how many average days, the member will get back and but a new product.

And the results are divided by Region, MemberId

It looks like this:

Region, MemberId, Average Days

Brazil, 1 ,(4+5)/2

Brazil, 2, 2/1

How to calculate that average days?

Thanks.

[erichshiino · Accepted solution]

Hi,

Please check answer on attachment.

I created two differente expression to solve it. I prefer the second one, because you could see the global results.

Hope it helps,

Rgds,