Hi @roginator 

You can use the Property Sum metric or PROPSUM formula on your numerical property.

Here’s a demo chart - https://app.amplitude.com/analytics/demo/chart/new/4huo3t6i

Hope this helps.

Thanks Saish but that seems to be counting the total more than once. Probably due to the fact that it’s utilising events from multiple users over multiple days. I’m now in touch with customer support to try and figure things out.

@roginator 

PROPSUM will aggregate the value across all users during that time period. It might be tricky to make PROPSUM on unique account ids afaik. I’ll see if I can find some other way on this.
Keep me posted here on what support says.

They helped me create a chart using PROPMAX with this criteria:

But that just displays a distribution across Accounts as opposed to a sum. I’m waiting for them to get back to me with how I can create a sum.

Here’s the final response from support. Pretty disappointing:

@roginator if you want the full sum, can you just delete the final group by and use propsum(a)? 

You can also filter for the desired groups in separate events and use propsum(A)+propsum(B)+propsum(C). 

@roginator if you want the full sum, can you just delete the final group by and use propsum(a)? 

 

You can also filter for the desired groups in separate events and use propsum(A)+propsum(B)+propsum(C). 

@Anthony thanks but isn’t that going to sum up the number of todos from every time an event is triggered? Eg, if 2 people from Account A trigger events, the sum is going to be 200 todos even though Account A only has 100 todos (100 todos x 2 people triggering the event). What I need is the number of todos summed up at the Account level. And I can’t see a mechanism for achieving that in your exampel. Please let me know if I’m missing something.

Hello Everyone,
 
Jacenda from Support here. I hope you're having a great day!
 
@Anthony Yes, you're correct. If you'd like to calculate the total sum of a property across different events, you can use the PROPSUM function for each event and then simply add them together.
 
However, in @roginator's case, it seems the issue with PROPSUM is that it aggregates property counts from multiple users' events, leading to an inflated property sum result. Therefore, PROPMAX, which returns the maximum value of the property you are grouping by, is currently the best alternative for @roginator's use case.
 
To sum the PROPMAX values, we can follow @Anthony's suggestion of filtering for the desired groups in separate events but use the PROPMAX formula instead. Here's an example:

 
Alternatively, you can export the original PROPMAX chart and manually sum the values, as suggested by my colleague Manabu.
 
For more information on using formula functions, you can refer to this help article.
 
I hope this explanation is helpful! Feel free to reach out if you have any further questions.
 
Warm Regards!
 
-Jacenda