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.
Answers
-
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
0 -
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.
0 -
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?
0 -
Xavier left Anaplan about a year+ ago, so I am betting he isn't going to reply to you 🙂
1 -
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?
0 -
Appreciate the support here guys!0
-
0
