Background - Using Home Assistant to control my Nest Thermostat, which events are written to an InfluxDB. One event is under domainID = climate is hvac_action_str. The data in this table appears like:
“Time”,“hvac_action_str”
2024-08-16 09:01:01,idle
2024-08-16 09:05:28,idle
2024-08-16 11:29:28,idle
2024-08-16 12:31:28,idle
2024-08-16 13:21:28,idle
2024-08-16 13:51:40,cooling
2024-08-16 13:51:40,cooling
2024-08-16 13:59:30,cooling
2024-08-16 14:06:34,idle
2024-08-16 14:33:27,idle
2024-08-16 14:40:45,cooling
2024-08-16 14:51:27,cooling
2024-08-16 14:57:26,idle
2024-08-16 15:17:27,idle
2024-08-16 15:18:58,cooling
2024-08-16 15:30:49,cooling
2024-08-16 15:40:35,idle
2024-08-16 15:56:08,idle
2024-08-16 16:03:13,cooling
2024-08-16 16:15:27,cooling
2024-08-16 16:23:19,idle
2024-08-16 16:41:28,idle
2024-08-16 16:59:26,cooling
2024-08-16 17:27:28,cooling
2024-08-16 18:03:22,idle
2024-08-16 18:21:29,idle
2024-08-16 18:29:28,cooling
2024-08-16 18:57:28,cooling
2024-08-16 19:24:20,idle
2024-08-16 19:47:14,idle
2024-08-16 19:47:16,cooling
2024-08-16 20:19:28,cooling
2024-08-16 20:31:25,idle
2024-08-16 20:31:25,idle
2024-08-16 21:37:14,idle
2024-08-16 21:48:48,idle
2024-08-16 21:48:50,cooling
2024-08-16 21:48:55,cooling
2024-08-16 22:01:44,cooling
2024-08-16 22:01:44,idle
2024-08-16 22:15:28,idle
2024-08-16 22:49:51,idle
2024-08-16 22:49:52,cooling
2024-08-16 22:59:31,cooling
2024-08-16 23:07:28,idle
2024-08-16 23:11:07,idle
2024-08-16 23:17:28,idle
2024-08-17 00:18:14,idle
2024-08-17 00:18:15,cooling
2024-08-17 00:29:32,cooling
2024-08-17 00:39:38,idle
2024-08-17 00:45:28,idle
2024-08-17 00:49:28,idle
2024-08-17 01:00:08,idle
2024-08-17 03:09:29,idle
2024-08-17 03:09:31,idle
2024-08-17 03:11:31,idle
2024-08-17 03:29:29,idle
2024-08-17 03:37:26,idle
2024-08-17 03:41:29,idle
2024-08-17 04:07:28,idle
2024-08-17 04:13:28,idle
2024-08-17 04:21:30,idle
2024-08-17 04:25:29,idle
2024-08-17 04:41:30,idle
2024-08-17 05:01:29,idle
2024-08-17 05:09:30,idle
2024-08-17 05:51:29,idle
2024-08-17 05:59:30,idle
2024-08-17 06:01:29,idle
2024-08-17 06:13:30,idle
2024-08-17 06:19:30,idle
2024-08-17 06:21:29,idle
2024-08-17 06:21:37,idle
2024-08-17 06:37:29,idle
2024-08-17 06:39:31,idle
2024-08-17 07:00:11,idle
2024-08-17 07:33:31,idle
2024-08-17 07:35:58,idle
2024-08-17 07:37:31,idle
2024-08-17 07:47:30,idle
2024-08-17 10:31:32,idle
2024-08-17 10:46:58,cooling
2024-08-17 10:46:59,cooling
2024-08-17 10:57:31,cooling
2024-08-17 11:00:08,idle
2024-08-17 11:00:10,idle
2024-08-17 11:13:31,idle
2024-08-17 11:58:57,idle
2024-08-17 12:01:34,idle
2024-08-17 12:03:31,idle
2024-08-17 14:10:56,cooling
2024-08-17 14:21:20,idle
2024-08-17 14:23:31,idle
2024-08-17 14:35:31,idle
2024-08-17 15:10:08,cooling
2024-08-17 15:10:08,cooling
2024-08-17 15:21:31,cooling
2024-08-17 15:35:18,cooling
2024-08-17 15:35:18,idle
2024-08-17 15:43:31,idle
2024-08-17 15:43:56,idle
2024-08-17 15:45:20,cooling
2024-08-17 15:53:29,cooling
2024-08-17 16:04:27,idle
2024-08-17 16:41:31,idle
2024-08-17 16:43:31,cooling
2024-08-17 16:47:31,cooling
2024-08-17 16:57:16,idle
2024-08-17 17:37:31,idle
2024-08-17 17:40:00,cooling
2024-08-17 17:47:31,cooling
2024-08-17 18:01:39,idle
2024-08-17 18:42:52,idle
2024-08-17 18:42:53,cooling
2024-08-17 18:47:31,cooling
2024-08-17 18:48:10,cooling
2024-08-17 18:49:31,cooling
2024-08-17 18:55:50,idle
2024-08-17 18:55:50,idle
2024-08-17 18:55:52,idle
2024-08-17 19:13:31,idle
2024-08-17 20:03:13,idle
2024-08-17 20:03:15,cooling
2024-08-17 20:15:32,cooling
2024-08-17 20:23:27,idle
2024-08-17 21:25:26,idle
2024-08-17 21:31:30,idle
2024-08-17 21:32:45,idle
2024-08-17 21:32:50,idle
2024-08-17 21:32:54,cooling
2024-08-17 21:55:27,cooling
2024-08-17 22:06:34,idle
2024-08-17 23:13:26,cooling
2024-08-17 23:13:26,cooling
2024-08-17 23:15:25,cooling
2024-08-17 23:27:31,idle
2024-08-17 23:31:30,idle
2024-08-17 23:37:33,idle
2024-08-18 01:00:06,idle
2024-08-18 07:00:17,idle
GOAL - To show total time spent each day per state. Total time in idle, total time in cooling, etc
Ultimate Goal - To compare total time cooling the house, compared to the max temp from the OpenWeatherAPI for that day.