community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #76: Strava Export Parse and Report

Director, Customer Enablement
Director, Customer Enablement

Strava is a popular app that serves a social network for all athletes. In particular, the app is popular with runner and cyclists. However, sometimes we want to see the data differently from what is served to us. Below is a GPX file containing a mountain bike ride I completed a few weeks ago. The challenge is to parse it and create report snippets like these:

elevation.pngA speed and elevation dual-axis chart

map.pngA map of the route

Feel free to try anything else on top of these! I will not be providing a starting workflow since the results are pictured above, and connecting to the .gpx file is part of the challenge!

My solution!

 

Spoiler
Finally found another opportunity to use the Make Columns tool!! Put the outputs into a pretty little report, motivational logo included. Makes me want to go ride a bike. :)

WeeklyChallenge76.JPG
Alteryx Certified Partner

Solution below

Spoiler
solution.PNG

 

 

Alteryx Certified Partner

My Solution

 

Spoiler
76.png
Highlighted
Meteoroid

My solution. Lengthy but gives the output!

Asteroid

Hi @JoeM how did you convert the gpx file to text? I am a avid strava user and wanted to convert all of my gpx files.

 

Thank you

Director, Customer Enablement
Director, Customer Enablement

@pvara - when I downloaded it, it simply saved it with a .txt extension since .gpx is not an accepted Community file type. You can keep it as .gpx for Alteryx and process it as if it was a text file.

 

Alteryx Partner

It's my first attempt to the weeekly challenge. Hope to do it in the right way.

Alteryx Certified Partner

The distance between lat/long observations divided by the time elapsed results in some pretty phenomenal speeds!

 

Or perhaps Joe can really climb Belcher Hill at 60mph?  What's your secret Joe?  Newfangled e-bike? Secret high speed chair lift?

Quasar
Quasar

My first draft is attached (named minimal), and upon looking at the data, I learned that in the Charting tool, the Chart Type of Line does not allow us to set an X-Axis, so what it uses is the record sequence. This means if we want to use Time as the X-Axis, each record should represent the same interval if we want an accurate representation of the data. In the data provided one record only represents one second for about half the records, the visualization in the thread question does not take these factors into account. Without taking them into account, the resulting chart is distorted.

 

Here is an example of the difference between Raw and Densified (note that with the Densified version we can see the moments when there was no movement, speed stays at 0 for a bit of time, and elevation is flat):

raw vs densified.png

 

Attached is my complex route with a way to densify the data with respect to each second of time, and then interpolate the coordinates and elevation. An additional chart with distance as the X-Axis was also created.

 

Side note, instead of using a Multi-Row Formula tool twice, one option is we can use a Join Multiple on record position keeping only records that join from all inputs, with one data stream skipping the first record. I am not sure if it is more efficient than multiple Multi-Row Formula tools.

 

Spoiler
c76 Joe_Mako.png