New to Dataiku DSS? Try out our NEW Quick Start Programs today and get onboarded on the product in just one hour! Let's go

Custom aggregates in the Pivot recipe

Citron
Level 1
Custom aggregates in the Pivot recipe

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 !

0 Kudos
3 Replies
Liev
Dataiker
Dataiker

Hi @Citron 

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!

0 Kudos
Citron
Level 1
Author

Hi @Liev 

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

0 Kudos
Citron
Level 1
Author

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

0 Kudos
A banner prompting to get Dataiku DSS