Displaying a Weekly Max moving average line graph

[Gerald]

Have a look at this thread, and see if it might help. The script can get activities and return a value for the defined period.

Plotting distance to 30d max distance ratio

Let me know if this helps you. As I know how to get the activity data in Excel via the power data query, I was able to pull each “run” activity and calculate the two field (max distance in the last 30 days, and today’s activity as a % of that 30-day max). Running isn’t my primary sport, so I have a limited time period where I was running 3 times per week. I tried a number of options, using the inter-webs for guidance, and eventually Google Sheets (and a script) could replicate the single activ…