Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #76: Strava Export Parse and Report

Highlighted
Asteroid

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
2019-09-08 18_21_43-Greenshot.png
Highlighted

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

Highlighted
Alteryx
Alteryx

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

 

76_challenge_report.jpg

 

Spoiler
76_challenge.jpg
Highlighted
Comet

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
WC76 Strava Reporting TN.png
Highlighted
Asteroid

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

Highlighted
Alteryx Partner

Challenge 76 is done!

 

Spoiler
challenge 76 JMS solution.PNG
Highlighted
Quasar

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
Workflow 76.JPG

 

Results:

Spoiler
Image #1.JPG

 

Image #2.JPG

 

Asteroid

PFA my solution

Highlighted
Alteryx Partner

My solution

 

Spoiler
challenge_76_RODO_Solution_Report.pngchallenge_76_RODO_Solution.png
Highlighted
Meteor

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
alex_simpson_challenge_76_solution_route_map.pngalex_simpson_challenge_76_solution_speed+elevation.png