Climate.HVAC_ACTION - Summary total usage per day

Grafana Stat Panel
1

I have a Nest Thermostat which its acitivity is being captured in Home Assistance within an InfluxDB database. I created a Stat Panel, that will show by the events how long it was in state for…
For instance one section will show OFF from 0:00 to 14:00, then cooling from 14:01 to 15:30, then off from 15:31 to 17:05, and so on. I assume that it shows the values because of the difference between the two stamps.

What the requirement is - Be able to diplay the total time each day by HVAC Action… So total off, total cooling, total heat, total fan.

By changing the date range, I could see totals for each day. I am open to different display… bar, total bar, etc.

So if the date range was 30 days… I would either see 30 rows, with values and percentage values of 24 hour period.
Or for the summer see 60 bars, two for each day… such as 8.5 hours cooling… and 15.5 off.

2

please share schema and some sample data. also are you using influxql or flux

3

InfluxDB

4

cant fully help you

5

image
image1617×858 108 KB

1 Like
6

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

1 Like
7

Hopefully what I provided will help

1 Like