The Weekly Challenge Program is evolving! We’re creating a better, more modern experience designed around how our community learns and practices today, with a refreshed program launching soon. Stay tuned!
Start Free Trial

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_Spill2
12 - Quasar
12 - Quasar
Spoiler
#191 WF.JPG

#191 Iterative Macro.JPG
tammybrown_tds
9 - Comet

b-i-n-g-o!

 

 

Bobbyt23
13 - Pulsar

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

Carolyn
13 - Pulsar
13 - Pulsar

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
13 - Pulsar
13 - Pulsar

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

lwolfie
11 - Bolide

I avoided this one, because I used the solution for an Alteryx Bingo Event that I tailored.  Enough time has passed for me to try on my own from scratch.

jassik
8 - Asteroid

Here is the beginner's solution

sknman92
8 - Asteroid

this was some time ago - but looking back realized my batch macro wasn't handling the dynamic number of cards properly. adjusted and re-posting! 

 

 

RebekaMazuchova
8 - Asteroid

:)