Energy Meter Graphs

Could you post your plot definition ( menu/ print plot device etc to logfile )
Also how do you reset the energy numbers?





Sent from my iPhone using Tapatalk

So regardless of a value being in the variable currently it pulls it from the SQL ...So I should see something tonight after 11:59 when it dumps and if not by morning then I can assume it isn't working

I am using a schedule to pass it to the variable

Code: Select all

    DevNo, Name, ID                State                 Measurement               offset   multipl  minValue  maxValue  ColfilGps   resetType                                     ---  nickName
  1 Meter Total                   ok: 1
    # 1   Dev-ID: 96524156        accumEnergyTotal      eConsumption                 0.0       1.0    -200.0   50000.0    1     1       month                     MeterTotal-Energy-eCons-month
    # 2                           accumEnergyTotal      eConsumption                 0.0       1.0    -200.0   50000.0    2     1   dayNoCost                 MeterTotal-Energy-eCons-dayNoCost
    # 3                           accumEnergyTimeDelta  eConsumption                 0.0       1.0    -200.0   50000.0    3     1       month                     MeterTotal-Energy-eCons-month
    # 4                           accumEnergyTotal      average                      0.0       1.0    -200.0   50000.0    4     1           0                         MeterTotal-Energy-average
  2 ePower                        ok: 1
    # 1   Var-ID: 533365995       value                 average                      0.0       1.0    -200.0   50000.0    5     1           0                                             Power
  3 eEnergyToday                  ok: 1
    # 1   Var-ID: 922181233       value                 average                      0.0       1.0    -200.0   50000.0    6     1           0                          Var-eEnergyToday-average
  4 eEnergyYesterday              ok: 1
    # 1   Var-ID: 900915956       value                 average                      0.0       1.0    -200.0   50000.0    7     1                                           Var-EnergyYesterday
  INDIGOplotD                     
  INDIGOplotD                     Index list for dataColumn to Device#/State#
  INDIGOplotD                     Column=Dev#/St#    Column=Dev#/St#    Column=Dev#/St#    Column=Dev#/St#    Column=Dev#/St#   
  INDIGOplotD                          1=   1/  1         2=   1/  2         3=   1/  3         4=   1/  4         5=   2/  1   
  INDIGOplotD                          6=   3/  1         7=   4/  1   
  INDIGOplotD                     
  INDIGOplotD                     
  INDIGOplotD                     Consumption Cost data;    type gConsumption WeekDay
  INDIGOplotD                      ...not defined
  INDIGOplotD                     Consumption Cost data;    type wConsumption WeekDay
  INDIGOplotD                      ...not defined
  INDIGOplotD                     Consumption Cost data;    type eConsumption WeekDay
  INDIGOplotD                      ...not defined
  INDIGOplotD                     Consumption Cost data;    type oConsumption WeekDay
  INDIGOplotD                      ...not defined


it looks as if there is no data for last month.
When did you switch on SQLlogging? SQL LOGGINF+G is storing the data over time. if it is not ON, no changes of anything is remembered.
Only from that point (SQLlogging switched on) data exists.

also please print menu/print plot config


Karl

Today want sure if it accumulates off the variable

Code: Select all

  INDIGOplotD                     pending indigoCommands: ['PrintPlotData:779545848']
  PLOT:: EnergyHistory            deviceID: 779545848
  ...Background                   >>#FFFFFF<<
  ...Border                       >>1+2+4+8<<
  ...DeviceNamePlot               >>EnergyHistory<<
  ...ExtraText                    >><<
  ...ExtraTextColorRGB            >>#000000<<
  ...ExtraTextFrontBack           >>front<<
  ...ExtraTextRotate              >>0.0<<
  ...ExtraTextSize                >>22<<
  ...ExtraTextXPos                >>0.0<<
  ...ExtraTextYPos                >>0.0<<
  ...Grid                         >>1<<
  ...LeftLabel                    >>Energy (KWhrs)<<
  ...LeftLog                      >>linear<<
  ...LeftScaleDecPoints           >>0<<
  ...LeftScaleRange               >>00:70<<
  ...LeftScaleTics                >>10,20,30,40,50,60<<
  ...MHDDays                      >>[0, 0, 31]<<
  ...MHDShift                     >>[0, 0, 0]<<
  ...NumberIsUsed                 >>1<<
  ...PlotFileLastUpdate           >>0<<
  ...PlotFileOrVariName           >><<
  ...PlotType                     >>dataFromTimeSeries<<
  ...Raw                          >><<
  ...RightLabel                   >><<
  ...RightLog                     >>linear<<
  ...RightScaleDecPoints          >>0<<
  ...RightScaleRange              >><<
  ...RightScaleTics               >><<
  ...TextColor                    >>#FFA500<<
  ...TextFont                     >>Verdana.ttf<<
  ...TextMATFont                  >>sans-serif<<
  ...TextSize                     >>22<<
  ...Textscale21                  >>1.0<<
  ...TitleText                    >>Previous Month's Energy Usage<<
  ...TransparentBackground        >>0.0<<
  ...TransparentBlocks            >>1.0<<
  ...XLabel                       >>x-axis Text<<
  ...XLog                         >>linear<<
  ...XScaleDecPoints              >>0<<
  ...XScaleFormat                 >><<
  ...XScaleRange                  >><<
  ...XScaleTics                   >><<
  ...XYvPolar                     >>xy<<
  ...ampm                         >>24<<
  ...compressPNGfile              >>False<<
  ...dataSource                   >>interactive<<
  ...drawZeroLine                 >>True<<
  ...resxy                        >>['', u'1600,1200']<<
  ...variableInText               >><<
  ...variableinPlot               >><<
  -l# 1/                          Color>#FFA500<; EveryRepeat>1<; Func>None<; LeftRight>Left<; Multiplier>1.0<; NumbersFormat><; NumbersOffset><; Offset>0.0<; Shift>0<; Smooth>None<; ToColumnIndexA>7<; ToColumnIndexB>0<; Type>Histogram1<; Width>3<
  INDIGOplotD                     

Very cool!

May I ask you where you have the icons from and how did you made the grid for them on the left side?

I had previously found a bunch of free icons on various websites that I downloaded and have used. It has been a while since I had done this so I cannot provide any pedigree for the icons. The grid on the left was all done manually by carefully creating the individual page images in a graphics program to make sure that the grid was all well aligned. I had given a lot of thought (OK, slightly more than 10 minutes) on how I had wanted to sequence between my various pages and ended up with this scheme. Usually when you go to a different page there is another/different icon on the left in the same spot which provides a degree of sub-pages for the particular set of commands.

the plot definition looks good. next you should check:

~/documents/indigoplotd/data/hour.data.formatted
scroll to the bottom. you can see how much data is available. the first column is the date-stamp the next is a control# then the data columns.
You can't show more data than is in THAT file if you have SQLlogger enabled.

so if there is only 1 day of data, you just have to wait until you accumulate data

Karl