Calculated Metrics Harmonic Mean

Avatar

Avatar
Level 1
trishac37070932
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile

Avatar
Level 1
trishac37070932
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
View profile
trishac37070932
Level 1

28-03-2017

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.

1 Comment

Avatar

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,338 posts

Correct reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile

Avatar
Validate 1000
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

339 likes

Total Posts

2,338 posts

Correct reply

819 solutions
Top badges earned
Validate 1000
Springboard
Validate 500
Validate 250
Validate 100
View profile
jantzen_belliston-Adobe
Community Manager

27-10-2020

 
Status changed to: Archived