How to Display a Monthly Cohort Chart with Event Trigger Dates in Kapa.ai
kapa.ai is there a way to show a monthly chart, whereby the months across the bottom are cohorts (so Jan is for example the date at which a particular event was triggered)
kapa.ai is there a way to show a monthly chart, whereby the months across the bottom are cohorts (so Jan is for example the date at which a particular event was triggered)
Yes, this is essentially what Mixpanel's Retention report does. It groups users into cohorts based on when they performed a starting event, and then tracks their behavior over subsequent time periods.
Here's how it works:
The rows in the retention table represent cohorts â each row is a group of users who performed the "A event" (your trigger event) within a specific time bucket (e.g., January, February, etc.).
The columns show how many of those users returned (performed the "B event") in subsequent time intervals (Day 1, Week 1, Month 1, etc.).
So for example, if you set the time bucket to monthly, the first column (Date) would show Jan, Feb, Mar, etc. â each representing the cohort of users who first triggered your chosen event in that month. The "Size" column shows how many users are in each cohort.
"The first column (Date) indicates the day/week/month when the user performed the 'A event'. The Size column indicates the number of users that performed the 'A event' within the time period." [Retention basics]
You can also switch between a heatmap table view and a line chart view (the Retention Curve) to visualize this data differently. [Retention basics]
Additionally, if you want to simply visualize cohort sizes over time in a line/bar chart (without the retention follow-up behavior), you can use the Insights report â define a cohort based on when users triggered your event, and plot its size month by month. [Cohort analysis]
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Does mixpanel have a "compare to target" feature
Let me check the knowledge base for you again. One moment! đ
Based on the knowledge sources available to me, Mixpanel does not appear to have a dedicated "Compare to Target" feature (i.e., comparing a metric against a predefined goal or target value).
The comparison features that Mixpanel does offer include:
Compare to Past â Compare a metric against itself over a previous time period (previous day, week, month, quarter, year, or custom). [Comparisons docs]
Compare to Segment â Set a specific property value as a baseline and compare all other segments against it. [Comparisons docs]
Compare to Overall â See what proportion each segment makes up of the total value. [Comparisons docs]
These are supported across Insights, Funnels, and Retention chart types. [Comparisons docs]
However, the knowledge sources do not mention a "Compare to Target" or goal-tracking comparison feature. I'd recommend checking Mixpanel's official documentation or contacting Mixpanel support directly to confirm whether this capability exists or is on the roadmap.
âšī¸Â 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 behavior you're describing is expected in Mixpanel funnels. Step 1 of a funnel is always shown at 100% because it represents the entry point â all users who entered the funnel are counted from that first step.
To get the percentage of your total user base that reaches Step 2 (your event), you need to include "user exists" as Step 1 in your funnel definition. That way:
Step 1 = User exists (your full baseline population)
Step 2 = Your first event (will show the % of users who reached it)
Step 3 = Your second event (will show the % who reached it from Step 1)
This gives you a meaningful conversion rate from your total user base down through each event. [Funnels Quickstart]
If "user exists" isn't a trackable event in your setup, an alternative approach is to use a cohort of all your users as a filter on the funnel, or to use a top-of-funnel event that all users trigger (e.g., "App Opened" or "Page Viewed") as Step 1, so the denominator reflects your full user base rather than just those who reached your first event.
âšī¸Â Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
I don't have that event. I added the cohort but it'st still at 100%
Let me check the knowledge base for you again. One moment! đ
Based on the conversation history, you're trying to show the percentage of your total user base that reaches a funnel step, but Step 1 is always 100% by design in Mixpanel.
The issue is that Mixpanel funnels always set the first step to 100% â it's the baseline denominator. Adding a cohort filter doesn't change this; it just limits which users are included in the funnel, but Step 1 will still represent 100% of those filtered users.
Unfortunately, the knowledge sources don't describe a native way to display funnel steps as a percentage of a broader population that isn't itself a funnel step.
Here are a couple of workarounds to consider:
Use a universal entry event as Step 1 â If you have any event that all (or most) users trigger (e.g., "App Opened", "Session Started", "Page Viewed"), use that as Step 1. This gives you a meaningful denominator. [Funnels Quickstart]
Use Insights alongside Funnels â In Insights, you can separately calculate the total number of users and the number who completed your event, then manually derive the percentage. The knowledge sources note that Funnels and Insights count differently, so this would be an approximation. [Funnels FAQ]
I'd recommend reaching out to Mixpanel support directly to ask if there's a specific configuration that achieves what you're looking for, as the knowledge sources don't cover a direct solution for this scenario.
âšī¸Â 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! đ