Group recipe aggregating median

casper

Hi,

Using the Group recipe I can select most aggregations, but not the median. Is it not possible to calculate the median using Group?

Paulinesco

Hello,

The median aggregation is not available visually in the group by recipe. The alternative is to create a custom aggregation in the group by recipe using SQL.

I hope this helps.

Pauline

casper

This is a solution but a very annoying one to script for.

Also would it really be hard to make this an option just like the AVG?

Paulinesco

We are already considering it for the future versions of Dataiku DSS!

a_bouffard

hello @Paulinesco
, has this feature been added yet?
I need it, and have done a "median" search in the documentation, but didn't find much

a_bouffard

Actually, seems using Univariate analysis in the interactive statistics does the trick: https://doc.dataiku.com/dss/latest/statistics/index.html

a_bouffard

Yep, that works, but isn't perfect: I need to calculate some 40 medians... and really need that to be "automated"... building 40 Univariate analysis will be tedious...

a_bouffard

Might try the Window recipe trick indicated here https://community.dataiku.com/t5/Using-Dataiku-DSS/Calculating-Median/m-p/7529/highlight/true#M4069