Median for multiple groupings

TomRC

Forums

HI all,
I am new to IDEA and i was hoping someone could assist me. I need to compute the median for multiple grouping. Similar to the summarization tool for the average i also need the median. Hoping someone can help.
Thanks,
RC

Brian Element Wed, 11/03/2021 - 06:29

Hi TomRC,

IDEA doesn't have a median function built into it.  You would need to create an IDEAScript to do it or do it manually.  If you have version 11 of IDEA you could download the Pandas Profiling plugin from the IDEA lab as it will calculate the mean for you on a numeric field.