I am looking to calculate average purchase amount per user and split users by a specific threshold. For instance, users with an average purchase amount either above or below $10. I know you can do an average of purchase amount across purchase events as well as ARPU but both of these use aggregates across events/users.
If that isn’t possible then I would likely have to just group users by whether or not they’ve made purchases above $10.
Hi
You can use “sum of property” clause to define your cohort and group users based on the sum of their purchases.
You can also use Computations ( if you have access to that ) to calculate new aggregated properties on the fly - https://help.amplitude.com/hc/en-us/articles/360060044791-Computations-Create-new-user-properties-on-the-fly#01H82NZ2E72N2TTMAFC7C455JV
Hi
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 E-mail address. We'll send you an e-mail with instructions to reset your password.