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

Highlighted
Asteroid

Tough in vertical layout. Got it to pass the macro test.  

Spoiler
Challenge 55 Spoiler.PNG
Asteroid

Hi! Here my solution, it runs without errors :):):)

Highlighted
Alteryx Partner

Glad there is an impute tool now, would have been much simpler, but not too bad. Took longer than I would have liked, but had to troubleshoot getting the macro to work a little.  Good practice problem.

 

Spoiler
image.png

 

Highlighted
Alteryx Partner

Here's my solution to challenge 55. It can handle adding or removing departments.

Highlighted
Quasar

Fun challenge. A few misinterpretations as I initially did the averages for departments by store instead of overall for the fill ins, but once I made that adjustment I was good.

Spoiler
Challenge 55 - finish.PNG
Challenge 55.PNG
Highlighted
Asteroid

done! I must say, I'm not a fan of the vertical layout...

Highlighted
Alteryx
Alteryx

Here's my solution. It's not pretty but it works. What I couldn't get working was the macro, but I opened it up and saw what test it was performing and did the test manually to verify that I had the correct result.

 

By the way, I tried using the old icons, but developed a splitting headache in about 3 minutes. I kept the vertical layout for this exercise, but if I was going to use it regularly, I'd be switching my monitor to profile mode.

Highlighted
Quasar

My solution

 

Spoiler
 Workflow 55.GIF

 

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge #55, done.

 

I don't think it's worth posting Spoiler. Not so fun this one.

 

WF attached, though.

 

Cheers,

Highlighted
Asteroid