Building a chart - multiple activities per day

Hi folks,

I have an activity field: Recovery Time, extracted from Garmin FIT files. I’m building a bar chart showing it on the fitness tab, Recovery Time per day. Which works good if I have one activity per day, but doesn’t, when I have more than one.
No matter which aggregation function I pick, I always get as sum of recovery times on that day.
I’ve tried: min (1 day), max (1 day), as-is and every other function also. What I actually need is either latest value per day or max value per day.

The actual field doesn’t matter, I can reproduce it with any other built-in field, Load, for example

I just looked in an activity I manually uploaded from Garmin export but cannot find the two fields Recovery Time and Impact Load. Could you share some details how to add those fields?

Recovery Time:
FIT Field 140.9

Impact Load:
FIT Field: 221

Thanks and where do you add those custom fields? Sorry for dumb question I looked everywhere under Activities menu :frowning:

Any Activity → Custom (bottom menu) → Add Field.
After adding new fields, you need to Reprocess FIT file(s).
Any Activity → Actions → Reprocess file

Thanks for guiding me I found the menu. Looks I have a unit issue: for RecoveryTime it looks to show minutes so mostly need to divide by 60 to get hours? ImpactLoad shows empty (null). Anyone has tried those FIT fields? I might need to inspect my FIT file in raw then.

Does your watch support it? It should from the latest generation Fenix 8, Enduro 3, 570/970

Ok I have the FR955 Solar I forgot about that aspect :wink: With Runalyze Fit File Viewer I found:
= TYPE=4 NUMBER=140
— unknown9=1584=1584
So this one looks like minutes unit.

I couldn’t find indeed Field number 221 in my sample file from my watch.
First time I look in depth in a file, quite impressive to see the amount of stuff logged.
Is there somewhere some documentation from Garmin on this?
Sorry for the off topic.

yes, correct. there’s actually a script section:

activity.isNew ? activity.RecoveryTime / 60 : activity.RecoveryTime

This field was created by someone else and shared, so I just imported it

1 Like

Not for those fields. Seems like they are purposefully trying to hide that data a bit.
That’s why it took quit a bit of work from several users to find out where those metrics are saved. Runalyze has probably the most of those figured out.

Perfect I got it to work with the script section indeed.
You are right this looks interesting to graph the RecoveryTime in the Fitness I added it and I can understand your original question better now :wink: With Max 1d don’t you get what you need? Or are you after a Daily Total?

When I have more than one activity per day - No. I always get a sum of all Recovery Times on that day

Oooh, only seeing this now. You tried to aggregate in the chart itself…
On the description tab of the custom field you can choose the aggregation mode. That should get you what you’re after.
Apologies for not noticing this earlier, you were talking ‘aggregation’ so I deduced wrongly that you knew this.

1 Like

Why it’s on Description tab?? :slight_smile:
Definitely a TIL moment, thanks for the hint!