We’re a SaaS company and we have a Group Property (Account) for number of todos added by all the users within the Group (Account), eg:
How can I create a chart displaying the total number of todos for all accounts, eg 210? IE a sum of the values.
Cheers, Andrew
Best answer by Saish Redkar
View original
+10
Hi
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.
+10
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:
| Manabu Takeya (Amplitude) Mar 26, 2024, 11:27 AM GMT+1 Hi Andrew, |
+2
You can also filter for the desired groups in separate events and use propsum(A)+propsum(B)+propsum(C).
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
