Formula and Chart Help

[James]

I know this should be easy, but I haven't been able to figure it out.

1.  I have a performance chart with IsoPower, and Power and I would also like to see a rolling average power for a specified time interval (i.e. 5 min or 20 min).   I thought it would be something like average(power, time) but that doesn't seem to work.  Would be similar to lap/interval average power.  

2.  Is there a way to have all of the chart axis be at the same scale?  when I use the pre-built curves there is no issue, but when i bring in a user curve it scales the Y axis differently.

Thanks,

James

[Ale Martinez (Please don't email or cc me)]

El jueves, 15 de octubre de 2020, 19:18:41 (UTC-3), James escribió:

I know this should be easy, but I haven't been able to figure it out.

1.  I have a performance chart with IsoPower, and Power and I would also like to see a rolling average power for a specified time interval (i.e. 5 min or 20 min).   I thought it would be something like average(power, time) but that doesn't seem to work.  Would be similar to lap/interval average power.  

The easiest way would be to set Smooth=300 or Smooth=1200, you can do that in chart settings, or using reveal controls hovering the cursor at the top of the chart.

 

2.  Is there a way to have all of the chart axis be at the same scale?  when I use the pre-built curves there is no issue, but when i bring in a user curve it scales the Y axis differently.

Not that I know. 

[James]

Thanks for the response, Ale!

 

I know this should be easy, but I haven't been able to figure it out.

1.  I have a performance chart with IsoPower, and Power and I would also like to see a rolling average power for a specified time interval (i.e. 5 min or 20 min).   I thought it would be something like average(power, time) but that doesn't seem to work.  Would be similar to lap/interval average power.  

The easiest way would be to set Smooth=300 or Smooth=1200, you can do that in chart settings, or using reveal controls hovering the cursor at the top of the chart.

While an easy fix, that really doesn't accomplish what I am looking to do.  Trying to visually show some "new to power" riders the difference and correlation between the three main ways we  tend to look at power metrics (Power vs Avg vs Iso/NP). 

 

 

2.  Is there a way to have all of the chart axis be at the same scale?  when I use the pre-built curves there is no issue, but when i bring in a user curve it scales the Y axis differently.

Not that I know. 

Dang.  I would like to have a little more control than the sliders.

[Ale Martinez (Please don't email or cc me)]

El viernes, 16 de octubre de 2020, 11:48:20 (UTC-3), James escribió:

Thanks for the response, Ale!

 

I know this should be easy, but I haven't been able to figure it out.

1.  I have a performance chart with IsoPower, and Power and I would also like to see a rolling average power for a specified time interval (i.e. 5 min or 20 min).   I thought it would be something like average(power, time) but that doesn't seem to work.  Would be similar to lap/interval average power.  

The easiest way would be to set Smooth=300 or Smooth=1200, you can do that in chart settings, or using reveal controls hovering the cursor at the top of the chart.

While an easy fix, that really doesn't accomplish what I am looking to do.  Trying to visually show some "new to power" riders the difference and correlation between the three main ways we  tend to look at power metrics (Power vs Avg vs Iso/NP). 

I v3.5 it is hard to compute Moving Averages but you could approximate it using an EWMA.

In v3.6 formula language includes vector handling, so it would be easier: https://github.com/GoldenCheetah/GoldenCheetah/wiki/UG_Special-Topics_Formula-Syntax-and-Expressions#working-with-vectors

 

 

 

2.  Is there a way to have all of the chart axis be at the same scale?  when I use the pre-built curves there is no issue, but when i bring in a user curve it scales the Y axis differently.

Not that I know. 

Dang.  I would like to have a little more control than the sliders.

The new User Charts in v3.6 give you more control about the chart layout: https://github.com/GoldenCheetah/GoldenCheetah/wiki/UG_Special-Topics_Working-with-User-Charts 

[James]

Ale,

I think I am causing confusion with my "rolling" average semantics.  What I am looking to accomplish is probably simpler.  I was able to plot my average power in excel to show how I am wanting to look at it:

Its really about showing the average power in 5 min blocks (or the time variable I want to show) or the average power for the lap, etc.  

Second question - looks like a lot of developments in v.3.6 - can you run multiple versions at the same time without much incidence? I like to keep a version I '"know" while I learn the new version.

Thanks again for all that you do!

[James]

[Ale Martinez (Please don't email or cc me)]

El lunes, 19 de octubre de 2020, 11:30:15 (UTC-3), James escribió:

Ale,

I think I am causing confusion with my "rolling" average semantics.  What I am looking to accomplish is probably simpler.  I was able to plot my average power in excel to show how I am wanting to look at it:

Its really about showing the average power in 5 min blocks (or the time variable I want to show) or the average power for the lap, etc.  

There is no easy way that I know to do this in the standard activity chart, in v3.5 you would need an R or Python chart.

Smoothing is available in v3.6 formulas (https://github.com/GoldenCheetah/GoldenCheetah/wiki/UG_Special-Topics_Formula-Syntax-and-Expressions#smoothing-noisy-data), in a User Chart would be easier to plot original and smoothed series in the same chart.

 

Second question - looks like a lot of developments in v.3.6 - can you run multiple versions at the same time without much incidence? I like to keep a version I '"know" while I learn the new version.

It is possible, provided you use separate data, as explained in https://github.com/GoldenCheetah/GoldenCheetah/wiki/FAQ-DATA#how-can-i-have-a-separated-data-or-portable-goldencheetah-install