how do create a graph of total signups (cumulative) and signups per day?

karla.e

i want to create a graph of total signups (cumulative) and signups per day

Please see sample below

Find more posts tagged with

Accepted answers

Matrak

Hello Karla,

You can use the “formula” option in the segmentation chart and use a regular formula (such as “Totals” assigned to your signup event) with a second “CUMSUM” formula (assigned to “Totals(signup event)”) which will compute the cumulative sum of your total signups.

Here is an exemple I made with Amplitude demo: https://analytics.amplitude.com/demo/chart/new/ilmz8vx?source=copy+url

The only issue is that you can only use the “line chart” option to get a similar result to your graph, and both your daily/weekly/monthly/quarterly signups and cumulative signups will share the same axis scales.

Hope this helps! 😁

All comments

Matrak

Jeremie Gluckman

Thanks for jumping in here Matrak 😃

karla.e

Thank you so much Matrak. This helps me a lot 🙌

Quick Links

Unanswered Questions

playing videos 9:16 (vertical) in an iOS guide?
Hi all, We are getting set up on Amplitude and want to be able to have demo videos automatically show up in a guide in a 9:16 ratio (vertical/portrait) and not in the crunched landscape orientation that the current frame delivers for Vimeo and YouTube. We are using the iOS SDK, which seems like it may be the limiting…
Trying to import new user attribute from CSV but it doesn't work
I have a csv with 2 columns user_id and lead_source. I went to Catalog and selected CSV under Lookup Tables. Step 1: I brought in the CSV and Step 2: I mapped the first column (user_id) to User ID (Amplitude User). It showed me a sample of my CSV and showed both columns at the bottom of Step 2. I clickd Finish. I went to…
How to filter by Event properties in Segmentation chart
I am unable to find my Event Properties in the list of “+ Filters” in Segmentation chart.
notifications.integration.saveFailure - Unable to add Facebook Cohort as a Destination
Myself and other team members have tried using the Facebook Cohorts integration however we always receive the same error ‘notifications.integration.saveFailure When looking in Meta Business Manager it says that the integration is active however when going into the Destinations tab in Amplitude, it is blank I have tried the…
User ID is converting to a big number
I am setting user property wallet address, and using the same variable to set user ID. However, while walletAddress works (0xA66...54), User ID seemingly converts the hex to a big number (1.2905460614871781E+48) which is preventing us from using filtering and views. Any ideas?