I have a number of mutually-exclusive user segments and I’m trying to compare how often they take a particular action, but the user segments are all very different sizes, so I want to normalize the chart by the size of the segment so I can make per-capita comparisons. I thought custom formulas might let me use the size of the user segment but I can’t seem to figure out how to do that. Is there a workaround for this?
Best answer by Saish Redkar
View original
+10
Hey
Based on what I understand, the custom formula in this chart might help you in getting started.
Depending on how you want the size of the segment to be represented, you can use UNIQUES vs TOTALS and adjust the normalizing parameters as per the math.
Let me know if I have interpreted your use case correctly. Hope this helps!
Thank you so much for replying! If I understand this correctly, the 10, 15, 20 values are manually-applied weights. I would prefer a solution that doesn’t require me to manually set these weights, but this is much better than nothing!
+10
Yup.Those are manual inputs. I don’t think custom formulas currently support dynamic inputs, except for some formulas which can leverage some event property values.
You can refer to Sydney’s reply on this post here for some added context on dynamic values in custom formulas.
If you think this is something valuable for your team, you can submit this as a feature request over here. :)
+9
Hello
As
You can get the size of the segment using a uniques chart: https://analytics.amplitude.com/demo/chart/new/rm7l1b5. For example, we can see that in the last 30 days there have been 29,129 unique users in Singapore at the time of writing. However, you will need to manually be checking the size as time progresses.
Thanks for the help both of you, this got me on my way! :)
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.
