How can we graph the rate of change? e.g. % net change in daily new user registrations.
There were 0 unique registered users on day 0, 10 new registered users on day 1, 20 new registered users on day 2 (100% increase in new users from previous day), 10 new registered users on day 3 (50% decrease from previous day) etc.
When graphing new registered users, I can see the % change from previous day automatically being calculated and shown when hovering over a data point in the graph.
What I would like to do is graph the % rate of change i.e.
x-axis: date or day number since date e.g. day 0, day 1, day 2 etc
y-axis: % rate of change from previous day in daily new registered users e.g. 100% increase, 50% decrease etc
Ideally, I would like the rate of change to be graphed in a bar chart format similar to this:
Secondly is it possible to stack multiple graphs on top of each other?
y-axis 1: cumulative new registered users, daily - line graph
y-axis 2: associated % change in rate of new registered users, daily (above bar-type graph)
Best answer by mattsmith
Matt again! You’re really pushing the functionality of Mixpanel reporting today, it’s great to see!
Unfortunately once again the functionality you have asked for isn’t available within Mixpanel. Indeed our bar charts in Insights have event names, dates, whatever you select along the Y axis, not the X as you have above in your example. There is also no current functionality to allow a line chart to be overlaid on top of a bar chart, you would need to have the two different charts displayed on a dashboard side by side (one bar and one line).
As for rate of change, what you can do is create a Cohort of users who have registered (either new registrations, or cumulative from your starting date). Once this cohort is create you have the option to either select it within Insights, or simply click the 3 dots next to your Cohort in the cohorts tab and select “Visualize Trend” and you will see the size of your Cohort and how it performs and changes over time in Insights. This will show you the change, and you can hover over each data point and see the % change from the day before.
Let me know if this works, thank a lot,