Challenge #55: 2013 Alteryx Grand Prix (L1)

[dsmdavid]

[daniel_ferreira]

Follow my solution file attached...

[MsBindy]

Solution

[StevenBetts]

I got in a bit of a tangle  calculating the averages but I got there in the end! :)

Saqueador

[danilang]

Solution

for @NicoleJohnson 

I do not like you

up and down.

I do not like. This

flow's a clown.

Saqueador

Dan (No relation to Dr. Dan of the challenge)

[JDelgado]

Grrr... rounded my percentage calculations to two places causing my results to be off by 0.14. Was an exercise in hair pulling before I figured it out (had to reconstruct the macro functionality to find the issue)!!!

[kat]

Love the retro challenges!

Saqueador

Couldn't understand why I wasn't getting the same answer until I realised that I was missing a summarise before averaging for stores...

[OldDogNewTricks]

Here is my nasty, brute force method...

[PrivateStorm]

My solution to challenge #55 is attached.

[OllieClarke]

Went well beyond the allowed timeframe, and not only because of the vertical workflow. I also had to open and then save the macro to get it to work, but I got the right answer eventually :)

Saqueador