Calculated Metrics Harmonic Mean | Community
Skip to main content
trishac37070932
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

jantzen_b
Adobe Employee
Adobe Employee
October 27, 2020
No text available
Community Manager
October 5, 2022
No text available