Yes â itâs absolutely possible, but it depends a bit on the BI/analytics tool youâre using.
In general:
Cohorts are usually defined by the first time a user (or entity) does something (e.g., sign-up date, first purchase date).
To make them relative to a time period you select on the dashboard, youâll need to filter or re-bucket the cohorts based on that selection.
How this works in practice
- 1.
Define the cohort event â e.g., âuser signup date.â
- 2.
Apply the dashboard date filter â instead of calculating cohorts for all time, the query respects the dashboardâs selected range (e.g., JanâMar signups only).
- 3.
Group by cohort â each user is bucketed into a cohort based on the event date (within the selected period).
- 4.
Measure retention/behavior â plot how those cohorts behave over subsequent days/weeks/months, relative to their own start date.
Example
If your dashboard filter is March 2025, the cohort logic will only include users who first did the event in March 2025.
The retention curves (or whatever metric) will then be shown just for those March cohorts, not for February or earlier.
Tool-specific notes
Looker / Power BI / Tableau â Yes, you can parameterize the cohort start date relative to a dashboard date filter.
Mixpanel / Amplitude â They have built-in cohort + relative date filtering.
SQL â Youâd use WHERE cohort_date BETWEEN <dashboard_start> AND <dashboard_end> before grouping by cohort.
đ So the short answer: Yes, itâs possibleâdefine your cohort on the chosen event date, and tie that to your dashboardâs date filter so cohorts shift relative to the selected period. @https://minecrftgeek.com/
