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

Medians/percentile in calculated metrics for Rows

Avatar

Avatar
Boost 5
Level 3
saraf36599971
Level 3

Likes

45 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
saraf36599971
Level 3

Likes

45 likes

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
saraf36599971
Level 3

01-03-2019

Median and percentile functions are available as built-in functions for calculated metrics within Adobe Analytcs, but they are Table based,

From Adobe Documentation:

Table Functions versus Row Functions

A table function is one where the output is the same for every row of the table. A row function is one where the output is different for every row of the table.

See below example of table using the this functionality with one Median and one 90th Percentile metric.

percentile.png

The base metric that is calculated as median and 90th percentile is a Numeric metric. With Row capability for median and percentile, instead of having the median/percentile for  all line items in total it would be possible to see the median for each individual row. Ie, what was the median/percentile for Feb 4, Feb 11, Feb18.

This functionality would be fantastic and help to calculate medians/percentiles directly in the Adobe interface without having to resort to large data exports and manual calculation. Useful for any Numeric metrics where you need to understand the distribution of the individual metric values (eg technical data such as load times, waiting times, or other numeric metrics such as sales numbers) across different dimension values.

Below question experiences the same issue as me.

Median function in calculated metrics

3 Comments

Avatar

Avatar
Level 1
tillw8406191
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
tillw8406191
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
tillw8406191
Level 1

25-07-2019

This is a really cool idea. The same goes for standard deviation or t-test. As they are table based at the moment, their use is very limited. If they were row based, Analytics would have much more value for us.

Avatar

Avatar
Give Back
Employee
IvanAndrus
Employee

Likes

0 likes

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Give Back
Affirm 1
View profile

Avatar
Give Back
Employee
IvanAndrus
Employee

Likes

0 likes

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Give Back
Affirm 1
View profile
IvanAndrus
Employee

08-11-2019

I understand how row-based percentiles would be useful.  And being able to see the standard deviation could also be useful, but how would you use t-test?  What would you be testing?

Avatar

Avatar
Give Back 1000
Level 10
jantzen_belliston-Adobe
Level 10

Likes

359 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

359 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