Hey everyone!
I’m trying to create a cohort framework in the backend of the model. To do this, I’m using my Datahub::Month dimension and my Revenue app::Cohort Months dimension. It should generate something like:
0 1 2
Jan 23 Jan 23 Feb 23 Mar 23
Feb 23 Feb 23 Mar 23 Apr 23
Mar 23 Mar 23 Apr 23 May 23
and so on.
Is this the best practice to enable cohort logic for things like churn?
To create my Cohort Months dimension, I can manually type integers 0 through 60 for example, but is there a way to use PREVIOUS() to just increment 1 each row to do this? Screenshot:
