How to compute a median ?

Hi, thank you for the tips! :)

Hey @Matt D thanks for this response.  I’m trying to do something similar but with slightly more dimensionality.  Using your example, let’s say the rev2 metric was structured by country, month, AND customer - what I’d like to do is calculate the median customer revenue amount by country & month.  My assumption is that I’m running into limitations with the “Group” portion of the RANK formula - in your example above it resets the ranking by the month dimension, but with what I’m doing I’d think it would need to reset rankings on month and country. 

Are you aware of any ways to accomplish something like this? 

EDIT: I believe I was able to find what I needed in the article on the RANK function, using a unique dimension property along with the “&” symbol to reset across multiple dimensions.  Thanks again for providing this example 

Thanks, 

Hello, 
We’re happy to share that we now have a new Median aggregator using the REMOVE modifier which should help with these calculations!

Updated doc here: 

I hope this helps with needing to calculate Median on metrics with multiple dimensionality.