Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account 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 #376: Unlock Insights from FIFA Women’s World Cup Data!

JereJussila
8 - Asteroid

 

Spoiler
alteryx weekly.png

USA domination

 

tristank
11 - Bolide

GOOOOOOOOOOOOOOAAAAAAAAAAAAAAAAAAALLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL

 

Spoiler
Screenshot 2023-07-24 110257.png

 

rohityaman
8 - Asteroid

Solved!

 

Spoiler
Challenge_376.jpg
sisiralteryx
5 - Atom

Would love to see other solutions that may not have as many filters/formulas as i used. 

Carolyn
9 - Comet

Completed! Perfect timing since the US's Game 2 was last night. 

 

I had a rounding difference for Sweden's goals scored. I calculated 1.78 but the answer key has 1.77. Not sure which one is correct, but close enough. 

 

Spoiler
2023-07-27 14_54_53-Alteryx Designer x64 - challenge_376_start_file.yxmd_.png

mgaronson
11 - Bolide
Spoiler
 
Challenge 376 Workflow pic.png

 Go the solution by calculating stats by home team and away team and summarizing accordingly and unioning together to create final stats. Saw @benjimoser solution (shoot out!) using the Arrange tool. Never used the arrange tool - a little tough to understand until you see the result! A slick way to do the stats. Will use this data for the FIFA World Cup challenge at work!

ZacharyRyanTIL
8 - Asteroid

solved

Laurap1228
11 - Bolide

My solution is attached

Chan_Baek
7 - Meteor

Here is my solution.

Spoiler
Spoilerspoiler.png
MilindG
12 - Quasar

Solution