Displaying a Weekly Max moving average line graph

[Faris_Salman]

Hi everyone, in light of the recent findings of the study “Identifying high-risk running sessions”, I am thinking to display a weekly max moving average using 30d window in the /fitness.
I plan to use this information as one of the safety guards on top of others.

However, i soon to realize the option was limited in adding custom charts.
I can either add a “Distance” chart and display the “Weekly Max” or i can display the “Moving Avg” chart. I wonder if there is a way to display “Weekly Max Moving Average”, or any of the members have any idea how to display such information?

[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…

[MedTechCD]

I did not read the entire paper but from this

I would think that you just need to plot the max of the last 30d and then, mentally, add 10% to stay within the limits for your longest session.

[ohmax]

Thanks for your question I’m interested about steps needed to take when a solution will be found I’ll keep an eye on this post.

[Gerald]

@MedTechCD

I would think that you just need to plot the max of the last 30d and then, mentally, add 10% to stay within the limits for your longest session.

No need to mentally guess.
I created two fields called Max30d and PcntMaxKm to answer someone else’s requirement for the same thing. It just requires calculating in Excel/Google Sheets to get the answer.

• Max30d is the the max distance in the last 30 days
• PcntMaxKm is the percentage of each activity relative to the Max30d value
  
  

[Faris_Salman]

Thank you @Gerald, i will try to have a look on the fields you provided. I read the other post as well and seems like it addresses what i am looking for.

[Gerald]

It was a learning experience for me, and due to minimal running activities I don’t use it a lot. If you need assistance, let me know and I’ll go back and check.

[Faris_Salman]

Hi, @Gerald
Thank you for your quick response!

I tried it in excel 365 (thats the only one i have) and i was able to produce the Max30d and PcntMaxKm values.
I also entered my API key as suggested.

However, it failed to upload it to the intervals icu, returning 422 error (Failed 422).
I wonder if there is a place where the user should enter an athlete id but it is not visible or editable… I’m assuming API key should be paired with athlete id.

Edit.
My mistake, i haven’t add the two custom activity field: Max30d and PcntMaxKm. That’s why it threw error 422.
After i added the custom activity field, the upload succeeded.
I ended up only using the Max30d value and then use 1.1 factor to show the 10% increase of the max 30d.

Thank you @Gerald, thank you everyone!

[Gerald]

@Faris_Salman

I ended up only using the Max30d value and then use 1.1 factor to show the 10% increase of the max 30d.

The PcntMaxKm will show what the past activities were relative to the Max30d value.
For future workouts, I guess you can use the 1.1 factor.