Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

average speed for moving time

6953972
over 2 years ago

Hi,

I look at cycling activities and see my average moving speed and that's great, but I would like to see average speed plotted against ELAPSED time, not against total time or time of day. I had a 5 hour MOVING TIME ride the other day, but with lunch and breaks it was 6 total hours. I tried downloading the data and doing it in an analytic tool called tableau but always running into the same issue of not having elapsed time to be able to do the calc of distance / elapsed time.  Goal is to be able to see how the average increases or decreases over the course of the ride.

Thanks

Tony

  • 0 over 2 years ago
    6953972 said:
    always running into the same issue of not having elapsed time

    I am not sure I understand what you are looking for, since GC Web does show the elapsed time in the activity stats:

    • Time = it is the total time of the activity excluding the pauses (both manual ones,and those trigerred by the auto-pause option, when used)
    • Moving Time = it is the total value only including the time when you really move
    • Elapsed Time = the time from the start to the end (nothing excluded)
  • +1 over 2 years ago

    Sounds like you want to see your (cumulative) average speed over time, which isn't possible in Garmin Connect.

    There's a couple of sites which can kind of do what you want: they graph your cumulative average pace/speed over activity *distance*. One thing is that pace/speed is still calculated with respect to activity time (unpaused time), not moving time or elapsed time. TBH, I'm not sure why you'd want average speed to be calculated with respect to elapsed time, especially if 1 out of 6 activity hours is a break. Wouldn't that mess up your data? If you really want that, I think you could accomplish that by not pausing your activity.

    Anyway, the sites are:

    - https://www.runalyze.com: it's free and syncs with your Garmin Connect account. Primarily for runners

    - https://veloviewer.com: not free and syncs with your Strava account. Primarily for cyclists. The free trial allows you to sync a small number of activities to try it out

    Here's an example in runalyze where I changed a running activity to cycling, to illustrate the cumulative average speed feature. (I don't bike)

  • 0 over 2 years ago in reply to trux

    Looking for the average moving speed, with stops taken out.

  • 0 over 2 years ago in reply to WillNorthYork

    Thanks for the tips. Runalyzer did a great job of importing the file and displaying exactly the chart I wanted. I wanted to see where my performance started to drop off. Appreciate the help.

    Tony

  • 0 over 2 years ago in reply to 6953972
    6953972 said:
    Looking for the average moving speed, with stops taken out.

    It is in the stats too. At least with my watch (Instinct 2) - perhaps it differs with other models.

  • 0 over 2 years ago in reply to trux

    Thanks. I have a Garmin Edge Explore bike computer. I see the overall average but just wanted to see the graph over "moving time" like in the response I now posted above. It would be a super easy thing for Garmin to add to the web interface. Hope they do, so I can use just one tool.

    Thanks!

    Tony

  • 0 over 2 years ago in reply to 6953972
    6953972 said:
    I see the overall average but just wanted to see the graph over "moving time" like in the response I now posted above.

    It is already there - when you select the Time based graphs, the pace graph includes the non-moving parts too. And wen you select Distance instead, it shows the pace over the moving time only (not the moving average though):

  • 0 over 2 years ago in reply to trux

    As explained previously, OP wants to see a graph of *cumulative moving average speed* vs activity time/distance, which Garmin doesn't provide.

    In other words, he wants the graph that answers the following question: at any given point in the activity, what was my *cumulative average speed*?

    Garmin provides the graph of *instant* speed vs activity time/distance.

  • 0 over 2 years ago in reply to WillNorthYork
    WillNorthYork said:
    As explained previously, OP wants to see a graph of *cumulative moving average speed*

    Yes, I understand, though the instant speed with and without the gaps may be perhaps of interest too.

    As for the cumulative average, or even a floating average over certain distance or time interval frame - that can be added to Garmin Connect with a Data Field type of a Connect IQ app. There may be already fitting apps available. If not and interested, I could code it.

  • 0 over 2 years ago in reply to trux
    trux said:
    As for the cumulative average, or even a floating average over certain distance or time interval frame - that can be added to Garmin Connect with a Data Field type of a Connect IQ app. There may be already fitting apps available. If not and interested, I could code it.

    I have an app that can do both of those things, although the user experience admittedly isn't great.

    https://apps.garmin.com/en-US/apps/fd690281-9c22-4fee-a81e-3b7f39aa67c5#0

    For cumulative average, use the following options:

    Label: Avg Speed (or whatever you want)
    Formula: avgspeed
    Display Format: Auto
    Record Data To Fit File: Yes

    Floating average aka moving average (with fixed time/distance window) is possible but a bit more complicated. I'll post the formulas if there's interest.

    EDIT: there are other apps in the store which display moving average speed but they don't support Edge Explore and I don't know if they record data to the activity FIT file.