Median of revenue

Avatar

Avatar

alv123456

Avatar

alv123456

alv123456

09-09-2019

Hi, is there a way to extract all transactions revenue amount values? In order to calculate a median? Currently I can only see the aggregated revenue amount per product.

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar

Andrey_Osadchuk

MVP

Avatar

Andrey_Osadchuk

MVP

Andrey_Osadchuk
MVP

09-09-2019

Yes, it is dimension dependent. However, if you store Order ID in a variable (dimension), you can build a table with it and such a calc metric to get the median for the reporting period.

Avatar

Avatar

alv123456

Avatar

alv123456

alv123456

09-09-2019

Yes I did, but when I do it like this, it gives me the median per row item (calendar or dimension item), but I do not have each transactions as a row item.

Avatar

Avatar

Andrey_Osadchuk

MVP

Avatar

Andrey_Osadchuk

MVP

Andrey_Osadchuk
MVP

09-09-2019

Have you tried to create a calculated metric with the median function?