Challenge #55: 2013 Alteryx Grand Prix (L1)

[Normster]

Working vertically was a little odd at first but you do get used to it.  My problem was with the macro.  Like others, I couldn't get it to work even after trying the suggested fixes.  The end data is correct matches the solution so I'll just call it complete.

[Tokimatsu]

Solved.

Spoiler

 

[TraceyD]

My solution...

[clmc9601]

My solution

[OnionKnight]

Good!!

[PangHC]

due to my poor language i had confuse by the comment...

for Task 1, i thought is daily sales instead of number of records.

for Task 3, I totally cant image for whatever they want for all new field and how it look like....

suggest to put an example result for each steps. as the instruction may vary but the result no.

[aiahwieder]

YIKES, this was a clunker for sure!

[rcarog]

Solution attached.

[Hub119]

My final data output is a little different than the example solution as I used the department average per store (instead of overall... which I believe is a more accurate way of solving this) when calculating the department averages in the beginning to replace the zero values with.  Also, had to adjust the Pit Stop macro to turn on field mapping to get it to work.  Anyhow, my solution is attached.

[BeginnerMindset]

Fun challenge, but I've not changed my workflow to try to match the provided solution because:

1) General Merchandising got lost/forgotten in one of the Summarize tools.

2) When replacing zeroes it uses the overall department averages rather than store specific ones.

Sorry, I just couldn't bring myself to replicate those slips.