Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Challenge #169: Women's World Cup Wins

wingtc99
6 - Meteoroid

my attempt using conditional statements

wingtc99
6 - Meteoroid

my attempt using conditional statements

Alo_Erick
7 - Meteor
Spoiler
Alo_Erick_0-1632509557838.png

 

Anmol97
8 - Asteroid

Here's my solution.

binhnguyendn1606
6 - Meteoroid

I think the lesson I learned from this challenge is to use Transpose to get the list of teams per match then join back with the list of match to see who the winning team is. Then use summarize to count the highest. The key thing lies in "the team winning most matches", which means we get the list of the teams then count the highest.

mtouiti
Alteryx Alumni (Retired)

@mtouiti #SaudiDataCommunity

yelyzaveta_1
7 - Meteor
Spoiler
yelyzaveta_1_0-1632923909326.png
Spoiler
 

 

akravitz
7 - Meteor
Spoiler
akravitz_0-1633010103408.png

 

Kristenaievoli
5 - Atom

Kristenaievoli_0-1633038275363.png

 

MC31
7 - Meteor

My first challenge completed! I've learnt a lot