0 Replies Latest reply on Oct 12, 2012 10:14 AM by Joe Miller

    Marathon Data! Help me create a visualization using PACE, HR, TIME, DIST, etc.

    Joe Miller

      Hi everyone,

        I had some troubles calculating time in this instance and was wondering the best way to go about it.  Also, I thought I'd pass out some data downloaded from my GPS watch from the first part of a marathon.  Please feel free to play with it and manipulate in fun ways!  I was playing a bit, but got stuck on "pace".  Tableau defaulted it to date/time hierarchy and would not create just mines/seconds pills.  My first visualization was PACE vs. HR, and the y-axis ranging from 5-10minutes/mile.  If you solve it, let me know!  I think this is another exciting application for Tableau because it bridges athletics and data.  It could give some real insights to training and it's effectiveness.   Plus, its fun to collect your own data!

       

      Bonus:  Does anyone know if I could hack my watch to read every second of GPS data collected to map it?  Would something as specific as precise longitude and latitude not ever register with the WMS server?  Thanks!  Enjoy!

       

      SplitTimeMoving TimeDistance (Miles)Elevation GainElevation LossAvg PaceAvg Moving PaceAvg HRMax HRCalories
      108:34.07:011131468:347:0112914680
      207:57.27:27149107:577:2713115072
      308:23.27:3218208:237:3213314279
      407:29.97:30130167:307:3013714273
      508:05.17:4910238:057:4913514572
      607:59.88:0010398:008:0013715270
      707:34.77:32116337:357:3213914666
      807:35.97:3613207:367:3613814463
      907:58.97:59110137:597:5913814664
      1007:48.27:4817137:487:4813714458
      1107:41.07:4110207:417:4113814456
      1207:27.17:27133367:277:2714315063
      1308:51.17:261331138:517:2614215673
      1407:03.66:50166627:046:5014915868
      1507:34.37:3410497:347:3414415459
      1607:05.27:0510237:057:0515015466
      1707:15.47:16133367:157:1614815661
      1807:16.57:16110137:177:1614915461
      Summary35:42.924:12.018.98175228:147:381371581,258