topic Re: Challenge #76: Strava Export Parse and Report in Weekly Challenges

Challenge #76: Strava Export Parse and Report

JoeM — Tue, 13 Sep 2022 19:17:41 GMT

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:

A speed and elevation dual-axis chart

A 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!

Re: Challenge #76: Strava Export Parse and Report

NicoleJohnson — Mon, 10 Jul 2017 19:30:03 GMT

My solution!

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. :)

Re: Challenge #76: Strava Export Parse and Report

nick_ceneviva — Tue, 11 Jul 2017 14:00:16 GMT

Solution below

Re: Challenge #76: Strava Export Parse and Report

gnans19 — Wed, 12 Jul 2017 06:03:04 GMT

My Solution

Re: Challenge #76: Strava Export Parse and Report

JSaumya — Wed, 12 Jul 2017 23:58:15 GMT

My solution. Lengthy but gives the output!

Re: Challenge #76: Strava Export Parse and Report

pvara — Thu, 13 Jul 2017 03:39:49 GMT

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

Re: Challenge #76: Strava Export Parse and Report

JoeM — Thu, 13 Jul 2017 20:48:40 GMT

@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.

This is my solution!!!

EmanueleE — Fri, 14 Jul 2017 22:07:45 GMT

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

Re: Challenge #76: Strava Export Parse and Report

Garrett — Fri, 14 Jul 2017 23:03:15 GMT

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?

Re: Challenge #76: Strava Export Parse and Report

Joe_Mako — Mon, 17 Jul 2017 07:34:33 GMT

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):

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.

Re: Challenge #76: Strava Export Parse and Report

Laurap1228 — Thu, 20 Jul 2017 18:55:34 GMT

Got to have some fun with the Reporting Tools on this one!

Re: Challenge #76: Strava Export Parse and Report

estherb47 — Sun, 23 Jul 2017 01:14:52 GMT

My solution. I also filled in the time gaps for consistency, since the tools don't let you plot time on the horizontal axis.

Fun challenge!

Re: Challenge #76: Strava Export Parse and Report

jamielaird — Fri, 08 Sep 2017 16:50:58 GMT

Here's my solution.

Re: Challenge #76: Strava Export Parse and Report

patrick_digan — Mon, 25 Sep 2017 17:26:08 GMT

Re: Challenge #76: Strava Export Parse and Report

LordNeilLord — Sun, 01 Oct 2017 11:41:39 GMT

I forgot how bad the report tools were! Bring on plot.ly integration!

Re: Challenge #76: Strava Export Parse and Report

SeanAdams — Mon, 02 Oct 2017 18:50:41 GMT

So - very similar solution to most of the solutions already provided

@JoeM - thank you for the XML exercise - the more XML and JSON and API work we can pack in, the better.

The bad:
- I didn't spot the date regularity issues that @Joe_Mako and @estherb47 used. Nice Catch!
- Also realise that I'm mixing units - elevation in meters but speed in MPH - @nick_ceneviva

the good:
But I did get a good excuse to play with the visual layout tool, and native XML importing using the input tool.
Also put the report together with some summary info on the top

The output:

Re: Challenge #76: Strava Export Parse and Report

Natasha — Sun, 12 Nov 2017 15:27:17 GMT

As always, the most time was spent on making the charting tool to do what I want, which is frustrating especially after using Tableau on an every day basis.

I am not familiar with GPX files, but the first hit in Google told me that GPX, or GPS Exchange Format, is an XML schema designed as a common GPS data format for software applications.

I input provided txt file as XML file which saved me a lot of parsing. A little bit of metadata from the first rows was lost though it was not essential for this exercise.

Re: Challenge #76: Strava Export Parse and Report

LandonG — Thu, 14 Dec 2017 18:53:51 GMT

Solution attached.

Re: Challenge #76: Strava Export Parse and Report

philipmannering — Sat, 16 Dec 2017 12:53:42 GMT

The reporting tools continue to confound, perplex and bamboozle me. Solution attached.

Re: Challenge #76: Strava Export Parse and Report

ggruccio — Wed, 20 Dec 2017 12:21:18 GMT

Used tableau with a mapbox background to map the route. Created a dashboard with the elevation and map. Zipped file with workflow and tableau file below.