Multiple measurements on the same chart

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?

Find more posts tagged with

Event Properties

Accepted answers

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

All comments

Saish Redkar

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.

Eyal Bukchin

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

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

Eyal Bukchin

Ah, haven’t noticed PERCENTILE. Thanks!

Quick Links

Unanswered Questions

Send IP on native events for first party tracking
We implemented first party tracking using the basic JS SDK on the browser and pointing the payload to our servers like this: amplitude.init(AMPLITUDE_API_KEY, { serverUrl: serverUrl, autocapture: { attribution: { excludeReferrers: [/domain1\.com$/, /domain2\.com$/], }, formInteractions: false, fileDownloads: false, }, });…
Events for an Android background app
My Android app is primarily a background app. Does Amplitude track events for such an app? Please let me know.
Modifed the Change over time retantion graph
here is the referance graph: https://app.amplitude.com/analytics/demo/chart/new/363tk5og In this graph, retention is currently being calculated based on the next day, but I want to analyze it based on the previous day instead. Example: For July 27, we should compare retention against July 26, not July 28. * So for 1-day…
Landing page analysis data table
Hi everybody! I need your help with a client request: my client is used to analyze landing pages performance with the standard report from GA4 and I need to create something similar in Amplitude. What I already have: * session entries grouped by page URL * purchase event calculated as session totals grouped by page URL and…
Funnel Chart: Cross-Domain Tracking
Good day! I am new to Amplitude and still learning. Our organization’s current objective is to track specific webpages that have high exits/drop-offs so we think that the Funnel Chart is the best tool to use for it. However, you see our website uses 2 different domains in completing the buying journey of visitors (from…