Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #55: 2013 Alteryx Grand Prix (L1)

GeneR
Alteryx Alumni (Retired)

The link to last week’s challenge (exercise #54) is HERE.

 

2013 Alteryx Grand Prix Lap 1 of 3:

 

As the Alteryx User groups start the process of selecting their competitors for the 2017 Alteryx Grand Prix I thought it would be fun to bring back an old Grand Prix as the weekly challenge.  Note the workflow is in a vertical orientation.  Vertical was the only orientation Alteryx had in 2013.  Now, we can toggle between vertical and horizontal configurations by clicking on the white space of the canvas, going to the configuration window, and choosing a layout direction.

 

Want to have even more fun, go to the about box under the help menu and double click the little Colorado flag for an Easter egg that will render the tools the way they looked in 2013.

 

Have fun solving and remember the competitors were racing each other and the clock!  See how fast you can solve this.  OH, and there was NO Imputation tool in 2013...

mceleavey
17 - Castor
17 - Castor

Okay, I don't think I would win any prizes for speed here, but I think I got there:

 

Spoiler
I started by determining the year with the most daily sales records. This was achieved by simply creating a date field, grouping by year and counting the individual date rows. I then sorted by the highest and took the first row, then linked this back to the main data stream:

Task 1 - Determine Year.PNG

From here, I then carried out task two by transposing the data to include the values for each department in one column. I then determined the average without zeros by using the appropriate function in the "Summarize" tool and used a formula to replace zero values with this value. I then cross-tabbed the data back to the original format:

Task 2 - Determine Averages without Zeros.PNG

Tasks 3 and 4 were then simple matters of grouping and applying the appropriate sums coupled with a formula to determine the 364 calculation and daily sales % by department. Simple:

Task 3 - Determine Average values and totals.PNG

Task 4 - Determine Percentages.PNG





Bulien

JoeM
Alteryx Alumni (Retired)

The original post has been updated with the solution!

SeanAdams
17 - Castor
17 - Castor

:-) it really baked my pumpkin trying to think in a downwards flow, instead of a left-to-right.   What creatures of habit we are...

 

NicoleJohnson
ACE Emeritus
ACE Emeritus

Solution. I do not like you, up and down. I do not like you, Sam I am.

Spoiler
WeeklyChallenge55.JPG
estherb47
15 - Aurora
15 - Aurora

Nothing earth shattering here, and I did change it to horizontal :)

Natasha
9 - Comet

I successfully completed Pit Stop 1, though it took me ages to do this in a vertical workflow, and OMG that funky icons!! And of course, the suggested solution is much more simpler than mine.

 

Spoiler
Screen Shot 2017-06-01 at 11.12.29.png

 

 

LordNeilLord
15 - Aurora

I have tried and failed several times to get this solution to work, although confident that my calculations were correct it would not validate in the macro.

 

Spoiler

 

So I bit the bullet and checked against the solution and found the solution had excluded General Merchandise (not in the instructions) and the format required was short and wide (i was using tall and thin)...so I made all the changes but still no luck. So i resorted to checking the values against the solution and they are all correct....I have no idea why it wont run but hey.....I'm happy with the solution I have provided

@SeanAdams - that's 74! I'm ready for Monday :)

SeanAdams
17 - Castor
17 - Castor

@LordNeilLord - you gotta be proud of yourself - you've torn through these with such passion and speed!    

patrick_digan
17 - Castor
17 - Castor
Spoiler
Perhaps it's just me, but i found that to be confusing!
Capture.PNG