Median Calculation on Multiple Dimensions

chofacker
Contributor

Median Calculation on Multiple Dimensions

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. 

8 REPLIES 8
JaredDolich
Moderator

@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

 


Jared Dolich
chofacker
Contributor

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. 

 

JaredDolich
Moderator

@XavierJ 

Any idea when the descriptive statistics in the AppHub will be available? Or, if it's possible for @chofacker to get a copy to their workspace?


Jared Dolich
rob_marshall
Moderator

@JaredDolich 

 

Xavier left Anaplan about a year+ ago, so I am betting he isn't going to reply to you 🙂

 

 

JaredDolich
Moderator

@rob_marshall 

Do we know why only 2 or 3 Apps are available in AppHub, or who we can reach out to get an ETA on the descriptive statistics?


Jared Dolich
chofacker
Contributor

Appreciate the support here guys!
rob_marshall
Moderator

@JaredDolich 

 

Yea, working that right now.  @TrentB ?

TrentB
Contributor

Thanks for alerting. This should be available now LINK