We need to sum two user properties. Is there a way to get this? I’m guessing the best way would be to get SQL access, but short of that, is there any other way?
We’re not looking for event properties, just user properties.
Solved
Is there a way to get user property sums?
Best answer by Saish Redkar
Hey
Depending on how you want to interpret and use the sum, there could be couple of ways I can think of
- If you want the total sum of all the values recorded for the given user properties as a metric in a chart over time, then you can try leveraging the PROPSUM() formula by grouping the property1 on “Any Active Event” and property2 on another “Any Active Event”. This is ideally meant for event properties as per the doc but I was able to replicate this on some user properties.
- If you want to use the sum as a new property in itself, you can try using Derived Properties if you have access to it .These won’t affect your raw data and will be computed on the fly. They are currently in a limited release phase and are only available to select customers.
Let me know if I have interpreted your use case correctly. Hope this helps!
+10Hey
Depending on how you want to interpret and use the sum, there could be couple of ways I can think of
- If you want the total sum of all the values recorded for the given user properties as a metric in a chart over time, then you can try leveraging the PROPSUM() formula by grouping the property1 on “Any Active Event” and property2 on another “Any Active Event”. This is ideally meant for event properties as per the doc but I was able to replicate this on some user properties.
- If you want to use the sum as a new property in itself, you can try using Derived Properties if you have access to it .These won’t affect your raw data and will be computed on the fly. They are currently in a limited release phase and are only available to select customers.
Let me know if I have interpreted your use case correctly. Hope this helps!
Reply
Welcome to the Amplitude Community!
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're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
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.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.