Group recipe aggregating median

casper
Level 2
Group recipe aggregating median
Hi,

Using the Group recipe I can select most aggregations, but not the median. Is it not possible to calculate the median using Group?
0 Kudos
7 Replies
Paulinesco
Dataiker Alumni
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
0 Kudos
casper
Level 2
Author
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?
0 Kudos
Paulinesco
Dataiker Alumni
We are already considering it for the future versions of Dataiku DSS!
0 Kudos
a_bouffard
Level 2

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
Level 2

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

0 Kudos
a_bouffard
Level 2

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...

0 Kudos
a_bouffard
Level 2