Median Calculation on Multiple Dimensions

chofacker · August 2022

Hello - has any one ever successfully been able to calculate the median off of multiple dimensions? I have a list of customer spend data at the customer level and would like to calculate the median by certain attributes of those customers. For example, I have 10 customers all who belong to different countries, and different product verticals. I want to know the median for those customers who match US, and Retail, then also calculate the median for UK and Retail or any other combination. The source module has the customer list and time as the dimensions and the source has displays I would like to show mean, median, sd, and variances.

JaredDolich · August 2022

@chofacker

Great article on this: Calculate median value - Anaplan Community

Anaplan doesn't have a median function but you can calculate it with the existing functions. In this case you'll use RANK. RANK will give us the number of samples. Divide by two and decide how you want to handle a tie. Then using a Boolean line item identify the median sample, aggregate it to a parent value on the two dimensions you have.

Another option is to download the "descriptive statistics" from the AppHub (free download) you can see how they do it there. https://community.anaplan.com/t5/App-Hub/ct-p/APPHUB

chofacker · August 2022

Thanks @JaredDolich - I can try to use the original post but would be nice to be able to download the Descriptive Stats app. It doesn't currently look like its available for download.