Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #76: Strava Export Parse and Report

Laurap1228
11 - Bolide

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

 

Spoiler
challenge76.jpg
estherb47
15 - Aurora
15 - Aurora

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!

jamielaird
14 - Magnetar

Here's my solution.

 

Spoiler
challenge-76.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture3.PNGCapture2.PNGCapture.PNG
LordNeilLord
15 - Aurora

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

 

 

 

Spoiler
Weekly Challenge 76.pngWeekly Challenge 76 output.png

 

SeanAdams
17 - Castor
17 - Castor

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.

 

 

Spoiler
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

2017-10-02_23-52-44.png

The output: 

2017-10-03_0-14-40.png




 

Natasha
9 - Comet

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.

 

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

Screen Shot 2017-11-12 at 15.22.40.pngScreen Shot 2017-11-12 at 15.16.58.pngScreen Shot 2017-11-12 at 15.17.27.pngScreen Shot 2017-11-12 at 15.17.36.png






LandonG
8 - Asteroid

Solution attached.

PhilipMannering
16 - Nebula
16 - Nebula

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

 

Spoiler
challenge_76 - Snip.PNG
ggruccio
ACE Emeritus
ACE Emeritus

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.