Median of revenue | Community
Skip to main content
A
alv123456
Level 5
September 9, 2019
Solved

Median of revenue

  • September 9, 2019
  • 3 replies
  • 3325 views

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.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Andrey_Osadchuk

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

    3 replies

    Andrey_Osadchuk
    Andrey_OsadchukAccepted solution
    Level 10
    September 9, 2019

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

    A
    alv123456Author
    Level 5
    September 9, 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.

    Andrey_Osadchuk
    Andrey_Osadchuk
    Level 10
    September 9, 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.

      Terms & ConditionsAccessibility statement

      Loading footer...