If you want to create this natural frequency identification graph in Mixpanel, I have step-by-step instructions below.
1- If you want to group core actions together, you will need to create a custom event to group those events together. Example: For our product, both copy and download an asset are inter-changeable. If you only have 1 event, you can skip this step.
2- Then create a cohort of users older than 28 days who performed the core event at least once, which you can do using the following query.
3- Then plotting the Frequency report by creating a retention report and select frequency from the top left.
4- That will result in a frequency curve, which isn't a histogram but still pretty much gets the same data. Use breakdowns to slice and dice the data.
5- You can convert this frequency curve to a histogram using any free online tool or Google sheets. I used Google sheets, and spent 15ish minutes converting it. You plot: days used, active users. Calculate active users from the cumulative users exported from Mixpanel. It's better to google if you aren't sure how to do this. Tons of articles on how to convert.
I hope this helps!
Hello! How and where did you use the cohort created on step 2? where does it go on step 4? I didn't understand how the cohort and the retention curve report are connected. Thanks!
Hello, thank you so much for this! It worked!