The Dataiku Frontrunner Awards have just launched to recognize your achievements! Submit Your Entry

Median on grouping data

Median on grouping data

I suggest Dataiku add a feature to calculate median easily, although it is available inside 'Analyze' for numeric columns.

But if someone wants to find the median of each group after grouping, like we can find min, max & avg, etc.

Adding a median feature after grouping data will definitely help the user by giving them a smooth experience.

2 Comments
AshleyW
Dataiker
Dataiker
Status changed to: In Backlog

 

Hi @PANKAJ ,

Thanks for submitting this idea. You'll be pleased to hear this idea is in our backlog--adding median to the list of available aggregation--and we are determining the next steps for development. We can't provide a timeline at this point, but be sure to check back for updates.

For everyone else, kudos the original post to signal that you're interested in Dataiku developing and releasing this feature!

Take care,

Ashley

tgb417
Neuron
Neuron

@AshleyW & @PANKAJ ,

If we are going to add Median, what about Mode as well?

Second, while we are waiting for this feature. 

Has anyone worked out the syntax to add these calculations to a window recipe as a custom aggregation?  I'm running Postgres as the underlying DBMS.