Challenge #170: 2019 Grand Prix US - Heat 1

[aazimh]

The wording for Step 2 was a bit confusing (or I just didn't read it closely enough) but this was a lot of fun!

[helpfultoaster]

703 on 2019.4

[Thableaus]

Great challenge. I took some time to find the TS Filler tool, so probably I would've failed the Grand Prix (lol).

Spoiler

Struggled to find an easy way to insert the missing values. So I found the TS Filler tool which made everything easy.
Other than that, the challenge was pretty straight forward.

Cheers,

[DataHabanero]

Done!

[Joe_McCoy]

Spoiler

After several minutes of trying things following the summation, I opened the turbo boost only to /headslap myself recalling the dozens of workflows I have where I use the crosstab tool to remove null values from my work. But it's done and I now have a mental note to never forget the crosstab/transpose tools ever again.

[cwkoops]

I think I made it through the prelims 

[KilianL]

Going fast with Alteryx.

Spoiler

[Elias_Nordlinder]

My solution:

Spoiler

Used wrong forecast method first, so took a bit to troubleshoot why my answer was a little bit off 😛

[JasonHu]

Spoiler

Here is my submission.

[jonathanwillis]

I know I'm late to the party here... and my workflow is probably the least efficient, but here you go!