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
BedrockMission!

Learn More

View all

Sign in to view all badges

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
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

331 likes

Total Posts

2,247 posts

Correct Reply

811 solutions
Top badges earned
Springboard
Validate 500
Validate 250
Validate 100
Validate 50
View profile

Avatar
Springboard
Community Manager
jantzen_belliston-Adobe
Community Manager

Likes

331 likes

Total Posts

2,247 posts

Correct Reply

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

27-10-2020

 
Status changed to: Archived