Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #191: BINGO!

Highlighted
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

 

Highlighted
Alteryx Certified Partner

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

 

Highlighted
Alteryx Certified Partner

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

 

Highlighted
Alteryx Certified Partner

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
Highlighted
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

 

 

Highlighted
Alteryx
Alteryx

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

Highlighted
8 - Asteroid

Hi! Here my solution 🙂

 

Macro:

 

Spoiler
macro.PNG

Sample Card:

 

Spoiler
sample_card.PNG

 

 

 

Highlighted
16 - Nebula
16 - Nebula

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

 

Spoiler
challenge 191.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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
Highlighted
Alteryx Partner