Custom aggregates in the Pivot recipe

Citron · September 2020

Hello

How do I write a custom aggregate formula in the Pivot recipe ?

I need something like :

if ( count_of_records > 0 ) { return True } else { return False };

Thanks to the Dataiku team and community !

Liev · September 2020

What you describe should be included as an additional step after the Pivot recipe has been executed.

In this scenario your pivot recipe should do a count and a new Prepare recipe can use the count column to generate the True/False output.

Good luck!

Citron · September 2020

Thanks. That's what I did but I wanted it more concise.

Citron · September 2020

By the way, where can I find examples of "custom aggregates" definitions, please ?

Answers