Calculated Metrics Harmonic Mean | Community
Skip to main content
trishac37070932
New Participant
March 28, 2017
New

Calculated Metrics Harmonic Mean

  • March 28, 2017
  • 2 replies
  • 727 views

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
October 5, 2022
No text available
jantzen_b
Employee
October 27, 2020
No text available