Hello,
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:
I created a derived table for cohorts based off of information from the Looker Community such as:
https://community.looker.com/lookml-5/analytic-block-dynamic-previous-period-analysis-using-date-sta...https://community.looker.com/lookml-5/analytic-block-cohorting-users-by-creation-date-and-order-tran...https://community.looker.com/lookml-5/analytic-block-cohorts-as-filters-using-templated-filters-6065Using 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!
Thanks