months_summary_view (view)

89 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: rhr, sleep_avg, rem_sleep_avg, activities, hydration_goal, rr_waking_avg, first_day (date)

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