tcgoetz
Time values in summary tables
I have a few issues with the summarized time values in 'garmin_summary.db'.
[weeks_summary].[intensity_time]: This appears to be calculated as an average of the non-zero values from [days_summary].[intensity_time]. Same issue applies to [weeks_summary].[moderate_activity_time]. I think the correct calculation for these would be the sum of the values found in the [days_summary] table. The field [weeks_summary].[vigorous_activity_time] is already calculated correctly as the sum.
In tables [months_summary] and [years_summary] there is an issue when the summarized values (intensity_time, moderate_activity_time, vigorous_activity_time) exceed 24 hours.
I also noticed something not right with the intensity the weekly summary.
Calculating averages only of the non-zero-values doesn't really make sense. It should either be the total, or the average per day based on 7 days per week. Garmin gives as the weekly values the total for the week (not the daily average), so it is at best confusing to have a different calculation here.
Here are my data in the garmin_summary.db.
For example, the week starting 2025-03-05 (btw, why does the week start Wednesday?), the moderate activity is given as 0:59:12, but the sum of the daily values from the 5th to the 11th is 4:56 hours, so that's 0:42:17 per day if you count all 7 days.
This is really confusing as it looks like I had almost the same activity in the week from the 5th as from the 12th, even though it was actually more than 2 hours difference (4:56 hours versus 7:02 hours)
