Power fluctuates widely during exercise activities, such as cycling. It would be helpful to add a chart showing the change in average power over time during an exercise.
Power fluctuates widely during exercise activities, such as cycling. It would be helpful to add a chart showing the change in average power over time during an exercise.
Cool. In that case, even a very large rolling average window such as 60 minutes should be no problem.
The first step is to get the AppBuilder 5 data field from the Connect IQ store: apps.garmin.com/.../fd690281-9c22-4fee-a81e-3b7f39aa67c5
Unfortunately, since the forum has recently been having problems that prevent certain kinds of posts from being made, it's gonna take me a while to post the rest of the instructions as I make random edits until the forum finally allows me to post the whole thing.
For anyone else reading this, almost any Edge or any watch released in the last 7 years, like FR935 and newer, should have no problems with a 20 minute rolling average. Older devices, like 920XT, are not going to work. For larger windows, like 60 minutes, you probably need a watch released in the past 4-5 years.
1. Get the AppBuilder 5 data field from the Connect IQ store: apps.garmin.com/.../fd690281-9c22-4fee-a81e-3b7f39aa67c5
2. Use the following settings. NOTE: anywhere you see square brackets [ ], please replace them with parentheses ( )
- Label: POWER [20 min]
[or whatever you want]
- Display Format: Auto
- Record to FIT file: Yes
- Formula: timeavg[power, 20 * 60]
Here's the explanation of the formula:
- timeavg: function that calculates rolling average over time
- power: the built-in current power metric for the activity
- 20 * 60: 20 minutes, in seconds. Adjust this number to change the size of the rolling average window. If the number is so large that the data field will run out of memory, the field will immediately crash and display an "IQ!" logo, when you open the activity or add the data field to the activity for the first time
Notes on timeavg:
- timeavg does not wait until the window is full, meaning that that the rolling average will be calculated during the first 20 minutes after the activity starts or is unpaused, which may be contrary to your requirements - you may wish for the average to only be calculated once the sample window is full (after 20 minutes).
- pausing an activity resets the rolling average data, meaning you're starting from scratch when the activity is unpaused
You can change this behavior by adding a third or fourth parameter to the timeavg function call.
ciq-appbuilder.blogspot.com/.../functions.html
Here's a screenshot of the relevant info, since the forum won't let me post it as text: https://postimg.cc/3yVGZDD1
For example, to calculate the rolling average of power for 20 minutes, waiting until the sample window is full [no average is calculated until 20 minutes have passed from when the activity started or was last unpaused], and keeping old power samples while the activity is paused:
timeavg[power, 20 * 60, 1, 1]
Also: if you change the settings for AppBuilder 5, you need to close the activity and re-open it. Settings changes will not take effect during an activity in progress.
It appears as though this forum is for both the web and the app. At least that's what it shows at the top of the screen for me.
Well, it is not really important, since people will eventually understand what you mean, but to get the answer quicker, it is always better asking on the right forum. This one is for the GC Web interface. The top title tells it too: "Garmin Connect Web". Forums for mobile apps (one for Android, and another one for iOS) are listed in the upper root category "Mobile Apps & Web" (clickable at the top). More specifically:
Thanks !
Got it. First time I’ve used the Garmin forum. Thanks.