core
core copied to clipboard
Published
20 hours ago •
home-assistant
home-assistant
Energy dashboard graph error
The problem
I do have a night and day tariff with my energy supplier. I got 2 sensors, one per tariff class.
Day sensor do not increase starting 22h30 till 6h30.
As per graph, we see evolution of EASF02 during night (before 6h30) which shall not be the case (refer to database output attached), same for EASF01 after 06h30.
What version of Home Assistant Core has the issue?
core-2022-10-3
What was the last working version of Home Assistant Core?
No response
What type of installation are you running?
Home Assistant Supervised
Integration causing the issue
integration:energy
Link to integration documentation on our website
https://www.home-assistant.io/docs/energy/
Diagnostics information
No response
Example YAML snippet
No response
Anything in the logs that might be useful for us?
core-mariadb:3306/homeassistant/states/
Showing rows 100 - 124 (5213 total, Query took 0.1328 seconds.) [last_updated: 2022-10-14 04:49:38... - 2022-10-13 20:26:37...]
SELECT * FROM `states` WHERE `entity_id` LIKE 'sensor.linky_easf02' ORDER BY `last_updated` DESC;
state_id entity_id state attributes event_id last_changed last_updated old_state_id attributes_id context_id context_user_id context_parent_id origin_idx
2071074 sensor.linky_easf02 19602.558 NULL NULL NULL 2022-10-14 04:49:38 2071053 876480 01GFAD74AQJHETHY4HJYPZSVRF NULL NULL 0
2071053 sensor.linky_easf02 19602.537 NULL NULL NULL 2022-10-14 04:48:38 2071017 876480 01GFAD59QHF5863ECRRH43JHT1 NULL NULL 0
2071017 sensor.linky_easf02 19602.514 NULL NULL NULL 2022-10-14 04:47:38 2070985 876480 01GFAD3F3TQHRQXFZ5N69MAKGH NULL NULL 0
2070985 sensor.linky_easf02 19602.49 NULL NULL NULL 2022-10-14 04:46:38 2070962 876480 01GFAD1MH98VHN3NQE0Z7XNR4E NULL NULL 0
2070962 sensor.linky_easf02 19602.469 NULL NULL NULL 2022-10-14 04:45:38 2070945 876480 01GFACZSYCMZB108NHFBAHDKFC NULL NULL 0
2070945 sensor.linky_easf02 19602.451 NULL NULL NULL 2022-10-14 04:44:38 2070932 876480 01GFACXZA5N8XEGF3QQWPJH4GY NULL NULL 0
2070932 sensor.linky_easf02 19602.422 NULL NULL NULL 2022-10-14 04:43:38 2070914 876480 01GFACW4QX33PWWK86RJV3DEMB NULL NULL 0
2070914 sensor.linky_easf02 19602.405 NULL NULL NULL 2022-10-14 04:42:38 2070901 876480 01GFACTA53FPSMTMNC8HCP77EV NULL NULL 0
2070901 sensor.linky_easf02 19602.383 NULL NULL NULL 2022-10-14 04:41:39 2070881 876480 01GFACRFY3GP6GYW35M5DP8S2Y NULL NULL 0
2070881 sensor.linky_easf02 19602.35 NULL NULL NULL 2022-10-14 04:40:38 2070861 876480 01GFACPMYFVFZ0YEDWP1DTZX99 NULL NULL 0
2070861 sensor.linky_easf02 19602.332 NULL NULL NULL 2022-10-14 04:39:38 2070844 876480 01GFACMTBETF71BPSF3DCH0AC6 NULL NULL 0
2070844 sensor.linky_easf02 19602.304 NULL NULL NULL 2022-10-14 04:38:38 2070834 876480 01GFACJZRETMFCVN15GKBRB6W1 NULL NULL 0
2070834 sensor.linky_easf02 19602.281 NULL NULL NULL 2022-10-14 04:37:38 2070810 876480 01GFACH55HGGEFBVWPBY9HXGK5 NULL NULL 0
2070810 sensor.linky_easf02 19602.264 NULL NULL NULL 2022-10-14 04:36:38 2070780 876480 01GFACFAVEE7JTVZC8FM8GKEGP NULL NULL 0
2070780 sensor.linky_easf02 19602.235 NULL NULL NULL 2022-10-14 04:35:38 2070767 876480 01GFACDFZ1PSPMK02VJTZ5MCBA NULL NULL 0
2070767 sensor.linky_easf02 19602.211 NULL NULL NULL 2022-10-14 04:34:38 2070746 876480 01GFACBNB18MVMQX12A74FHC5F NULL NULL 0
2070746 sensor.linky_easf02 19602.19 NULL NULL NULL 2022-10-14 04:33:38 2070731 876480 01GFAC9TS6MZ6XXXZ9DD1N66PG NULL NULL 0
2070731 sensor.linky_easf02 19602.165 NULL NULL NULL 2022-10-14 04:32:38 2070715 876480 01GFAC8056PHPJ57NSC4KAFMG8 NULL NULL 0
2070715 sensor.linky_easf02 19602.14 NULL NULL NULL 2022-10-14 04:31:39 2070690 876480 01GFAC66MQY4RDDCTY5E7SKJ0D NULL NULL 0
2070690 sensor.linky_easf02 19602.117 NULL NULL NULL 2022-10-14 04:30:38 2070668 876480 01GFAC4B0545FZ3K020MBQRSZB NULL NULL 0
2070668 sensor.linky_easf02 19602.091 NULL NULL NULL 2022-10-14 04:29:38 2070650 876480 01GFAC2GDD2ZXG386F2QYYS3MH NULL NULL 0
2070650 sensor.linky_easf02 19602.062 NULL NULL NULL 2022-10-14 04:28:38 2062511 876480 01GFAC0NSB9Z475QTRWD61XHG3 NULL NULL 0
2062511 sensor.linky_easf02 19602.053 NULL NULL NULL 2022-10-13 20:28:37 2062490 876480 01GF9GHR4SQK3EBZATMQ87B4SS NULL NULL 0
2062490 sensor.linky_easf02 19602.028 NULL NULL NULL 2022-10-13 20:27:37 2062471 876480 01GF9GFWTH7RD7A5QN4Y6R33KN NULL NULL 0
2062471 sensor.linky_easf02 19601.995 NULL NULL NULL 2022-10-13 20:26:37 2062445 876480 01GF9GE27MN1HMSSQGA55XRAMR NULL NULL 0
core-mariadb:3306/homeassistant/states/
Showing rows 0 - 24 (2843 total, Query took 0.0590 seconds.) [last_updated: 2022-10-14 04:28:38... - 2022-10-14 04:04:38...]
SELECT * FROM `states` WHERE `entity_id` LIKE 'sensor.linky_easf01' ORDER BY `last_updated` DESC;
state_id entity_id state attributes event_id last_changed last_updated old_state_id attributes_id context_id context_user_id context_parent_id origin_idx
2070648 sensor.linky_easf01 10025.249 NULL NULL NULL 2022-10-14 04:28:38 2070632 876479 01GFAC0NQAVBJM729HBX9ZNZJ6 NULL NULL 0
2070632 sensor.linky_easf01 10025.241 NULL NULL NULL 2022-10-14 04:27:38 2070613 876479 01GFABYV4788Y7FQ3ZW7YJEQT9 NULL NULL 0
2070613 sensor.linky_easf01 10025.213 NULL NULL NULL 2022-10-14 04:26:38 2070596 876479 01GFABX0HG6R3P1SNJKH1MBX7R NULL NULL 0
2070596 sensor.linky_easf01 10025.19 NULL NULL NULL 2022-10-14 04:25:38 2070579 876479 01GFABV5YDZFTWJWE1818C1PA7 NULL NULL 0
2070579 sensor.linky_easf01 10025.172 NULL NULL NULL 2022-10-14 04:24:38 2070563 876479 01GFABSBBHJKDBGB5QH94JKK7T NULL NULL 0
2070563 sensor.linky_easf01 10025.141 NULL NULL NULL 2022-10-14 04:23:38 2070550 876479 01GFABQGRDZM1EVYF7F9BKCBWK NULL NULL 0
2070550 sensor.linky_easf01 10025.117 NULL NULL NULL 2022-10-14 04:22:38 2070535 876479 01GFABNP544T56CBW715XAAKFY NULL NULL 0
2070535 sensor.linky_easf01 10025.095 NULL NULL NULL 2022-10-14 04:21:38 2070515 876479 01GFABKVJ7Z0GAS0GRY0G82348 NULL NULL 0
2070515 sensor.linky_easf01 10025.068 NULL NULL NULL 2022-10-14 04:20:38 2070499 876479 01GFABJ0Z9C21YD4BPZT7TG2SF NULL NULL 0
2070499 sensor.linky_easf01 10025.042 NULL NULL NULL 2022-10-14 04:19:39 2070483 876479 01GFABG753YF1XXJB4HK7STC9E NULL NULL 0
2070483 sensor.linky_easf01 10025.018 NULL NULL NULL 2022-10-14 04:18:38 2070467 876479 01GFABEBS086G5R9NXB1HQ31PQ NULL NULL 0
2070467 sensor.linky_easf01 10024.993 NULL NULL NULL 2022-10-14 04:17:38 2070452 876479 01GFABCH5YN9Q2XCSCG3493G90 NULL NULL 0
2070452 sensor.linky_easf01 10024.964 NULL NULL NULL 2022-10-14 04:16:38 2070437 876479 01GFABAPK49NPTQ83A1ZNKT8D9 NULL NULL 0
2070437 sensor.linky_easf01 10024.945 NULL NULL NULL 2022-10-14 04:15:38 2070418 876479 01GFAB8VZXT5NAV3WKX9R84G4B NULL NULL 0
2070418 sensor.linky_easf01 10024.913 NULL NULL NULL 2022-10-14 04:14:38 2070401 876479 01GFAB71CXATZQ4AG10H5JMJ32 NULL NULL 0
2070401 sensor.linky_easf01 10024.89 NULL NULL NULL 2022-10-14 04:13:38 2070382 876479 01GFAB56SXZT6WW02VJXBVPA9F NULL NULL 0
2070382 sensor.linky_easf01 10024.878 NULL NULL NULL 2022-10-14 04:12:38 2070365 876479 01GFAB3C6YB0K2GK4S29T05BN6 NULL NULL 0
2070365 sensor.linky_easf01 10024.856 NULL NULL NULL 2022-10-14 04:11:38 2070352 876479 01GFAB1HKQBTWFP47WB5VYHC2F NULL NULL 0
2070352 sensor.linky_easf01 10024.846 NULL NULL NULL 2022-10-14 04:10:38 2070335 876479 01GFAAZQ0YYWSZ0J4YGE9A3MCB NULL NULL 0
2070335 sensor.linky_easf01 10024.839 NULL NULL NULL 2022-10-14 04:09:38 2070317 876479 01GFAAXWDTXKN3J1A61KSV7M1W NULL NULL 0
2070317 sensor.linky_easf01 10024.825 NULL NULL NULL 2022-10-14 04:08:38 2070304 876479 01GFAAW1TJE9KZJSNQB6PKCP5Q NULL NULL 0
2070304 sensor.linky_easf01 10024.812 NULL NULL NULL 2022-10-14 04:07:39 2070283 876479 01GFAAT7QR1ST3FAE8DPQEQ0KE NULL NULL 0
2070283 sensor.linky_easf01 10024.796 NULL NULL NULL 2022-10-14 04:06:38 2070262 876479 01GFAARCMJ7YWY5N9ZFKB058QJ NULL NULL 0
2070262 sensor.linky_easf01 10024.759 NULL NULL NULL 2022-10-14 04:05:38 2070251 876479 01GFAAPJ1FW546AQSF48SS96RD NULL NULL 0
2070251 sensor.linky_easf01 10024.711 NULL NULL NULL 2022-10-14 04:04:38 2070233 876479 01GFAAMQE5VAZMZF35D2JC78R3 NULL NULL 0
Additional information
No response
I would check the following:
- Development tools -> statistics Check what exactly the system is showing for this time frame
example:
Then, compare in the history, what your sensor is showing
Usually, that will indicate if - and when a sensor might have received an unexpected value (for example because it was offline and does not have unavailable cases covered)... (value felt back to 0)
additionally, check the content of the table "statistics short term" (I don't recall the exact name yet)
Here it is
SELECT * FROM `states` WHERE `entity_id` LIKE 'sensor.linky_easf01' ORDER BY `last_updated` DESC;
state_id entity_id state attributes event_id last_changed last_updated old_state_id attributes_id context_id context_user_id context_parent_id origin_idx
2232773 sensor.linky_easf01 10100.059 NULL NULL NULL 2022-10-20 20:38:38 2232698 876479 01GFVHX400CF0P6SDMN0Q29ZP8 NULL NULL 0
2232698 sensor.linky_easf01 10099.739 NULL NULL NULL 2022-10-20 20:33:38 2232576 876479 01GFVHKZ1F1WVZ2W43Y6CPYN9W NULL NULL 0
2232576 sensor.linky_easf01 10099.422 NULL NULL NULL 2022-10-20 20:28:38 2216052 876479 01GFVHAT27WEE9H06DB40NA594 NULL NULL 0
2216052 sensor.linky_easf01 10099.392 NULL NULL NULL 2022-10-20 04:28:38 2215980 876479 01GFSTCZE2TK3K4AR5XAN06W6T NULL NULL 0
2215980 sensor.linky_easf01 10099.289 NULL NULL NULL 2022-10-20 04:23:38 2215906 876479 01GFST3V6WEH9JS6HMW5NWZ4C8 NULL NULL 0
2215906 sensor.linky_easf01 10099.163 NULL NULL NULL 2022-10-20 04:18:38 2215841 876479 01GFSSTNFC1083PW9H8PVF1MNT NULL NULL 0
2215841 sensor.linky_easf01 10099.049 NULL NULL NULL 2022-10-20 04:13:38 2215766 876479 01GFSSHGGTJ03RAFJZ4TYVQ0T3 NULL NULL 0
2215766 sensor.linky_easf01 10098.934 NULL NULL NULL 2022-10-20 04:08:38 2215697 876479 01GFSS8BHP8Q0WKAJ6CQH4FMQD NULL NULL 0
2215697 sensor.linky_easf01 10098.86 NULL NULL NULL 2022-10-20 04:03:38 2215638 876479 01GFSRZ6JGJZYQW09D7JK0C8HZ NULL NULL 0
2215638 sensor.linky_easf01 10098.805 NULL NULL NULL 2022-10-20 03:58:38 2215561 876479 01GFSRP1KH0MZPBD9SWRFH0M8K NULL NULL 0
2215561 sensor.linky_easf01 10098.68 NULL NULL NULL 2022-10-20 03:53:38 2215498 876479 01GFSRCWM21KTQW6R2QR9GZ6R6 NULL NULL 0
2215498 sensor.linky_easf01 10098.533 NULL NULL NULL 2022-10-20 03:48:38 2215429 876479 01GFSR3QMNNB729B7YWAJJS6PS NULL NULL 0
2215429 sensor.linky_easf01 10098.383 NULL NULL NULL 2022-10-20 03:43:38 2215358 876479 01GFSQTJN3SZ1B49AD5ADW22HB NULL NULL 0
2215358 sensor.linky_easf01 10098.237 NULL NULL NULL 2022-10-20 03:38:38 2215285 876479 01GFSQHDPC3GX02MY3YQZCE0QE NULL NULL 0
2215285 sensor.linky_easf01 10098.095 NULL NULL NULL 2022-10-20 03:33:38 2215204 876479 01GFSQ88Q4FGDRWX50S8QVSG8R NULL NULL 0
2215204 sensor.linky_easf01 10097.977 NULL NULL NULL 2022-10-20 03:28:38 2215141 876479 01GFSPZ3R7TPVMD3BZ6QAV127G NULL NULL 0
2215141 sensor.linky_easf01 10097.932 NULL NULL NULL 2022-10-20 03:23:38 2215065 876479 01GFSPNYRY83G2NVR701W53TKW NULL NULL 0
2215065 sensor.linky_easf01 10097.878 NULL NULL NULL 2022-10-20 03:18:38 2214996 876479 01GFSPCSWDTT3KHAK3D0TR6A2S NULL NULL 0
2214996 sensor.linky_easf01 10097.823 NULL NULL NULL 2022-10-20 03:13:39 2214921 876479 01GFSP3NPWRPT0VEETXTE56HCW NULL NULL 0
2214921 sensor.linky_easf01 10097.766 NULL NULL NULL 2022-10-20 03:08:38 2214857 876479 01GFSNTFVV9J49PRKVEQ5T610W NULL NULL 0
2214857 sensor.linky_easf01 10097.716 NULL NULL NULL 2022-10-20 03:03:38 2214780 876479 01GFSNHAWBJYP278YXTS3DDQAG NULL NULL 0
2214780 sensor.linky_easf01 10097.665 NULL NULL NULL 2022-10-20 02:58:38 2214710 876479 01GFSN85X2KMX6K7HDD8ZF5H1A NULL NULL 0
2214710 sensor.linky_easf01 10097.611 NULL NULL NULL 2022-10-20 02:53:38 2214640 876479 01GFSMZ0XDCZAVW8XREHA70C6M NULL NULL 0
2214640 sensor.linky_easf01 10097.559 NULL NULL NULL 2022-10-20 02:48:38 2214569 876479 01GFSMNVYCZ164ZJ11EMVHVCH2 NULL NULL 0
2214569 sensor.linky_easf01 10097.507 NULL NULL NULL 2022-10-20 02:43:38 2214490 876479 01GFSMCPZMFCRE2QA3SBQJMV8J NULL NULL 0
SELECT * FROM `states` WHERE `entity_id` LIKE 'sensor.linky_easf02' ORDER BY `last_updated` DESC;
state_id entity_id state attributes event_id last_changed last_updated old_state_id attributes_id context_id context_user_id context_parent_id origin_idx
2232578 sensor.linky_easf02 19735.625 NULL NULL NULL 2022-10-20 20:28:38 2232477 876480 01GFVHAT47B17PC2NV1940FNRK NULL NULL 0
2232477 sensor.linky_easf02 19735.589 NULL NULL NULL 2022-10-20 20:23:38 2232353 876480 01GFVH1N57050SNHDE7RXBR606 NULL NULL 0
2232353 sensor.linky_easf02 19735.547 NULL NULL NULL 2022-10-20 20:18:38 2232267 876480 01GFVGRG61XKSV5B0NHYNXGR17 NULL NULL 0
2232267 sensor.linky_easf02 19735.502 NULL NULL NULL 2022-10-20 20:13:38 2232152 876480 01GFVGFB6RZH00SM0C3FXBXJVN NULL NULL 0
2232152 sensor.linky_easf02 19735.457 NULL NULL NULL 2022-10-20 20:08:38 2232083 876480 01GFVG6664NRK9MK4T65W98JRF NULL NULL 0
2232083 sensor.linky_easf02 19735.408 NULL NULL NULL 2022-10-20 20:03:38 2231973 876480 01GFVFX18V5H344AK3KYEQW13V NULL NULL 0
2231973 sensor.linky_easf02 19735.362 NULL NULL NULL 2022-10-20 19:58:38 2231879 876480 01GFVFKW9P5TR4E3FWKHRAT56E NULL NULL 0
2231879 sensor.linky_easf02 19735.312 NULL NULL NULL 2022-10-20 19:53:38 2231754 876480 01GFVFAQ9YGNC7K1JA7M1DZ5TS NULL NULL 0
2231754 sensor.linky_easf02 19735.268 NULL NULL NULL 2022-10-20 19:48:39 2231681 876480 01GFVF1K4FVGTBBKP46AW7Q6W2 NULL NULL 0
2231681 sensor.linky_easf02 19735.228 NULL NULL NULL 2022-10-20 19:43:38 2231604 876480 01GFVERDC2TXZZ8CBX1KBTDYPR NULL NULL 0
2231604 sensor.linky_easf02 19735.185 NULL NULL NULL 2022-10-20 19:38:38 2231515 876480 01GFVEF8CPP7YRFHSF2Y1NY0BB NULL NULL 0
2231515 sensor.linky_easf02 19735.137 NULL NULL NULL 2022-10-20 19:33:38 2231368 876480 01GFVE63DF5WR8749Z33SCY45K NULL NULL 0
2231368 sensor.linky_easf02 19735.085 NULL NULL NULL 2022-10-20 19:28:38 2231289 876480 01GFVDWYEK2N9GT0H2P3HDWGS5 NULL NULL 0
2231289 sensor.linky_easf02 19735.029 NULL NULL NULL 2022-10-20 19:23:38 2231204 876480 01GFVDKSFH58T8TTPZVHXK2QYQ NULL NULL 0
2231204 sensor.linky_easf02 19734.973 NULL NULL NULL 2022-10-20 19:18:38 2231139 876480 01GFVDAMGY3D2RD52XHNDHKZEG NULL NULL 0
2231139 sensor.linky_easf02 19734.921 NULL NULL NULL 2022-10-20 19:13:38 2231031 876480 01GFVD1FG7EWWDBWCXZ38A43K3 NULL NULL 0
2231031 sensor.linky_easf02 19734.874 NULL NULL NULL 2022-10-20 19:08:38 2230901 876480 01GFVCRAHS4B4EQ8CFNH32TTC6 NULL NULL 0
2230901 sensor.linky_easf02 19734.824 NULL NULL NULL 2022-10-20 19:03:38 2230818 876480 01GFVCF5JSFC6CS50M1QHD9NV6 NULL NULL 0
2230818 sensor.linky_easf02 19734.78 NULL NULL NULL 2022-10-20 18:58:38 2230720 876480 01GFVC60KMSZM76GATCZ6CJJYW NULL NULL 0
2230720 sensor.linky_easf02 19734.74 NULL NULL NULL 2022-10-20 18:53:38 2230612 876480 01GFVBWVM6HF7MSM4478K7PMCD NULL NULL 0
2230612 sensor.linky_easf02 19734.681 NULL NULL NULL 2022-10-20 18:48:38 2230487 876480 01GFVBKPN3CS505575DE7PG9BC NULL NULL 0
2230487 sensor.linky_easf02 19734.625 NULL NULL NULL 2022-10-20 18:43:38 2230376 876480 01GFVBAHP276PJ6ADXFDKPPSME NULL NULL 0
2230376 sensor.linky_easf02 19734.569 NULL NULL NULL 2022-10-20 18:38:38 2230278 876480 01GFVB1CT7DHWT3KKMFYX6EER0 NULL NULL 0
2230278 sensor.linky_easf02 19734.468 NULL NULL NULL 2022-10-20 18:33:39 2230159 876480 01GFVAR8MDQT1Q57689R2DYWJJ NULL NULL 0
2230159 sensor.linky_easf02 19734.289 NULL NULL NULL 2022-10-20 18:28:38 2230066 876480 01GFVAF2RRVZ8EA795QE47N2B4 NULL NULL 0
SELECT * FROM `statistics_meta` WHERE `statistic_id` LIKE 'sensor.linky_easf0%'
id statistic_id source unit_of_measurement has_mean has_sum name
222 sensor.linky_easf01 recorder kWh 0 1 NULL
236 sensor.linky_easf01_cost recorder EUR 0 1 NULL
223 sensor.linky_easf02 recorder kWh 0 1 NULL
237 sensor.linky_easf02_cost recorder EUR 0 1 NULL
This one is interesting : according to states table sensor.linky_easf01 is not updated but looking at statistics_short_term, easf01 is decreasing !!!
SELECT * FROM `statistics_short_term` WHERE `metadata_id` = 222 ORDER BY `created` DESC
id created start mean min max last_reset state sum metadata_id
1716666 2022-10-20 20:45:15 2022-10-20 20:40:00 NULL NULL NULL NULL 10100.4 146.685 222
1716546 2022-10-20 20:40:16 2022-10-20 20:35:00 NULL NULL NULL NULL 10100.1 146.406 222
1716426 2022-10-20 20:35:16 2022-10-20 20:30:00 NULL NULL NULL NULL 10099.7 146.047 222
1716306 2022-10-20 20:30:16 2022-10-20 20:25:00 NULL NULL NULL NULL 10099.4 145.708 222
1716188 2022-10-20 20:25:16 2022-10-20 20:20:00 NULL NULL NULL NULL 10099.4 145.686 222
1716070 2022-10-20 20:20:16 2022-10-20 20:15:00 NULL NULL NULL NULL 10099.4 145.694 222
1715950 2022-10-20 20:15:16 2022-10-20 20:10:00 NULL NULL NULL NULL 10099.4 145.702 222
1715830 2022-10-20 20:10:16 2022-10-20 20:05:00 NULL NULL NULL NULL 10099.4 145.71 222
1715710 2022-10-20 20:05:16 2022-10-20 20:00:00 NULL NULL NULL NULL 10099.4 145.718 222
1715590 2022-10-20 20:00:16 2022-10-20 19:55:00 NULL NULL NULL NULL 10099.4 145.726 222
1715470 2022-10-20 19:55:16 2022-10-20 19:50:00 NULL NULL NULL NULL 10099.4 145.734 222
1715350 2022-10-20 19:50:16 2022-10-20 19:45:00 NULL NULL NULL NULL 10099.4 145.742 222
1715230 2022-10-20 19:45:16 2022-10-20 19:40:00 NULL NULL NULL NULL 10099.4 145.75 222
1715110 2022-10-20 19:40:16 2022-10-20 19:35:00 NULL NULL NULL NULL 10099.4 145.758 222
1714990 2022-10-20 19:35:16 2022-10-20 19:30:00 NULL NULL NULL NULL 10099.4 145.766 222
1714870 2022-10-20 19:30:16 2022-10-20 19:25:00 NULL NULL NULL NULL 10099.4 145.774 222
1714750 2022-10-20 19:25:16 2022-10-20 19:20:00 NULL NULL NULL NULL 10099.4 145.782 222
1714630 2022-10-20 19:20:16 2022-10-20 19:15:00 NULL NULL NULL NULL 10099.4 145.79 222
1714510 2022-10-20 19:15:16 2022-10-20 19:10:00 NULL NULL NULL NULL 10099.4 145.798 222
1714390 2022-10-20 19:10:16 2022-10-20 19:05:00 NULL NULL NULL NULL 10099.4 145.806 222
1714270 2022-10-20 19:05:16 2022-10-20 19:00:00 NULL NULL NULL NULL 10099.4 145.814 222
1714150 2022-10-20 19:00:16 2022-10-20 18:55:00 NULL NULL NULL NULL 10099.4 145.822 222
1714030 2022-10-20 18:55:16 2022-10-20 18:50:00 NULL NULL NULL NULL 10099.4 145.83 222
1713910 2022-10-20 18:50:16 2022-10-20 18:45:00 NULL NULL NULL NULL 10099.4 145.838 222
1713790 2022-10-20 18:45:16 2022-10-20 18:40:00 NULL NULL NULL NULL 10099.4 145.846 222
SELECT * FROM `statistics_short_term` WHERE `metadata_id` = 223 ORDER BY `created` DESC;
id created start mean min max last_reset state sum metadata_id
1716667 2022-10-20 20:45:15 2022-10-20 20:40:00 NULL NULL NULL NULL 19735.6 245.431 223
1716547 2022-10-20 20:40:16 2022-10-20 20:35:00 NULL NULL NULL NULL 19735.6 245.406 223
1716427 2022-10-20 20:35:16 2022-10-20 20:30:00 NULL NULL NULL NULL 19735.6 245.381 223
1716307 2022-10-20 20:30:16 2022-10-20 20:25:00 NULL NULL NULL NULL 19735.6 245.356 223
1716189 2022-10-20 20:25:16 2022-10-20 20:20:00 NULL NULL NULL NULL 19735.6 245.331 223
1716071 2022-10-20 20:20:16 2022-10-20 20:15:00 NULL NULL NULL NULL 19735.5 245.242 223
1715951 2022-10-20 20:15:16 2022-10-20 20:10:00 NULL NULL NULL NULL 19735.5 245.195 223
1715831 2022-10-20 20:10:16 2022-10-20 20:05:00 NULL NULL NULL NULL 19735.5 245.193 223
1715711 2022-10-20 20:05:16 2022-10-20 20:00:00 NULL NULL NULL NULL 19735.4 245.136 223
1715591 2022-10-20 20:00:16 2022-10-20 19:55:00 NULL NULL NULL NULL 19735.4 245.128 223
1715471 2022-10-20 19:55:16 2022-10-20 19:50:00 NULL NULL NULL NULL 19735.3 245.066 223
1715351 2022-10-20 19:50:16 2022-10-20 19:45:00 NULL NULL NULL NULL 19735.3 245.054 223
1715231 2022-10-20 19:45:16 2022-10-20 19:40:00 NULL NULL NULL NULL 19735.2 244.986 223
1715111 2022-10-20 19:40:16 2022-10-20 19:35:00 NULL NULL NULL NULL 19735.2 244.958 223
1714991 2022-10-20 19:35:16 2022-10-20 19:30:00 NULL NULL NULL NULL 19735.1 244.873 223
1714871 2022-10-20 19:30:16 2022-10-20 19:25:00 NULL NULL NULL NULL 19735.1 244.836 223
1714751 2022-10-20 19:25:16 2022-10-20 19:20:00 NULL NULL NULL NULL 19735 244.751 223
1714631 2022-10-20 19:20:16 2022-10-20 19:15:00 NULL NULL NULL NULL 19735 244.722 223
1714511 2022-10-20 19:15:16 2022-10-20 19:10:00 NULL NULL NULL NULL 19734.9 244.649 223
1714391 2022-10-20 19:10:16 2022-10-20 19:05:00 NULL NULL NULL NULL 19734.9 244.628 223
1714271 2022-10-20 19:05:16 2022-10-20 19:00:00 NULL NULL NULL NULL 19734.8 244.554 223
1714151 2022-10-20 19:00:16 2022-10-20 18:55:00 NULL NULL NULL NULL 19734.8 244.53 223
1714031 2022-10-20 18:55:16 2022-10-20 18:50:00 NULL NULL NULL NULL 19734.7 244.45 223
1713911 2022-10-20 18:50:16 2022-10-20 18:45:00 NULL NULL NULL NULL 19734.7 244.41 223
1713791 2022-10-20 18:45:16 2022-10-20 18:40:00 NULL NULL NULL NULL 19734.6 244.329 223
Trying to see if the proposed answer here do also work in my case.
https://github.com/home-assistant/core/issues/76973#issuecomment-1268400138