days_summary_view (view)

3,286 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: weight, calories_consumed_avg, activities, hydration_avg, spo2_avg, spo2_min, rr_waking_avg, rr_min, day (date)

Next page

CREATE VIEW days_summary_view AS SELECT days_summary.day AS day, ROUND(days_summary.hr_avg, 1) AS hr_avg , ROUND(days_summary.hr_min, 1) AS hr_min , ROUND(days_summary.hr_max, 1) AS hr_max , ROUND(days_summary.rhr_avg, 1) AS rhr , ROUND(days_summary.inactive_hr_avg, 1) AS inactive_hr , ROUND(days_summary.weight_avg, 1) AS weight , days_summary.intensity_time AS intensity_time, days_summary.moderate_activity_time AS moderate_activity_time, days_summary.vigorous_activity_time AS vigorous_activity_time, days_summary.steps AS steps, ROUND(round((steps * 100) / steps_goal), 1) AS steps_goal_percent , ROUND(days_summary.floors, 1) AS floors , ROUND(round((floors * 100) / floors_goal), 1) AS floors_goal_percent , days_summary.sleep_avg AS sleep_avg, days_summary.rem_sleep_avg AS rem_sleep_avg, ROUND(days_summary.stress_avg, 1) AS stress_avg , ROUND(days_summary.calories_avg, 1) AS calories_avg , ROUND(days_summary.calories_bmr_avg, 1) AS calories_bmr_avg , ROUND(days_summary.calories_active_avg, 1) AS calories_active_avg , ROUND(days_summary.calories_consumed_avg, 1) AS calories_consumed_avg , ROUND(days_summary.calories_goal, 1) AS calories_goal , days_summary.activities AS activities, ROUND(days_summary.activities_calories, 1) AS activities_calories , ROUND(days_summary.activities_distance, 1) AS activities_distance , ROUND(days_summary.hydration_goal, 1) AS hydration_goal , ROUND(days_summary.hydration_avg, 1) AS hydration_avg , ROUND(days_summary.sweat_loss_avg, 1) AS sweat_loss_avg , ROUND(days_summary.spo2_avg, 1) AS spo2_avg , ROUND(days_summary.spo2_min, 1) AS spo2_min , ROUND(days_summary.rr_waking_avg, 1) AS rr_waking_avg , ROUND(days_summary.rr_max, 1) AS rr_max , ROUND(days_summary.rr_min, 1) AS rr_min , ROUND(days_summary.bb_max, 1) AS bb_max , ROUND(days_summary.bb_min, 1) AS bb_min  
FROM days_summary ORDER BY days_summary.day DESC;