I'm trying to create a metric which shows the median purchase value. The range of sums can be quite large, so the mean can be skewed by large orders reducing its usefulness.
I have tried using the median function but it isn't behaving as I would expect. What I would ideally like to do is have a median value metric and be able to apply this to a number of different dimensions. So for example have a table of products (A,B,C) and the value to be the median value spent on each. Then break this down by client and see the median value each client placed into products A B or C.
At the moment the median metric I have created seems to be working for time ranges - so it'll give me the correct figure for a particular day, but is not working when other dimensions are introduced (the same median value is given to all the elements in the dimension). I have even tried putting segments within the calculated metric, but this then (bizarrely) it just returns the total sum of the values!
I'm guessing my issues are because Adobe is looking at it on a column basis, but I'm hoping someone has a neat work around or suggestion.