Skip to main content
Solved

Multiple measurements on the same chart

  • September 4, 2023
  • 4 replies
  • 431 views

Forum|alt.badge.img

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

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”.
View original
Did this topic help you find an answer to your question?

4 replies

Saish Redkar
Expert
Forum|alt.badge.img+10

Hi @Eyal Bukchin 

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.


Forum|alt.badge.img
  • Author
  • Novice
  • 3 replies
  • September 4, 2023

Thanks, appreciate the reply. But as far as I can tell, custom formulas don’t support median, right?


Saish Redkar
Expert
Forum|alt.badge.img+10
  • Expert
  • 1371 replies
  • Answer
  • September 5, 2023

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”.

Forum|alt.badge.img
  • Author
  • Novice
  • 3 replies
  • September 6, 2023

Ah, haven’t noticed PERCENTILE. Thanks!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings