Core Designer Cert Aggregate step

Andromeda

Hello,

I am completing the core designer certificate project, and I am stuck on the Aggregate step. I've researched, and tried different recipes, but I cannot get the years to show in a way that prepares me to do the Rank step.

I know I am overlooking something, but I need some guidance on what that might be. I am self-taught, this is my first exposure to DataIku, so I have no prior knowledge to fall back on.

Thank you!

Aggregate recipe.png

Uploaded Aug 2, 2024116.95 KB

Aggregate output.png

Uploaded Aug 2, 2024125.22 KB

DataIku version.png

Operating system used: Office 10

LucOBrien

It's been a while since I took that cert, but I'm assuming that you are trying to aggregate by entity, code and year? Have you tried adding year as a group key?
This would let you get Somalia's urban % in the year XXXX, for example.

If I'm off base on what you are after, can you reply with additional info?