Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cohort Analysis with Synthetic Dimension

Hi there,

I've been stuck trying to develop a cohort analysis for a client.

My problem is that the client needs very specific functionality when comparing cohorts.

For example, cohorts can be defined by the following:

Cohort 1: Cohort_Start_Month = Jan 2013, Region = Region A, Product = Product X

Cohort 2: Cohort_Start_Month = June 2012, Region = Region A, Product = Product Y

The difficulty here is that he wants a line chart to compare measures like sales amounts over time but using a common dimension with values, +1, +2, +3 etc. (so for Cohort 1, Jan 2013 = +1, Feb 2013 = +2 etc. and for Cohort 2, June 2012 = +1, Aug 2012 = +2, etc.) to easily compare the two cohorts over time. My thinking was that I need to convert each month from each cohort into these dimension values and then match them somehow. I've tried matching a valueloop() function to a variable that calculates these values but no luck.

Any ideas would be greatly appreciated.

Cheers,

Rhys

1 Reply
jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you attach some sample file?

Regards.

Jagan.