weeks_summary_view (view)

465 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: weight, sleep_avg, rem_sleep_avg, stress_avg, activities, hydration_goal, spo2_avg, rr_waking_avg, first_day (date)

Next page

CREATE VIEW weeks_summary_view AS SELECT weeks_summary.first_day AS first_day, ROUND(weeks_summary.rhr_avg, 1) AS rhr , ROUND(weeks_summary.inactive_hr_avg, 1) AS inactive_hr , ROUND(weeks_summary.weight_avg, 1) AS weight , weeks_summary.intensity_time AS intensity_time, weeks_summary.moderate_activity_time AS moderate_activity_time, weeks_summary.vigorous_activity_time AS vigorous_activity_time, weeks_summary.steps AS total_steps, ROUND(round(steps / 7), 1) AS steps_avg , ROUND(round((steps * 100) / steps_goal), 1) AS steps_goal_percent , ROUND(floors, 1) AS total_floors , ROUND(round(floors / 7), 1) AS floors_avg , ROUND(round((floors * 100) / floors_goal), 1) AS floors_goal_percent , weeks_summary.sleep_avg AS sleep_avg, weeks_summary.rem_sleep_avg AS rem_sleep_avg, ROUND(weeks_summary.stress_avg, 1) AS stress_avg , ROUND(weeks_summary.calories_avg, 1) AS calories_avg , ROUND(weeks_summary.calories_bmr_avg, 1) AS calories_bmr_avg , ROUND(weeks_summary.calories_active_avg, 1) AS calories_active_avg , ROUND(weeks_summary.calories_consumed_avg, 1) AS calories_consumed_avg , ROUND(weeks_summary.calories_goal, 1) AS calories_goal , weeks_summary.activities AS activities, ROUND(weeks_summary.activities_calories, 1) AS activities_calories , ROUND(weeks_summary.activities_distance, 1) AS activities_distance , ROUND(weeks_summary.hydration_goal, 1) AS hydration_goal , ROUND(weeks_summary.hydration_avg, 1) AS hydration_avg , ROUND(weeks_summary.sweat_loss_avg, 1) AS sweat_loss_avg , ROUND(weeks_summary.sweat_loss_avg, 1) AS sweat_loss_avg , ROUND(weeks_summary.spo2_avg, 1) AS spo2_avg , ROUND(weeks_summary.rr_waking_avg, 1) AS rr_waking_avg  
FROM weeks_summary ORDER BY weeks_summary.first_day DESC;