a year ago
Introducing the 'm' parameter for its usage in cohort formulas
The m parameter is now available, allowing you to reference the current cohort month directly in formulas.
Example Usage
Here’s an example formula leveraging the m parameter:
IF m <= 12 THEN (This.m.c-3:c-1 / 3) ELSE (This.t-1)
Explanation:
- For the first 12 months of a cohort, it calculates the average value of the same month across the last 3 cohorts.
- For months beyond 12, it references the value from the previous period.
How to use it
You can use this parameter for IF-ELSE logic.m dynamically adapts to the cohort month in context to execute the correct formula.
Learn more about cohorts functions and their structure here: Link.