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 Alumni

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