Challenge #55: 2013 Alteryx Grand Prix (L1)

[DanTh]

Completely missed that we couldn't use the Imputation block!

Spoiler

Definitely took me a long time, including two attempts as I went down a route of Transposing the data right from the start, which blew up my data set. BUT, I got there at least...

2/5

[Erin]

Not sure I love vertical layouts. Guess I'm not vintage 😄

[LiuZhang]

Spoiler

With all the total, average, daily, it is rather confusing to get the results. Caught out in the first task of find sales records, thought it was asking how many daily sales records broken (most in 2009, expected as it is a running max), rather than just number of rows per year.

To match the final output, need to check the format required in macro, otherwise the calculation itself is fine.

[Anmol97]

Here's my solution

[davidhardister]

Requires the user to enable Field Mapping in the macro and configure it in the workflow.

[Watermark]

Spoiler

 

[rockyw9]

See solution attached. "Average - Ignore 0's" was a major take away for me on this one. Also, I noticed the "General Merchandise" was not included as part of the sales by department calculation. 

[SylwiaDragon]

done

[scoles0617]

My solution:

[FrederikE]

Spoiler