Our team is currently working on several requests that involve the ability to create custom cohorts. Here are some examples of cohort related problems we’re working on:
- If customer bought x product in time frame A, what products did they buy in time frame B (time frame b can be in the future or in the past)
- Flow of products purchased from first order, to second order, to third order.
I created a derived table for cohorts based off of information from the Looker Community such as:
Using the info from these articles I was able to create a cohort based on their purchase date if the comparison date range is always the same. For example, if the user selects date range A when the product purchase was made, the comparison date range is a static 2 previous years. This works, but we are trying to gain the capability of making these cohorts dynamic for our end users instead of creating custom work for them each time we get a request.
Any help or guidance would be greatly appreciated!