Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!

Calculated Metrics Harmonic Mean


Level 1


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.