Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
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_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

:)