Challenge #55: 2013 Alteryx Grand Prix (L1)

[tristank]

It wasn't made clear but I realize now I should've created separate outputs lol. I threw them all together but still got all the data points requested. This will be my last vertical challenge in history what pain.

Spoiler

[gawa]

done

[MitchellBliesner]

I accidently did this challenge again. Realized I did it differently so I thought I would post my new solution.

[mattnason1]

Tough one but pretty fun.  Seems like a perfect macro opportunity.

[caltang]

The last bit just messed me up, not sure what's up with the Macro!

Spoiler

[mithily]

Spoiler

instructions kinda confusing

[lwolfie]

I agree with others that some of the instructions were confusing.  I did not interpret the way they were written.

[Tgigs]

My solution attached.

Finished in 14 min and 12 seconds, including reading the question and did not use the imputation tool (did it the old fashion way with the average non zero option in summarize tool)

[Carolyn]

Solved as well as I can get it. I pulled the answer from the Solution file but it doesn't match with what I got. Even after I redid the workflow to match how the Solution solved it, I got the same answer as I had previously. I think there's an error in the solution because it doesn't include the General Merchandise information. 

Not a fan of the vertical orientation - between that and the old style tools, it hurt my brain :D 

Spoiler

 

[olga_strubbe]

A neat challenge, thank you, @GeneR.  My solution attached.