# Insights to energy use **URL:** \ **Category:** Questions & Help\ **Created:** [July 26, 2022, 5:25pm UTC](https://community.homey.app/t/insights-to-energy-use/66544 "2022-07-26T17:25:18Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![David\_Granath](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/david_granath/32/29967_2.png) [@David\_Granath](https://community.homey.app/u/David_Granath)\ **Post date:** [July 26, 2022, 5:25pm UTC](https://community.homey.app/t/insights-to-energy-use/66544/1 "2022-07-26T17:25:18Z")
Trying to analyze my energy use last year on my radiators. In “energy” I can only see real time usage. In “insights” I can see the usage over time but in that graph I don’t see the total energy use over time. If I export as csv and look at the file I see a logged wattage use but the time stamps looks like every 6th hour. How should I read that? If it says 1200W is that then per hour those 6 hours. Or a total over that period? Would of course be great to get a bit more options directly in insights but exporting is fine if I can just figure out what I’m seeing. Thankful for any help. David ---
**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:** [July 26, 2022, 5:38pm UTC](https://community.homey.app/t/insights-to-energy-use/66544/2 "2022-07-26T17:38:02Z")
Probably a bit of a sidetrack, but I created this app because of my frustration on the lack of usefull energy insights: > **[Power by the Hour](https://homey.app/en-gb/app/com.gruijter.powerhour/Power-by-the-Hour/)** > > Summarize the energy/water usage or (solar) production per hour, day, month and year. Use dynamic tariffs. ---
**Author:** ![David\_Granath](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/david_granath/32/29967_2.png) [@David\_Granath](https://community.homey.app/u/David_Granath)\ **Post date:** [July 26, 2022, 6:12pm UTC](https://community.homey.app/t/insights-to-energy-use/66544/3 "2022-07-26T18:12:12Z")
Thanks. I saw that, I tried to download it but I guess I can only see future use, after installation right? I can’t see historical use using the app? ---
**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:** [July 26, 2022, 6:15pm UTC](https://community.homey.app/t/insights-to-energy-use/66544/4 "2022-07-26T18:15:21Z")
Correct ---
**Author:** ![David\_Granath](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/david_granath/32/29967_2.png) [@David\_Granath](https://community.homey.app/u/David_Granath)\ **Post date:** [July 26, 2022, 6:41pm UTC](https://community.homey.app/t/insights-to-energy-use/66544/5 "2022-07-26T18:41:49Z")
No idea on how to read the csv? I’m getting this as an example. The values with a period instead of comma is not read as numbers. And not sure how to read the dates that span 6 hours on each row. Is the value a total for 6 or an average per hour during those 6? ![Skärmavbild 2022-07-26 kl. 20.37.37](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/8/6/861a268e1afe53a6a17e83954ad54556e4728f66.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:** [July 26, 2022, 7:15pm UTC](https://community.homey.app/t/insights-to-energy-use/66544/6 "2022-07-26T19:15:56Z")
It is the average over the 6 hours. If you e.g. select 2 years Insights the values are averaged over an even longer period. If you select last hour you get the average over each 5 seconds. The averaging is done to limit the storage space that is needed for Insights. Before Athom introduced this compression strategy the Insights logs would grow until Homey crashed…