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 #93: Pumpkin Production

Jonathan-Sherman
15 - Aurora
15 - Aurora

Number 93 is done!

Spoiler
challenge 93 JMS solution.PNG

 

BrendaS
8 - Asteroid

Another one done!

gradyjofficial
8 - Asteroid

my solution

ponraj
13 - Pulsar

Here is my solution!

 

Spoiler
Pumpkin Production.PNG
Verakso
11 - Bolide

Taking into consideration that this weekly challenge is labeled beginner, then it took me substantially longer time for me to solve, than I had anticipated.

 

Oh well, I only used six joins, I guess that is not even high score.

 

Spoiler

Perhaps I went down the wrong rabbit hole here, and actually, my biggest problem was how to calculate the “Diff from Average” numbers, but in the end, I did manage to match the end result.2019-03-14 14_16_26-Alteryx Designer x64 - challenge_93_solution_verakso.yxmd_.png

 

 

Still Climbing

/Thomas 

TonyA
Alteryx Alumni (Retired)

Looking at some of the other solutions, this definitely could be streamlined a bit.

EW
11 - Bolide

My solution:  

 

Spoiler
093EW.PNG

Business cat is wondering why there are so many joins in my solution.Business cat is wondering why there are so many joins in my solution.

 

JackParry
8 - Asteroid

I'm sure there's a quicker way to do this but here's my solution! 

JonathanAllenby
8 - Asteroid

Here's my solution to challenge 93.

Treyson
13 - Pulsar
13 - Pulsar

I love the fall! 

 

Also, I got to use the number cleansing macro in this one. https://gallery.alteryx.com/#!app/Number-Cleansing-Macro/5b6df1870462d71090803ac9

Treyson Marks
Managing Partner
DCG Analytics