Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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.
