Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Weekly Challenge #169 BF: Women's World Cup Wins - My Workflow Solution
Spoiler
Idea Flow:
1. Isolate on Team Names and Scores.
2. Add Conditional column Winner Team, If (Team 1 Score > Team 2 Score) Then Team 1 Elseif (Team 1 Score = Team 2 Score) Then Tie Else Team 2.
3. Group by and Count Winner Team alias as Win Count.
4. Filter out Tie condition since it is not a team.
5. Sort by Win Count descending and filter for 1st row.
1. Isolate on Team Names and Scores.
2. Add Conditional column Winner Team, If (Team 1 Score > Team 2 Score) Then Team 1 Elseif (Team 1 Score = Team 2 Score) Then Tie Else Team 2.
3. Group by and Count Winner Team alias as Win Count.
4. Filter out Tie condition since it is not a team.
5. Sort by Win Count descending and filter for 1st row.
