iINDIGOplotD: how to plot consumption

Posted on
Tue Aug 01, 2017 11:12 am
kw123 offline
User avatar
Posts: 5523
Joined: May 12, 2013
Location: Dallas, TX

iINDIGOplotD: how to plot consumption

if you want to plot e.g. the consumed power[watt hour] (= consumed energy in indigo terms ) over time and start at 0 every day / week/month/ year this is how you do it:

1. define your source:
in
Screen Shot 2017-08-01 at 11.49.58.png
Screen Shot 2017-08-01 at 11.49.58.png (15.22 KiB) Viewed 1770 times

you select the device and set:
Screen Shot 2017-08-01 at 11.47.03.png
Screen Shot 2017-08-01 at 11.47.03.png (45.59 KiB) Viewed 1770 times
to e.g. reset every day (options are day, week, months, year and "period"; you can define any time period (e.g. 5/5/2017 - 10/9/2018 which does not make sense .. but you can set 10+ + periods )m In addition to just adding this up you can also define cost per hour on a day / week / period. in the section at the end . Then you could show cost in $.

2. create a plot device, e.g. consumed power daily
- in the top section
=reset the x,y limits and set the descriptions as you like
=click confirm
- in the bottom section
= add new line
= select the data source you just created
= select line type eg solid line or histogram
= click confirm
= if you can see the indigo server screen you can enable experts tools and click on update and after 5 secs click on show.


Will add some more screen shots. unfortunately my energy meter is not working well. It has a bad z-wave connection and only updates when I push it . So i don't have nice data to show. .. one of the many things left to d.

Karl

Posted on
Tue Aug 01, 2017 12:26 pm
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

I have looked at these examples, but I can not find the menus where I can check the expert mode on/off for advanced parameters.

Posted on
Tue Aug 01, 2017 12:57 pm
kw123 offline
User avatar
Posts: 5523
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

in device edit at the top,
but you only need this for "update" and "show"
Attachments
Screen Shot 2017-08-01 at 13.56.05.png
Screen Shot 2017-08-01 at 13.56.05.png (52.48 KiB) Viewed 1740 times

Posted on
Tue Aug 01, 2017 1:26 pm
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

Yes I find the Expert tool in Configure plots window but not in the plugin-Configure menu as several screenshots show.

Posted on
Tue Aug 01, 2017 2:40 pm
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

Sorry I have installed an old version.

Posted on
Tue Aug 01, 2017 5:14 pm
kw123 offline
User avatar
Posts: 5523
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption


Posted on
Wed Aug 02, 2017 11:14 am
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

Thanks
How can I change time in sqlite databases table to local time on my mac?

Posted on
Wed Aug 02, 2017 5:28 pm
kw123 offline
User avatar
Posts: 5523
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

That's how indigo writes it to the dB.
But indigo plotd converts the dates to local time. At least it should.




Sent from my iPhone using Tapatalk

Posted on
Wed Aug 02, 2017 5:29 pm
kw123 offline
User avatar
Posts: 5523
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

I can send you the sql string how to convert.


Sent from my iPhone using Tapatalk

Posted on
Fri Aug 04, 2017 11:12 am
pcbiti offline
Posts: 6
Joined: Jun 07, 2017

Re: iINDIGOplotD: how to plot consumption

Thanks it seems to works now, but please send the sql string.
I have made a plot and it seems to work very well. Thanks for the support.

Posted on
Fri Aug 04, 2017 1:58 pm
kw123 offline
User avatar
Posts: 5523
Joined: May 12, 2013
Location: Dallas, TX

Re: iINDIGOplotD: how to plot consumption

this is the simplified SQL statement used inindigoplot d to get state avgSpeed from device id=375541516

Code: Select all
/usr/bin/sqlite3 -separator ";" indigo_history.sqlite " SELECT id, strftime('%Y%m%d%H%M%S',ts,'localtime') ,avgSpeed from device_history_375541516 WHERE  ID > 0  LIMIT 10000000;"   > /Users/karlwachs/Documents/INDIGOplotD/sql/375541516-avgSpeed.sqlOut


with ID (seq id of sql data) limited and # of lines limit output to /Users/karlwachs/Documents/INDIGOplotD/sql/375541516-avgSpeed.sqlOut

Karl

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 1 guest