Datasets / Subscription cohorts
Share of monthly recurring revenue by plan
A share of a whole with three parts is one of the few honest uses of a pie; four or more slices and this becomes bars.
How it decided
Subscription cohorts: 1,056 rows, 6 columns. plan and mrr for the most recent activity month only.
1,056 rows in, 4 out across 2 columns. A share of a whole with three parts is one of the few honest uses of a pie; four or more slices and this becomes bars.
pie. Parts of one total, few enough to read as slices. Every slice is labelled, because angle alone is not a readable quantity.
Palette, spacing, axis titles and legend placement applied. 0 issues found.
The transformation
This is the code, not a description of it — the chart above was drawn from what it returns, and the notebook download runs the same lines against the same file.
latest = df["activity_month"].max()
result = df[df["activity_month"] == latest].groupby("plan", as_index=False)["mrr"].sum()What it charted
4 rows out of 1,056, 2 columns. First 4 shown.
| plan | mrr |
|---|---|
| Free | 0.0 |
| Pro | 12397.0 |
| Starter | 6897.0 |
| Team | 15198.0 |