how do I create a cohort with a date filter that dynamically adjusts to the current day?
Hi Elise S., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Use a relative date range in the cohort definition rather than fixed dates.
In the Cohort Builder, define your condition with a time window like:
“Users who did <event> more than 10 times in the last 7 days”
“Users who did <event> for the first time in the last 30 days”
These “last X days/weeks/months” style filters are evaluated at query time, so the cohort is recomputed based on “as of right now” every time it’s used, not on a fixed calendar range. [Cohorts; How cohorts are computed]
Because cohorts are always computed dynamically when you run a report, any relative time filter you use (e.g. “last 30 days”) will automatically adjust to the current day. [How cohorts are computed]
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! 📚
The knowledge sources don’t mention any way to make a “since X date” condition where X itself moves forward automatically (like “since the first of the current month” or “since N days after signup”) inside a cohort definition.
What is documented:
Cohorts are recomputed dynamically “as of right now” whenever you use them, but that just means the cohort logic is re‑run; it doesn’t add extra dynamic behavior to a fixed date you type in. [How cohorts are computed]
You can use relative windows like “in the last 7 days / 30 days” in cohort conditions, and those do adjust automatically because they’re defined relative to “now,” not to a fixed calendar date. [Cohorts]
So, based on the docs:
You can get dynamic behavior with “in the last X days/weeks/months”.
There’s no documented support for a cohort condition like “since 2024‑01‑01, but have that 2024‑01‑01 itself move forward automatically.” To change that “since” date, you’d need to edit the cohort definition manually.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
