Challenge #381: Average Monthly Sales with a Twist

[TH]

I found this one disappointing, honestly.

Initially I was excited that I'd be able to use some new and different tools.

Started by trying to write it in Python, but weirdly I couldn't get the Python tool to read the input file.

I tried playing around with multi-field formula and dynamic select, but neither of those really worked for this problem.

In the end I needed just the FORMULA tool to get the right answer.

The SELECT tool that I added just makes the output look pretty.

[Qiu]

Completed.

Spoiler

[Ray_Pospisil]

Alteryx and SQL solution attached

[Marcel_E]

Spoiler

 

[olivier_newman]

took a while 

[gerda]

Spoiler

Here's the solution!

[cgetz23]

Complete!

[Carolyn]

Complete!

Spoiler

 

[martinding]

Spoiler

[Reesetrain2]

My solution,

Spoiler