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

pasccout
8 - Asteroid

Here is my solution... can't get the exact same graph (that I know of with Interactive Chart)... must be a setting I don't understand....

jssandom
8 - Asteroid

Couldn't create a dual-axis chart with the interactive tool but here's my solution anyway!

Inactive User
Not applicable

Almost forgot to to convert from m to feet...

image.png

justynam
8 - Asteroid

Here is my solution.

I also decided to go to Tableau and learn how to draw paths on map chart.

 

kelly_gilbert
13 - Pulsar

This was a good way to learn more about chart and map outputs!

 

Recreated charts:

challenge_76_original charts.PNG

 

 

I also wanted to try to figure out how to do a heatmap based on speed:

challenge_76_chart_heatmap.PNG

 

Spoiler
challenge_76_workflow.png
JoshuaGostick
11 - Bolide

My solution (minus the dual axis because I wasn't able to figure out how to add them in the Insight tool).

Spoiler
challenge_76.PNG

 

OldDogNewTricks
10 - Fireball

The approach that I took was to separate the data into 4 equal blocks of time (quarters) and see how the quarters compare to each other on the map.

 

As part of this challenge I learned a few things about the reporting tools in Alteryx.

 

  1. The new interactive charting tool does not have any options for dual axis (eventhough the tool that it replaced did)
  2. There is no ability to color points in the map tool by a data field
  3. I would have rather used Tableau (sorry guys)

 

I was able to create a dual axis chart by normalizing the data and showing the on the same chart, but that doesn't work very well with the labeling.

 

challenge_76_completed_screen_map.jpgchallenge_76_completed_screen_dualaxis.jpg

Tom_Luthi
8 - Asteroid

I haven't been able to create a dual axis chart for this - I used three separate renders instead.

elliemason
8 - Asteroid

With two ways of displaying the map! 

DavidThorpe
Alteryx Alumni (Retired)

Now time to have a play around with my own Strava data, and perhaps throw it into Tableau!

 

My solution: