Challenge #76: Strava Export Parse and Report

[mbogusz]

Here's my solution based on @kelly_gilbert's solution which had me ogling at the heat map in it and then later applauding at the method used for creating interval starting times from interval ending times in it.

One of the reporting tools used was showing as 'deprecated', so I used the Interactive Chart tool instead.

Spoiler

[kelly_gilbert]

@mbogusz, looking back, I have no idea why I didn't use Multi-Row Formula tools to calc the change in time and distance!

[CaraI]

Since I have some reporting training coming up, thought this would be a good excuse to brush up on some reporting tools!

Spoiler

[TylerNa]

Studying up for the Designer Advanced certification and this looked to be a good challenge. I'm also a big user of Strava and so this challenge was even more fun in that regard.

Spoiler

[hanykowska]

Sadly no dual-axis, but I've tried to find it...

[Jonathan-Sherman]

Challenge 76 is done!

Spoiler

[T_Willins]

This was fun and a good example for Alteryx users in the office.  I've been showing them that Alteryx reporting tools can meet most of their needs and they don't need to export data to render charts and graphs in other software.

Workflow:

Spoiler

Results:

Spoiler

[jagdeep_singh85]

PFA my solution

[RoDO]

My solution

Spoiler

[AlexSimpson]

I'm a big fan of Strava so was great to get stuck into this challenge!

Unfortunately my Alteryx version (2019.1) has no Dual-Axis option for Y-Axis in the Interactive Reporting Tool, so excuse the ridiculous y-axis scale.

Solution attached. 

Spoiler