Medians/percentile in calculated metrics for Rows

Avatar

Avatar
Boost 5
Level 3
saraf36599971
Level 3

Likes

44 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

44 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
Affirm 1
Employee
IvanAndrus
Employee

Likes

0 likes

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
Affirm 1
View profile

Avatar
Affirm 1
Employee
IvanAndrus
Employee

Likes

0 likes

Total Posts

3 posts

Correct reply

1 solution
Top badges earned
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
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