Challenge #55: 2013 Alteryx Grand Prix (L1)

[KeithTroutt]

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

Spoiler

[RichoBsJ]

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

[rfergus]

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

[JonathanAllenby]

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

[cplewis90]

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

[hanykowska]

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

[TonyA]

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.

[T_Willins]

My solution

Spoiler

 

[Thableaus]

Challenge #55, done.

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

WF attached, though.

Cheers,