Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I have a data table, and I know the final format it needs to be in. I'm struggling with how to get there ... Was hoping someone can help me, ideally with a visual recipe.
Here is the format of the table now:
Ranking 2000 2004 2008
1 USA Japan Ireland
2 Ireland USA USA
3 Japan Ireland France
Here is the format I want it to be in:
Country Average Rank
USA 1.66
France 3
Ireland 2
Japan 2
Hi @kinho
You can do it with: Prepare recipe + Group by.
First go to Prep recipe and "Fold multiple columns" (2000, 2004, 2008) then use "group by" with column being column with country prefix and set field aggregation for Rank to "Avg"
Thanks
Mateusz
Hi @kinho
You can do it with: Prepare recipe + Group by.
First go to Prep recipe and "Fold multiple columns" (2000, 2004, 2008) then use "group by" with column being column with country prefix and set field aggregation for Rank to "Avg"
Thanks
Mateusz
Thanks for the solution @emate!
Amazing! Thank you!