Calculated Metrics Harmonic Mean | Community
Skip to main content
trishac37070932
New Participant
Mar 28, 2017 3:17 PM UTC
New

Calculated Metrics Harmonic Mean

Hi, Currently in Adobe, we use a few calculated metrics that rely on averages. We use arithmetic mean when calculating Average Order Value(Sum of Revenue divided by Sum of Orders) and Average Selling Price (Sum of Revenue divided by Sum of Units). Unfortunately, when applying these calculated metrics to a smaller population or segmented data set in Adobe Analytics, the mean does not account for outliers. It would be nice if calculated metrics had a harmonic mean function.

2 replies

Community Manager
Oct 5, 2022 7:04 PM UTC
No text available
Translate
jantzen_b
Employee
Oct 27, 2020 11:25 PM UTC
No text available
Translate