Calculate median & quartile values for each group

Question

Hi all,

Alteryx beginner here so apologies if this is something very simple but would appreciate any help.

Essentially I am trying to find the median and quartile values for each activity and return it to a new column, e.g. in the example below I would expect all staff completing activity 1 to have a value of 2.288 in the median column.

Example file attached.

Thanks in advance!

Sample data - Alteryx Median.xlsx

danilang · Accepted Answer

hi @imazhary

Like @cmcclellan mentioned the median values differ when you look at the entire data set.  Part of this is because of the extra data in your full data set. The other reason is because you have an even number of values in all of your activities.  When this happens, there is no single median value so the 2 middle ones are averaged.

Here's a workflow that gives you the median and the quartiles (25th and 75th percentile) joined back to the original input.

Dan