ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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 #145: SANTALYTICS 2018 - Part 1

Erin
11 - Bolide
Spoiler
Not sure if too much time has passed or what, but I only come up with 1 winner that meets the filtering requirements. I tried.
JasonHu
8 - Asteroid

Here is my submission.

Spoiler
workflow.png
Tony_Castillo
10 - Fireball

Acquiring the datasets was hardest part. Same results as previous user where only 1 company shows now. 

Spoiler
Tony_Castillo_0-1629925204216.png

 

MatthewBr
Alteryx Alumni (Retired)

INteresting spin.

Original_Yodies
8 - Asteroid

The Denver Health and Hospitals Foundation

Spoiler
Original_Yodies_0-1631213714828.png

 

brandowd
8 - Asteroid

My solution kinda follows the solution the only difference was I tried to cut down the data to 'CO' state in the early part of workflow to help performance (although it only shaved a second of compare to the solution).

 

Spoiler
brandowd_0-1632209847017.png

 

jon_amanrich
8 - Asteroid

Most difficult part of this challenge was to actually retrieve the data from the website and create the tables 😅

Spoiler
jon_amanrich_0-1637415748650.pngjon_amanrich_1-1637415783613.png

 

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1637690583839.png

 

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 145.png

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here is my solution: