How calculate recurrency

[ecabanas]

Hi guys,

I'm doing a table to calculate the cohort o customer recurrency . For example

The calculation is, how many customers return in the following months:

Many thank's guys

[sunny_talwar]

I see what you mean now. I will come back with an expression that will do that

[sunny_talwar · Accepted solution]

Although there might be an easy way to do this, but I came up with this expression which seems to work except for some reason it hides the dimension when the value = 0. I think we need expert advice here from swuehl‌

I am sure he not only will get a simplified version of this expression, but will also resolve the other issue of hiding dimension.

Count(DISTINCT {<Customer = p({<Order = p({<MonthYear = {"$(=vVar)"}>})*p({<Order = {"=Month([Date Order]) = Month(FirstOrder)"}>})>})>}Order)

Best,

Sunny

[swuehl]

Sunny,

your solution seems to work for me, even showing dimensions with zero value in the expression.

Attached another approach.

[sunny_talwar]

I had a hidden column (Count(Customer)) which was letting me show the 0 months. I have disabled that, can you check now.

[ecabanas]

Hi Sunny,

I'm going to stress the function and I hope it will work in the real model

Crossing fingers!!!!

Many thank's for your help

[sunny_talwar]

Do look at Stefan's expression as well.