# Insight graphs **URL:** \ **Category:** Ideas & Suggestions\ **Created:** [March 23, 2019, 7:53am UTC](https://community.homey.app/t/insight-graphs/10939 "2019-03-23T07:53:03Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![Otter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/otter/32/11467_2.png) [@Otter](https://community.homey.app/u/Otter)\ **Post date:** [March 23, 2019, 7:53am UTC](https://community.homey.app/t/insight-graphs/10939/1 "2019-03-23T07:53:03Z")
very handy, Insights! realy usefull and a great idea! now perfect it by making some different styles of graphs. for example energy readings is just a spike in a graph, it is more usefull to see the total amount of energy used over a day or other period. the same goes for gas usage, just make a bar graph? ---
**Author:** ![Otter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/otter/32/11467_2.png) [@Otter](https://community.homey.app/u/Otter)\ **Post date:** [March 23, 2019, 8:48am UTC](https://community.homey.app/t/insight-graphs/10939/3 "2019-03-23T08:48:34Z")
well it could be, but want to hear your thoughts. most of the time ideas already been posted or discussed somewhere else. it is all just the same graph, anyone got more ideas for other devices registering crucial information? my plugwise P1 only records the total amount of energy over time and the actual energy consumed at the time, no days/weeks/months. the fibaro plugs do the same. ---
**Author:** ![Otter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/otter/32/11467_2.png) [@Otter](https://community.homey.app/u/Otter)\ **Post date:** [March 23, 2019, 10:43am UTC](https://community.homey.app/t/insight-graphs/10939/4 "2019-03-23T10:43:43Z")
Well it records it but i have to add everything in order to get a reading over a day or month. Would really like it to be a daily use kind of graph just like toon or the plugwise app for example ---
**Author:** ![PetervdK](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/petervdk/32/20669_2.png) [@PetervdK](https://community.homey.app/u/PetervdK)\ **Post date:** [March 24, 2019, 2:14pm UTC](https://community.homey.app/t/insight-graphs/10939/6 "2019-03-24T14:14:38Z")
> [@Otter](#): > > my plugwise P1 only records the total amount of energy over time and the actual energy consumed at the time, no days/weeks/months. > the fibaro plugs do the same. Not sure what you mean by that, but my Plugwise shows every possible graph i want. Hour, day, week, month, all of it. Or do you mean that Insights doesn’t record or shows that? ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/2X/6/65c4dc96c0bb312680dcc83062ebbe1e3a22d536.png) ---
**Author:** ![Otter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/otter/32/11467_2.png) [@Otter](https://community.homey.app/u/Otter)\ **Post date:** [March 24, 2019, 3:31pm UTC](https://community.homey.app/t/insight-graphs/10939/7 "2019-03-24T15:31:30Z")
Yes the plugwise app does it the way i like insights to show it. But with all statistics. Like fibaro plugs ---
**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 24, 2019, 3:46pm UTC](https://community.homey.app/t/insight-graphs/10939/8 "2019-03-24T15:46:33Z")
> [@\[APP\]\[Pro\] Archive Insights - export all your Insights data to a NAS, FTP or web folder](https://community.homey.app/t/export-insights-backup-all-your-insights-data-to-a-nas-or-web-folder/10976/3): > > I just uploaded the new Homey V2 compatible version of the Export Insights app to the appstore. After approval it will be available in the beta stream. The stable release will still be for Homey V1, but will eventually be deprecated. The new version allows you to store all Insights, or Insights of a specific app, to a network drive (NAS) or webDAV folder. It also includes Insights that you cannot get from Athoms Insights page! Please give me some feedback, so I can improve it even more before … With the exported .csv files you can use Excel to make any graph type you like. So also bar graphs 🙂 ---
**Author:** ![PetervdK](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/petervdk/32/20669_2.png) [@PetervdK](https://community.homey.app/u/PetervdK)\ **Post date:** [March 24, 2019, 3:49pm UTC](https://community.homey.app/t/insight-graphs/10939/9 "2019-03-24T15:49:18Z")
You’re right. That isn’t available in Insights indeed. ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/2X/c/ce67b8e60f28ee5850003a0e205cae923ecf5f54.png) ---
**Author:** ![Dusan\_Debeljak](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/dusan_debeljak/32/9650_2.png) [@Dusan\_Debeljak](https://community.homey.app/u/Dusan_Debeljak)\ **Post date:** [April 20, 2019, 4:54am UTC](https://community.homey.app/t/insight-graphs/10939/10 "2019-04-20T04:54:50Z")
Insights page is great but it is just not practical for quick overview of energy usage or temperature history for example on mobile. You need to close the app, open browser and them search for device to display the graph… So make graphs available under each device in the mobile App. Don’t know why this basic feature is not implememted. All the “mobile first” talk but in the end everything is scatered all over the place… ---
**Author:** ![Spijkmans](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/spijkmans/32/8617_2.png) [@Spijkmans](https://community.homey.app/u/Spijkmans)\ **Post date:** [April 23, 2019, 7:02pm UTC](https://community.homey.app/t/insight-graphs/10939/11 "2019-04-23T19:02:53Z")
I use insights quite frequently and it disturbs me that you can’t zoom-in, zoom-out, collate (two or more graphs in one), change scales etc. etc. I even have a graph with negative values and there is no line at the zero. Witch makes it hard to read. I used to have a Domoticz setup before moving to Homey. And Domoticz has way better graph capabilities. @Athom please take a look at Domoticz graphs and upgrade the capabilities of Homey Insights…! Please make the insights useful… Example of my negative graph: ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/2X/6/63af059f1ab92e4c98d0e939301a46a3cc97d07f.png) ---
**Author:** ![Jamie](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/jamie/32/5274_2.png) [@Jamie](https://community.homey.app/u/Jamie)\ **Post date:** [April 29, 2019, 7:13am UTC](https://community.homey.app/t/insight-graphs/10939/13 "2019-04-29T07:13:56Z")
As mentioned This is a community forum and your posts, questions and suggestions will not be read by Athom. You can read more about this here [Welcome to the forum.](https://community.homey.app/t/welcome-to-the-forum/31) For support or issue resolution, first have a look at [https://support.athom.com](https://support.athom.com/) and if you cant find an answer there then you create a new ticket here [https://support.athom.com/hc/requests/new](https://support.athom.com/hc/requests/new). If you need help in how to create a support request you can find more information [here](https://support.athom.com/hc/en-us/articles/360015784034-Submit-a-support-request). ---
**Author:** ![Otter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/otter/32/11467_2.png) [@Otter](https://community.homey.app/u/Otter)\ **Post date:** [August 20, 2019, 12:34pm UTC](https://community.homey.app/t/insight-graphs/10939/14 "2019-08-20T12:34:12Z")
insight graphs and value are less accurate over time, when looking at one day the values are correct, viewing the same reading in a weekly graph the value is less. so over time it will be less accurate. contacted Athom with this fact but they say they won’t do anything about it. if you want accurate readings you can export the data yourself. ---
**Author:** ![ArnoP](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/arnop/32/13709_2.png) [@ArnoP](https://community.homey.app/u/ArnoP)\ **Post date:** [August 20, 2019, 12:47pm UTC](https://community.homey.app/t/insight-graphs/10939/15 "2019-08-20T12:47:31Z")
This was changed to prevent storage problems by storing unlimited amounts of data from a lot of sensors (potentially). Besides Athom says you don’t really need the information from a certain sensor from 6 months back at 14:05 (which to me also makes sense). Then again: it would be nice to have some kind of an automatic export so the data is available once you do decide you need it… ---
**Author:** ![Fabien\_Schmitz](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fabien_schmitz/32/8472_2.png) [@Fabien\_Schmitz](https://community.homey.app/u/Fabien_Schmitz)\ **Post date:** [August 21, 2019, 8:14am UTC](https://community.homey.app/t/insight-graphs/10939/16 "2019-08-21T08:14:15Z")
in my case i use the insights for electricity and “mysterious” spikes are lost in longer than 6 hour export, because of “averaging” of the data. So i’d like to see them in for example a week or month overview. it would be handy data to see if i can relate it to a certain device, when did they start etc how many times a day pattern etc. so an automatic hour export to file , server , etc would be very handy. Now i run the metering through domoticz where I can see this data. but this way i need an extra device …☹ ---
**Author:** ![Otter](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/otter/32/11467_2.png) [@Otter](https://community.homey.app/u/Otter)\ **Post date:** [August 21, 2019, 8:29am UTC](https://community.homey.app/t/insight-graphs/10939/17 "2019-08-21T08:29:52Z")
Same problem here, its worth nothing like that. I don’t like the fact I have to export them myself turning it in to a graph. I paid 400 euros for a pcb with some antennas and a plastic shell. Most of the community makes the software so what does a few kilobytes do to a server. Just store the damn data ---
**Author:** ![Fabien\_Schmitz](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fabien_schmitz/32/8472_2.png) [@Fabien\_Schmitz](https://community.homey.app/u/Fabien_Schmitz)\ **Post date:** [August 21, 2019, 9:43am UTC](https://community.homey.app/t/insight-graphs/10939/18 "2019-08-21T09:43:16Z")
well i might be wrong, but I think all the data is stored in the homey. because of privacy etc… and the insights retrieves this from your homey? so in that case if you have a lot of analog sensors with high update rate and run it for some time… it might become a storage issue ---
**Author:** ![robertklep](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/robertklep/32/160628_2.png) [@robertklep](https://community.homey.app/u/robertklep)\ **Post date:** [August 21, 2019, 9:45am UTC](https://community.homey.app/t/insight-graphs/10939/19 "2019-08-21T09:45:27Z")
> [@Fabien\_Schmitz](#): > > I think all the data is stored in the homey. because of privacy etc… and the insights retrieves this from your homey? That is correct. ---
**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:** [August 21, 2019, 10:56am UTC](https://community.homey.app/t/insight-graphs/10939/20 "2019-08-21T10:56:12Z")
Just use [https://apps.athom.com/app/com.gruijter.insights2csv](https://apps.athom.com/app/com.gruijter.insights2csv) You can schedule an export via flowcard every hour 😚 ---
**Author:** ![bob\_schijvenaars](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/bob_schijvenaars/32/34710_2.png) [@bob\_schijvenaars](https://community.homey.app/u/bob_schijvenaars)\ **Post date:** [June 24, 2022, 4:29pm UTC](https://community.homey.app/t/insight-graphs/10939/21 "2022-06-24T16:29:29Z")
Indeed, when viewing more than “the last hour” these oscillations make the graph completely noninformative. A simple moving average would increase its readability significantly. ---
**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\ **Post date:** [June 25, 2022, 7:25pm UTC](https://community.homey.app/t/insight-graphs/10939/22 "2022-06-25T19:25:49Z")
Or export the needed sensor values to a SQL database. Check the examples if it fits to your needs. This way you can react on a sensor change and export it with a INSERT Sql statement in the flow THEN part using current time and date as additional columns. > [@\[APP\]\[PRO\] MySQL-Client](https://community.homey.app/t/app-pro-mysql-client/62459): > > [[small]](https://homey.app/de-de/app/de.ronnywinkler.mysql/MySQL/) A MySQL client for Homey Add this app to use SQL queries in Homey to read or write datasets from/to a local MySQL compatible database. The app provides a driver/device to connect to a database server and one of its databases. The following flow actions can be used from this device: SELECT a dataset with a SQL query (read periodical logged values to use in Homey). UPDATE/INSERT lines using global tokens (log device capabilities to your database). The following flow triggers can …