Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #191: BINGO!

sknman92
8 - Asteroid

 

Spoiler

Screenshot 2024-04-30 223926.png

batched an iterative macro for the intermediate solution

 

 

 

Bren_Spill
12 - Quasar
12 - Quasar
Spoiler
#191 WF.JPG

#191 Iterative Macro.JPG
tammybrown_tds
9 - Comet

b-i-n-g-o!

 

 

Bobbyt23
12 - Quasar

Just went for the Basic and Intermediate parts. Couldn't face the reporting tools on this one.

Carolyn
12 - Quasar
12 - Quasar

Solved!

 

Users can input the number of cards and the Iterative Macro will output that many cards. 

 

I set the "BINGO" headers to be the same size as the squares. There's also a 5th row of items, but it didn't make it into the screenshot :) Hardest part was the Reporting Tools

 

2024-11-13_15-13-09.png

 

 

Spoiler
2024-11-13_15-13-39.png

I went with a Random # formula + Sort, vs using the Random Sample % Tool - I tend to forget it's there until I've already started with the Formula method. 

2024-11-13_15-19-02.png

 

 

Carolyn
12 - Quasar
12 - Quasar

@Bren_Spill - ONLY 1 REPORTING TOOL?!?!? No, go back, do it again! 😝 I stuck myself with 14 and it took longer than the Iterative Macro