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
8 - Asteroid

My (intermediate) solution attached!

 

Highlighted
Alteryx Certified Partner

I always struggle with reporting tools. So this isn't perfect...

Spoiler
OllieClarke_0-1574792114833.png

Workflow:

Spoiler
I went for a batch macro nested within a standard macro to allow for the choice of number of outputs.

WorkflowWorkflow

Standard MacroStandard Macro

Batch MacroBatch Macro

 

 

Highlighted
14 - Magnetar

This was an interesting one.

 

Spoiler
I managed to build out most of this process - I ended up looking to @RolandSchubert's Table tool for some suggestions on properly formatting the data.  Report formatting and font choice in Alteryx is never really something I enjoy.

I was able to do this without a macro of any kind - because of the power of Generate Rows, you really don't need a macro for this kind of design, and often you don't need macros for a number of looping or batch processes, due to the inherent flexibility of Alteryx.  I attached it as a YXZP because the Community didn't like my YXWZ, but it just contains my app.
Highlighted
8 - Asteroid

Beginner and Intermediate solutions! I'm going to try to finish the Advanced after Thanksgiving. Love the challenge getting me more into the reporting tools!

 

Spoiler
Capture.PNGCapturemac1.PNGCapturemac2.PNG
Highlighted
8 - Asteroid
Spoiler
sprodger_0-1574845026022.png
Highlighted
16 - Nebula
16 - Nebula

Thanks for this one @kelly_gilbert  - good opportunity to work with the reporting tool with a very specific format on the outcome (that was fun, to ensure that folks know where to set different settings).

 

I took a slightly different approach - the UI allows you to specify your own event, and the names of the participants (saves people from having to write their names)

 

Interface.jpgResult.jpg

 

 

 

 

Spoiler

Solution1.jpgSolution2.jpg

 

Highlighted
8 - Asteroid

First 2 ones... got it...

 

Not quite there yet on the advanced reporting... got the bingo card but can't figure out the exact border matching... 

Highlighted
13 - Pulsar

Here is my intermediate workflow. 

 

Spoiler
main workflow.PNGmacro.PNG
Highlighted
7 - Meteor

Completed the beginner and the intermediate logic - didn't quite work out the reporting format!

Highlighted
8 - Asteroid

I had a really fun time with this challenge. After I got to the step where the information needed to be put through the reporting tools, I needed to go through some solutions to understand how to use the reporting tools. This worked out pretty well and I learned more about how layering works with this reporting suite, but I found that my results in the browse tool didn't quite translate to the actual renderings. 
Workflow + Output

Spoiler
ZHSOLWF.png

Guts (Macro)

Spoiler
ZHSOLM.png

Splat (bug)

--If you try to cross tab a layout and select concatenate this error appears (needed to click first to fix)

Spoiler
ZHYouHaveFoundABug.png