Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #191: BINGO!

Highlighted
Asteroid

My (intermediate) solution attached!

 

Highlighted
Alteryx 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
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
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
Asteroid
Spoiler
sprodger_0-1574845026022.png
Highlighted
Nebula
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
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
Pulsar

Here is my intermediate workflow. 

 

Spoiler
main workflow.PNGmacro.PNG
Highlighted
Meteor

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

Highlighted
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