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!

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here

 

This week's challenge was submitted by @kelly_gilbert - thank you for your contribution! 

 

Challengers, get ready to have some fun with this one!  And, with various levels of difficulty built into this challenge, there's something for everyone!

 

Your challenge this week is to build a Bingo Card! This challenge uses events/observations from a baseball game, but you can customize this input for anything from traditional numbers to things you might see at Thanksgiving Dinner.  Enjoy! 

 

bird_bingo.gif

Source: GIPHY

 

Blake
12 - Quasar

I completed this as 'beginnermediate'. I completed all the intermediate steps outside of the reporting tools. BINGO!

 

Spoiler
App Interface 

App InterfaceApp Interface


Workflow
WorkflowWorkflow

Macro
MacroMacro

Results
ResultsResults

 

Aaron_Harter
11 - Bolide

Analytic App & Batch Macro combination allows the user to create a desired number of Bingo cards and customize the title.  I'm looking forward to seeing how everybody configures their reporting tools for the Advanced solution: 

Spoiler
wc 191 screenshot.PNG

Bingo Card Format:

Spoiler
wc 191 bingo card.PNG

 

Batch Macro Overview:

Spoiler
wc 191 macro interior.PNG

 

RWvanLeeuwen
11 - Bolide

The reporting bit puzzles me every single time. I wish to be in the flow with reporting tools but I find them extremely unintuitive. Where can I learn working with them?

 

Anyways I went with an iterative macro:

Spoiler
could a batch macro have made this easier? why yes!could a batch macro have made this easier? why yes!

 

Inside an application:

 

Spoiler

 

 

191 application.jpg

 

To create an awful BINGO card:

Spoiler
overley never works in my hands... any tips would be greatly appreciatedoverley never works in my hands... any tips would be greatly appreciated
nivi_s
8 - Asteroid

Challenge #191 solved!

Image credit: Screenshot of Jake Peralta from Brooklyn 99 yelling "Bingpot!"

 

I wasn't able to get the exact output, but still pretty happy with how it turned out!

Spoiler
nivi_s_0-1574712857292.png
nivi_s_1-1574712961042.png
nivi_s_1-1574713382497.png

 

 

TonyA
Alteryx Alumni (Retired)

Finished the intermediate portion. Advanced may have to wait a couple of days.

RichoBsJ
11 - Bolide

Hi! Here my solution 🙂

 

Macro:

 

Spoiler
macro.PNG

Sample Card:

 

Spoiler
sample_card.PNG

 

 

 

patrick_digan
17 - Castor
17 - Castor

I got my Bingo card to look like so and called it good enough...

 

Spoiler
challenge 191.png
RolandSchubert
16 - Nebula
16 - Nebula

Another challenge using reporting tools. To be honest, I don't like working with reporting tools. And I avoid it if I can. That's why I like the weekly challenge - because it forces me to use tools I don't like (or that I don't know well). And once again learned a lot...

 

Finally I created a card somehow similar to the sample ...

Spoiler
Output.png

... using an Analytic App

Spoiler
App.png

... and a batch macro

Spoiler
Macro.png
ConradW
8 - Asteroid