Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Calculated Metrics Harmonic Mean

Avatar

Avatar
Give Back
Level 1
trishac37070932
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Give Back
View profile

Avatar
Give Back
Level 1
trishac37070932
Level 1

Likes

0 likes

Total Posts

2 posts

Correct reply

0 solutions
Top badges earned
Give Back
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
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

358 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

358 likes

Total Posts

2,372 posts

Correct reply

823 solutions
Top badges earned
Give Back 1000
Give back 900
Give Back 800
Give Back 700
Give back 600
View profile
jantzen_belliston-Adobe
Level 10

27-10-2020

 
Status changed to: Archived