Skip to main content
Solved

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

  • February 14, 2023
  • 3 replies
  • 878 views

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

Please see sample below

 

Best answer by 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! 😁

View original
Did this topic help you find an answer to your question?

3 replies

Matrak
Peer Moderator
Forum|alt.badge.img+6
  • Peer Moderator
  • 20 replies
  • Answer
  • February 14, 2023

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! 😁


Jeremie Gluckman
Team Member
Forum|alt.badge.img+9

Thanks for jumping in here @Matrak 😃


  • Author
  • New Member
  • 1 reply
  • February 15, 2023

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings