A formula on a fitness chart or totals table can now use the value of another plot on the same chart, or another column of the same table. This lets you make numbers a single formula couldn’t, like speed from a distance column and a time column. Thanks @Seb23 for the idea.
How to use it
Edit the formula and click Other Plot (Other Column in a table). Pick the plot to insert, e.g. plot(“Distance”). You can also type it yourself:
- On a chart, plot(“Distance”) / plot(“Moving”) divides that day’s Distance plot by its Moving plot.
- In a totals table, use column(“Distance”) / column(“Moving”). Each row is worked out from the row’s own totals: the week’s distance divided by the week’s moving time, not the seven daily speeds added up.
The ? next to the button explains this in the editor.
Things to know
- Plots are found by their label, so give each one a different label. If you rename a plot, formulas using it are updated to the new label.
- A warning icon shows on a formula’s row if it uses a label no plot has, a label two plots share, or a plot that uses it back.
- A table formula is only worked out from the row’s totals when everything else in it adds up over days (distance, time, load and so on). If it also uses a measurement like weight or fitness, or the column has an aggregation such as a moving average, each day is worked out and the days are combined like any other column. You can choose the aggregation in the column’s options; the default is shown there.
- On the /compare page, a formula on the Y axis can use the X axis and the other way round.
The editor’s buttons are now named for what they insert: Field (was Add Plot), Other Plot and Function.