Challenge #191: BINGO!

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!

Source: GIPHY

challenge_191_start_file.yxmd

challenge_191_solution.yxzp

Reporting

Join

Preparation

Advanced

Intermediate

Data Preparation

Transform

Interface

Basic

Difficult

Accepted answers

All comments

Blake

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

Spoiler

App Interface

App Interface

Workflow

Workflow

Macro
Macro

Macro

Results
Results

Results

WeeklyChallenge191Bingo_BH.yxzp

Aaron_Harter

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

Bingo Card Format:

Spoiler

Batch Macro Overview:

Spoiler

challenge_191_solution_AB Data Consulting_Aaron.yxzp

RWvanLeeuwen

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!

Inside an application:

Spoiler

To create an awful BINGO card:

Spoiler

overley never works in my hands... any tips would be greatly appreciated

challenge_191_start_file - RWvL.yxzp

nivi_s

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

Challenge_191_solved_NS.yxzp

TonyA

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

challenge_191_Tony.yxzp

RichoBsJ

Hi! Here my solution 🙂

Macro:

Spoiler

Sample Card:

Spoiler

challenge_191_richobsj.yxzp

patrick_digan

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

Spoiler

challenge_191_start_file.yxzp

RolandSchubert

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

... using an Analytic App

Spoiler

... and a batch macro

Spoiler

challenge_191_solution_rsc.yxzp

ConradW

191.yxmd

hbraunius

My (intermediate) solution attached!

challenge_191_solution_hb.yxzp

OllieClarke

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

Spoiler

Workflow:

Spoiler

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

Workflow

Standard Macro

Batch Macro

challenge_191_OC_solution.yxzp

Claje

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.

challenge_191_claje.yxzp

jmt214

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

challenge_191_start_file_solved.yxmc

Batch Macro v2.yxmc

sprodger

Spoiler

SeanAdams

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)

Spoiler

challenge_191_SeanAdams_Solution.yxzp

pasccout

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

challenge_191_my solution.yxzp

ponraj

Here is my intermediate workflow.

Spoiler

challenge_191_solution.yxzp

PickleRick

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

BINGO weekly challenge.yxzp

ZenonH

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

Guts (Macro)

Spoiler

Splat (bug)

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

Spoiler

Q191_ZHSOL_Bingo_Bundle.yxzp

osukef

First off, this is my very first Alteryx Challenge completion! I've used the tool in varying capacity for about a year, but I'm really interested in progressing and becoming more efficient. That being said, I completed this for Beginner. My screenshot and workflow are attached.

Spoiler

One pitfall I know I fell into was that my technique means that the same item can appear more than once on each card. I'm eager for suggestions, tips on avoiding this! Thanks so much!

challenge_191_bingo card.yxmc

unknown

A completed intermediate version of this challenge! Still not familiar enough with the Reporting tab to tackle the Advanced version.

Got there in the end - snuck a peak at Sean Adams solution to get the final format right for the advanced answer.

Spoiler

Flow

Macro

challenge_191_solution.yxmd

Challenge 191 Macro.yxmc

Kenda

Spoiler

My quick beginner solution so I don't get too far behind on these again!

challenge_191_start_file (1).yxmd

kapratt

Seems I forgot to post this on Wednesday when I finished up. I wasn't quite able to figure out the image text overlay, but the remainder is pretty close. I went a little overboard "guaranteeing" that there weren't any duplicates, but I probably just made it a little harder for myself.

Workflow:

Spoiler

Batch Macro:

Spoiler

Iterative Macro:

Spoiler

challenge_191_kp.yxmd

PeterA

A fun weekly challenge - found I was able to simplify my steps with a few report tool tricks:

Make Columns - such a fun and under utilized function
Passing style tags to vertically center contents in the bingo tiles
Using RegEx tool with the <htmlpassthrough> tag to find replace the free space with a base64 encoded image.

Spoiler

challenge_191_solution.yxzp

MilneJames

Thanks for posting this!

I really had no idea how to approach this one (okay, well, some idea but not enough knowledge to actually do it) - so I set about trying to find an example that I could reverse-engineer so that I could learn how to do this. Your spoiler seemed to fit the bill so I downloaded your solution and it's great 🙂

Niklas

🙂

challenge_191_NE.yxmd

RobertW

Stuck somewhere between beginner and intermediate. Got a basic table output full of random options for 1 card. Just peeked at the solution and I want to take it all the way.