# \[APP\]\[Pro\] Power by the Hour: Insights per hour, day, month and year **URL:** \ **Category:** Apps\ **Tags:** app, tools\ **Created:** [November 10, 2019, 10:06pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535 "2019-11-10T22:06:03Z")\ **Posts on this page:** 20\ **Page:** 146
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [March 11, 2025, 7:43pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2961 "2025-03-11T19:43:48Z")
The PbtH JSON file, with the data of your provider, was still OKÉ this morning. This one is for ZP As in variable putting in this morning. ```auto {"0":0.2646,"1":0.261,"2":0.2609,"3":0.2607,"4":0.2604,"5":0.2681,"6":0.254,"7":0.3111,"8":0.3105,"9":0.2946,"10":0.2657,"11":0.2593,"12":0.2568,"13":0.2575,"14":0.2615,"15":0.2717,"16":0.2875,"17":0.3115,"18":0.3496,"19":0.3482,"20":0.3182,"21":0.3012,"22":0.2849,"23":0.2721} ``` Later it is over written. Direct by card "Provide price JSON ‘this day’ ". ```auto {"0":0.2594,"1":0.2594,"2":0.2594,"3":0.2594,"4":0.2594,"5":0.2594,"6":0.2594,"7":0.2594,"8":0.2594,"9":0.2594,"10":0.2594,"11":0.2594,"12":0.2594,"13":0.2594,"14":0.2594,"15":0.2594,"16":0.2594,"17":0.2594,"18":0.2594,"19":0.2594,"20":0.2594,"21":0.2594,"22":0.2594,"23":0.2594} ``` ---
**Author:** ![Theo\_de\_Koning](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/theo_de_koning/32/136062_2.png) [@Theo\_de\_Koning](https://community.homey.app/u/Theo_de_Koning)\ **Post date:** [March 11, 2025, 8:48pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2962 "2025-03-11T20:48:57Z")
The JSON data for tomorrow is al available. That’s go here in a variable. “tomorrow” On 00:00 I switch that to the variable “today”. Looking to use really that file now I found that I was further than I thought. Now only linking the successful lose tests together. ---
**Author:** ![Geert1992](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/geert1992/32/121041_2.png) [@Geert1992](https://community.homey.app/u/Geert1992)\ **Post date:** [March 13, 2025, 10:26am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2963 "2025-03-13T10:26:03Z")
![1](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/9/d/9dbdfb308ee3feba0bdc54dc0340064812e910b3.png) I’m getting more and more troubles with the battery monitor inside the PBTH app. For the past few days, it no longer shows when it is charging the batteries. This is an example from today. Previously, it would indicate in green which hours it was going to charge. I tried restarting the app serveral times, and changing the minimum price difference. Without succes. ---
**Author:** ![Nogdose](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/nogdose/32/16576_2.png) [@Nogdose](https://community.homey.app/u/Nogdose)\ **Post date:** [March 14, 2025, 4:40pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2964 "2025-03-14T16:40:00Z")
Yes… i have defined a fixed monthly cost, in addition to the fixed tariff per KWh. Rechecked the graphs and if selected today last 14 days graph, the peak goes to correct place, beginning of the month with correct value… In longer timespan the graph somehow averages values incorrectly . ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/4/6/46e6e307d23c7d1e7768aabaf90e916dc7b1bcd0.png) ---
**Author:** ![Gruijter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/gruijter/32/1973_2.png) [@Gruijter](https://community.homey.app/u/Gruijter)\ **Post date:** [March 14, 2025, 5:33pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2965 "2025-03-14T17:33:47Z")
> [@Nogdose](#): > > longer timespan the graph somehow averages values incorrectly That is how Homey Insights ‘compresses’ older data. ---
**Author:** ![MHanaes](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mhanaes/32/47950_2.png) [@MHanaes](https://community.homey.app/u/MHanaes)\ **Post date:** [March 14, 2025, 9:11pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2966 "2025-03-14T21:11:13Z")
@Gruijter Im having issues with the daily average price value dropping to zero every day at 13:00. Known issue? I believe the issue startet to appear 6.march. ![IMG_7869](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/8/78b524e2293ea7fb71094d4c2186a2276c680fb6.jpeg) ![IMG_7868](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/3/5/35836eea70301aa061164637964bcd44a708b72c.jpeg) ---
**Author:** ![KungWaz](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/kungwaz/32/56612_2.png) [@KungWaz](https://community.homey.app/u/KungWaz)\ **Post date:** [March 14, 2025, 11:22pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2967 "2025-03-14T23:22:30Z")
Is there an easy way to get the daily power peak, the hour with the highest (maximum) power in kW? ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [March 15, 2025, 1:24am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2968 "2025-03-15T01:24:31Z")
Something like this. I created 2 variables, one to store the highest kWh and one to store a timestamp: - kWh: a numeric var called `highest_kWh_hour_today` - timestamp: a string var called `highest_kWh_hour_time_today` ### Flow 1 Every hour, check if the power summariser’s [kWh prev. hour] tag value, is greater than `[highest_kWh_hour_today]` value; If so, - save the [kWh prev. hour] tag value to `[highest_kWh_hour_today]` - save the current time to `[highest_kWh_hour_time_today]` ![1000045245](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/f/c/fc0d21d67281ff24bdb0d474bf6d32a7a1ee2d51.jpeg) ### Flow 2 At midnight, send the values, and next, reset both variables _after_ sending: ![1000045249](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/a/6/a6ceb91f51f6e43dcd843789196b177b7939dfd3.jpeg) Note _I use 1 minute delays to give the app some slack to change the hourly values for the kWh prev. hour tag._ ---
**Author:** ![KungWaz](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/kungwaz/32/56612_2.png) [@KungWaz](https://community.homey.app/u/KungWaz)\ **Post date:** [March 15, 2025, 5:46am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2969 "2025-03-15T05:46:16Z")
Thanks, that makes sense, I did something similar but was using the power, which would be wrong since it needs to be, as you have done, the total kWh over one whole hour. Any ideas on how to get the three highest hours of the month? That is how the power tariff here is calculated, the average of the three highest hours. Should I have a script that runs at the end of every month or three variables that are updated every hour, similar to the solution above? ---
**Author:** ![Rrrr](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/rrrr/32/629_2.png) [@Rrrr](https://community.homey.app/u/Rrrr)\ **Post date:** [March 15, 2025, 9:53am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2970 "2025-03-15T09:53:50Z")
Anybody else not getting spot price updates for the past 4 hours (Estonia)? ---
**Author:** ![Torch1969](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/torch1969/32/33305_2.png) [@Torch1969](https://community.homey.app/u/Torch1969)\ **Post date:** [March 15, 2025, 10:08am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2971 "2025-03-15T10:08:39Z")
Works alright here (NL) ---
**Author:** ![Rrrr](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/rrrr/32/629_2.png) [@Rrrr](https://community.homey.app/u/Rrrr)\ **Post date:** [March 16, 2025, 10:03am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2972 "2025-03-16T10:03:39Z")
Working again as of yesterday afternoon soon after my post, thanks ---
**Author:** ![Mats\_Nygren](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mats_nygren/32/17266_2.png) [@Mats\_Nygren](https://community.homey.app/u/Mats_Nygren)\ **Post date:** [March 18, 2025, 1:23pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2973 "2025-03-18T13:23:55Z")
Hi, Is there a way to use PBTH to measure negative energy ( exported energy) of Easee equalizer? If yes, how? ---
**Author:** ![DirkH](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/dirkh/32/78952_2.png) [@DirkH](https://community.homey.app/u/DirkH)\ **Post date:** [March 18, 2025, 2:11pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2974 "2025-03-18T14:11:32Z")
Hi Mats, > [@Mats\_Nygren](#): > > Hi, Is there a way to use PBTH to measure negative energy yes - just create a virtual device and link it to the negative value of power of your energy device by flows (When original#power changed and original#power\<0, then virtual#power= {{ - original#power }}. Then you can us PBTH for the (positive) exported power. But do not add the virtual device to the energy consumption 🤣 regards Dirk ---
**Author:** ![Mats\_Nygren](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mats_nygren/32/17266_2.png) [@Mats\_Nygren](https://community.homey.app/u/Mats_Nygren)\ **Post date:** [March 18, 2025, 3:11pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2975 "2025-03-18T15:11:58Z")
Thanks, but i dont get the "and"options you described when i´m create a flow 🙄 ---
**Author:** ![DirkH](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/dirkh/32/78952_2.png) [@DirkH](https://community.homey.app/u/DirkH)\ **Post date:** [March 18, 2025, 3:47pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2976 "2025-03-18T15:47:37Z")
Unfortunately my flow is in German ![exported energy](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/0/3/030d65eed23c703d0ece22bb62cc82f6b9e8e2c9.png) I hope you can understand. You find the #power (German ‘#Leistung’) in the _When…_ card and then you can use it in the _Logica_ card, but only after you have connected the _And_ card to the _When_ card. ---
**Author:** ![Mats\_Nygren](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/mats_nygren/32/17266_2.png) [@Mats\_Nygren](https://community.homey.app/u/Mats_Nygren)\ **Post date:** [March 18, 2025, 5:14pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2977 "2025-03-18T17:14:02Z")
Hmm…this was a tricky one. Both because of the language and my low knowledge of Homey 😂 have to try Thanks! ---
**Author:** ![Carlo\_Veraart1](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/carlo_veraart1/32/120889_2.png) [@Carlo\_Veraart1](https://community.homey.app/u/Carlo_Veraart1)\ **Post date:** [March 18, 2025, 9:24pm UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2978 "2025-03-18T21:24:38Z")
In my Homey is Zlinky activated and working… No data is arriving from this ‘french’ version of the P1 powermeter… Is the Zlinky NOT compatible with this? Many thanks for your quick reply (used app for Zlinky is LiXee. ---
**Author:** ![Peter\_Kawa](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/peter_kawa/32/173848_2.png) [@Peter\_Kawa](https://community.homey.app/u/Peter_Kawa)\ **Post date:** [March 19, 2025, 1:19am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2979 "2025-03-19T01:19:19Z")
Hi Carlo, Did you add a “Power summarizer” device already? > ![1000045340](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/3/8302ffa2680302e7f0d7b239f82fd2aa21931ed7.jpeg) ---
**Author:** ![Carlo\_Veraart1](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/carlo_veraart1/32/120889_2.png) [@Carlo\_Veraart1](https://community.homey.app/u/Carlo_Veraart1)\ **Post date:** [March 19, 2025, 5:59am UTC](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535/2980 "2025-03-19T05:59:17Z")
Hello, thanks for your reaction! Yes of course the ‘Power Summarizer’ was added. And the Zlinky\_Tic was recognised immediately. But it stops there. The Zlinky\_Tic itselfs shows the actual consommation, but in ‘Power by the hour’ there is nothing… [Previous page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=145) [Next page](https://community.homey.app/t/app-pro-power-by-the-hour-insights-per-hour-day-month-and-year/20535.md?page=147)