Hi Amplitude community!
Your help would be greatly appreciated here! I’m trying to build a chart/dashboard that shows account growth (or decline) over a period of time but not having much luck with building this view. For context, our customers book a total number of licenses as part of their contract and I would live to monitor whether or not customers are increasing their total number of active licenses vs booked licenses over time.
For example, if ACME company purchased 10,000 licenses, then I want to monitor if ACME is using more or less of those licenses month over month. Ideally, I would like to build a dashboard that shows this growth or decline in license utilization across all customers.
Best answer by Saish Redkar
Happy to help with this one! We have a similar use case and I like to use the Event Segmentation chart along with a combination of the Compare to Past and the Formula features for visualizing license utilization.
Assuming you already are using some sort of a segment/cohort for ACME company using the company identifier, you can plug in the following formula in the Formula tab or use the cumulative feature to visualize the usage growth for ACME in the Event Segmentation chart
Here A is the usage event you are tracking for that account.This would give the cumulative sum of the absolute number of users under the given account over the selected time period.
If you want to track the utilization growth in terms of %, you can try using the following formula
Once you are able to do so, try using the Compare to Past feature to get the desired period over period view.
Hope I have interpreted your use case correctly.
Let me know if this helps!