Guessing this should be obvious but I can’t figure it out. I’m trying to plot the event count and the median of an event property on the same chart. Is there a way to do this?
Best answer by Saish Redkar
View original
Userlevel 7
+10
Hi
You can try using custom formulas to chart out 2 different metrics in the same chart for most of the cases.
Here’s a demo chart using 2 custom formulas - https://app.amplitude.com/analytics/demo/chart/new/64a7yily
Hope this helps.
Thanks, appreciate the reply. But as far as I can tell, custom formulas don’t support median, right?
Userlevel 7
+10
Yes, there isn’t a direct custom formula for median in there. You can try using PERCENTILE(A, 0.5) to get close to the median.
Else the only other way would be to display the “Median of Property Value” metric and the total count of event in two separate charts and add them in a dashboard to compare “side by side”.
Ah, haven’t noticed PERCENTILE. Thanks!
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.