Configurable totals tables for fitness data

[Doug_Pape]

Wow! Awesome change, thank you!

[Manuel_Oberti]

The session count includes both actual and planned sessions. Wouldn’t it be better to divide them into session count and planned session count?

[ryandev]

Totals table is now live in the compare page:

Totals Tables on the Compare Page

You can now use totals tables to compare athletes or time periods on the compare page! [image] This uses the same tables as the fitness and totals page and works similarly. You can add a table by coming down to the add chart button and selecting Totals Table. [image] Then edit the new table or select an existing table by going to the pen edit icon. [image] [image] From here you can filter activities [image] Select your own tables or publicly shared tables [image] Or create a brand n…

[Doug_Pape]

Would it be possible to anchor the custom entry to a certain day so the rotation falls on the correct dates. Otherwise it’s set for Jan 1st and won’t likely line up with the intent of the custom option. Thanks again for great new feature.

[david]

You can do that by picking a start date that falls on the correct start day for the rotation. I can’t think of an easy way to specify this otherwise.

[Doug_Pape]

Perfect, an easy solution, exactly what I was looking for. Thank you again.

[stijnh92]

Thanks for the delta feature! Awesome

[bronko]

I do find the grouping feature very useful, I e.g. use it to display cycling stats per month — however, the average values are misleading if there’s incomplete data. So e.g. the current month is dragging down the average miles per month as it isn’t yet complete.
Would it be possible to apply weights to the individual data fields before calculating the average?
Example numbers: stats from Jan 1—Mar 31, total distance 1500km yield a monthly average of 500km. 2 days later, Jan 1—Apr 2, same distance yields an average of 375 km: April is counted as full month, but only contributed 2 days. Weighting that would apply a weight of 100% to Jan–Mar, and 2/30=6.6% to Apr; total weight 3.066 → weighted average = 489 km.
I’m not sure though if that would create problems on different use cases.

[Alex_Firth]

Is it possible to sort a table newest to oldest and keep it that way on refresh? I have a wellness table I’d like to see with the latest days at the top all the time

[Marco_Saraceno]

Is it possible to modify the “distance” units from km to meters? For swimming totals it would be more accurate and pertinent

[MedTechCD]

Can’t tell for sure because I don’t swim but try changing this

[Marco_Saraceno]

Unfortunately I have already that setting applied: no luck.

I guess it may be feasible with custom field with scripting, but it is beyond my skill set.

[Kagey]

If you are just looking to display the swim distance in a Totals table, a simple way is to use a Formula function in the table and just multiple the distance in kilometres by 1000 to get the distance in meters. You will not have “m” after the total in the column but you could add “m” to the title.

[Marco_Saraceno]

Thanks! What would be the distance field name?

I have tried Distance. * 1000 but I get no results.

Thanks!

[MedTechCD]

It’s “distance * 1000”.
No capitals and no dot at the end.

[Marco_Saraceno]

Thanks, solved!

[david]

You can now set the number of decimals used to display a column in options:

[Jeroen_Doesburg]

Great and very welcome new feature! Can this also be implemented for the legend values in (fitness) graphs? I know the space is tight there, especially on mobile. For runners though it matters if they run 50.0 miles or 50.8 per week. At the moment it seems floor() is used so even 50.99 becomes 50.

[davdf]

Is it possible to allow minutes in times to be zero-filled? Currently you might get 1h10m 1h15m then 1h5m. I think it would look better if that was 1h05m because it would be roughly lined up with the other numbers (as much as you can with a proportional font).
Anything less than 10m should still be displayed without the 0 e.g. 1h10m, 1h5m, 55m, 5m