I’m looking for a formula that I would think would be called PROPMAX.
Where PROPSUM gives you the sum of that property across all users and PROPAVG gives you the average value of the property per event, I want the maximum value of the property recorded on the event.
There must surely be a simple way to do this…?
Best answer by MikkoKarvonen
If the maximum value across all the users is what you are looking for (instead of maximum value per user), then event segmentation query with your event, grouped by the event property you are interested in, and formula PERCENTILE(A, 1) will get you what you are looking for.
+3If the maximum value across all the users is what you are looking for (instead of maximum value per user), then event segmentation query with your event, grouped by the event property you are interested in, and formula PERCENTILE(A, 1) will get you what you are looking for.
This is super helpful, thanks!
We have a product where we’d like to track “high water mark” usage - that is, what was the highest value of xyz for a given user over a given amount of time.
Using this custom formula, as well as a ‘group by User ID,’ we’re now able to look at the max property value per user.
Hey
+8If 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.
