diff options
| -rw-r--r-- | weight/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/weight/schema.sql b/weight/schema.sql index 07b08bb1..c057aefb 100644 --- a/weight/schema.sql +++ b/weight/schema.sql @@ -83,7 +83,7 @@ create view reporting.weekly_medication as ( from weight.pressure_medication ) select week.week, - avg(dose_mg) as average_daily_dose + sum(dose_mg)/7 as average_daily_dose from generate_series((select min_week from limits), (select max_week from limits), '7 days') as week left join weight.pressure_medication on date_trunc('week', week.week) = date_trunc('week', pressure_medication.taken_at) group by week.week order by week.week); |