daily

loading or somthing wrong.
graph: ymax=300
graph: ymin=0
graph: x="Date"
graph: device="a-2"
graph: y-0="ave",color="yellow"
graph: device="a-1"
graph: y-1="ave", color="cyan"
graph: device="a-0"
graph: y-2="ave",color="red"
command: set readInterval=3600000
command: program daily
program: dim dataTable
program: dim columnLabel
program: dim rowLabel
program: output=""
program: url="http://www.yama-lab.org/adk-wiki-1/index.php?pir-1-"
program: for i=0 to 23
program:   page=ex("connector" , "getpage "+url+i)
program:   rpart=getResultPart(page)
program:   ex("service","println "+rpart)
program:   parseCsv(rpart,dataTable,rowLabel,columnLabel)
program:   y0=sumif(dataTable,rowLabel,columnLabel("device"),"=","a-0",columnLabel("sdv"))
program:   c0=countif(dataTable,rowLabel,columnLabel("device"),"=","a-0")
program:   ave0=1.0*y0/c0
program:   dataline="device=a-0, Date="+dataTable(0,columnLabel("Date"))+",ave="+ave0
program:   ex("service","println "+dataline)
program:   ex("service","putSendBuffer "+dataline)
program:   y1=sumif(dataTable,rowLabel,columnLabel("device"),"=","a-1",columnLabel("v"))
program:   c1=countif(dataTable,rowLabel,columnLabel("device"),"=","a-1")
program:   ave1=1.0*y1/c1
program:   dataline="device=a-1, Date="+dataTable(0,columnLabel("Date"))+",ave="+ave1
program:   ex("service","println "+dataline)
program:   ex("service","putSendBuffer "+dataline)
program:   y2=sumif(dataTable,rowLabel,columnLabel("device"),"=","a-2",columnLabel("v"))
program:   c2=countif(dataTable,rowLabel,columnLabel("device"),"=","a-2")
program:   ave2=1.0*y2/c2
program:   dataline="device=a-2, Date="+dataTable(0,columnLabel("Date"))+",ave="+ave2
program:   ex("service","println "+dataline)
program:   ex("service","putSendBuffer "+dataline)
program: ' ex("service","sendResults.")
program: next i
program: ex("service","sendResults.")
command: end daily
command: set pageName="daily-1-<day>"
command: set result=""
command: run daily
result:
device=a-0, Date=2013/3/22/ 23:41:24,ave=33.278748260028145
device=a-1, Date=2013/3/22/ 23:41:24,ave=291.625
device=a-2, Date=2013/3/22/ 23:41:24,ave=284.1333333333333
device=a-0, Date=2013/3/23/ 0:41:24,ave=33.18264069855129
device=a-1, Date=2013/3/23/ 0:41:24,ave=279.4375
device=a-2, Date=2013/3/23/ 0:41:24,ave=282.625
device=a-0, Date=2013/3/23/ 1:42:58,ave=33.28626978590734
device=a-1, Date=2013/3/23/ 1:42:58,ave=268.375
device=a-2, Date=2013/3/23/ 1:42:58,ave=274.1875
device=a-0, Date=2013/3/23/ 2:43:10,ave=33.30158351725385
device=a-1, Date=2013/3/23/ 2:43:10,ave=270.9375
device=a-2, Date=2013/3/23/ 2:43:10,ave=275.8125
device=a-0, Date=2013/3/23/ 3:43:20,ave=33.41349419240419
device=a-1, Date=2013/3/23/ 3:43:20,ave=280.9375
device=a-2, Date=2013/3/23/ 3:43:20,ave=281.625
device=a-0, Date=2013/3/23/ 4:43:34,ave=33.165255483604284
device=a-1, Date=2013/3/23/ 4:43:34,ave=275.25
device=a-2, Date=2013/3/23/ 4:43:34,ave=278.25
device=a-0, Date=2013/3/23/ 5:43:44,ave=32.98775159555443
device=a-1, Date=2013/3/23/ 5:43:44,ave=272.6875
device=a-2, Date=2013/3/23/ 5:43:44,ave=278.25
device=a-0, Date=2013/3/23/ 6:43:55,ave=76.37400566222178
device=a-1, Date=2013/3/23/ 6:43:55,ave=304.1875
device=a-2, Date=2013/3/23/ 6:43:55,ave=311.375
device=a-0, Date=2013/3/23/ 6:53:10,ave=99.03960726342129
device=a-1, Date=2013/3/23/ 6:53:10,ave=339.125
device=a-2, Date=2013/3/23/ 6:53:10,ave=344.9375
device=a-0, Date=2012/12/24/ 8:50:8,ave=43.750459160435085
device=a-1, Date=2012/12/24/ 8:50:8,ave=210.26315789473685
device=a-2, Date=2012/12/24/ 8:50:8,ave=155.26315789473685
device=a-0, Date=2012/12/24/ 9:40:49,ave=45.31456243565969
device=a-1, Date=2012/12/24/ 9:40:49,ave=182.0625
device=a-2, Date=2012/12/24/ 9:40:49,ave=152.75
device=a-0, Date=2012/12/24/ 11:16:50,ave=32.276862023694584
device=a-1, Date=2012/12/24/ 11:16:50,ave=119.92592592592592
device=a-2, Date=2012/12/24/ 11:16:50,ave=157.55555555555554
device=a-0, Date=2013/4/4/ 12:42:31,ave=79.16323893020667
device=a-1, Date=2013/4/4/ 12:42:31,ave=103.25
device=a-2, Date=2013/4/4/ 12:42:31,ave=161.0
device=a-0, Date=2013/4/4/ 12:51:13,ave=74.4959162431498
device=a-1, Date=2013/4/4/ 12:51:13,ave=109.70588235294117
device=a-2, Date=2013/4/4/ 12:51:13,ave=161.7058823529412
device=a-0, Date=2013/4/4/ 13:46:34,ave=84.87889019818633
device=a-1, Date=2013/4/4/ 13:46:34,ave=109.875
device=a-2, Date=2013/4/4/ 13:46:34,ave=161.8125
device=a-0, Date=2013/4/4/ 14:46:36,ave=55.125457253769426
device=a-1, Date=2013/4/4/ 14:46:36,ave=109.6875
device=a-2, Date=2013/4/4/ 14:46:36,ave=163.0
device=a-0, Date=2013/4/4/ 15:46:31,ave=43.802209862393
device=a-1, Date=2013/4/4/ 15:46:31,ave=110.6875
device=a-2, Date=2013/4/4/ 15:46:31,ave=163.625
device=a-0, Date=2012/12/24/ 16:54:41,ave=23.60867584568685
device=a-1, Date=2012/12/24/ 16:54:41,ave=91.85714285714286
device=a-2, Date=2012/12/24/ 16:54:41,ave=157.23076923076923
device=a-0, Date=2012/12/24/ 17:46:33,ave=88.91589487885125
device=a-1, Date=2012/12/24/ 17:46:33,ave=88.17391304347827
device=a-2, Date=2012/12/24/ 17:46:33,ave=154.86666666666667
device=a-0, Date=2012/12/24/ 18:40:45,ave=156.76264745225802
device=a-1, Date=2012/12/24/ 18:40:45,ave=79.25
device=a-2, Date=2012/12/24/ 18:40:45,ave=160.3125
device=a-0, Date=2012/12/24/ 19:23:44,ave=138.18061302232596
device=a-1, Date=2012/12/24/ 19:23:44,ave=72.11764705882354
device=a-2, Date=2012/12/24/ 19:23:44,ave=155.88235294117646
device=a-0, Date=2012/4/29/ 21:35:51,ave=0.0
device=a-1, Date=2012/4/29/ 21:35:51,ave=537.1
device=a-2, Date=2012/4/29/ 21:35:51,ave=664.1
device=a-0, Date=2012/4/29/ 21:40:5,ave=103.61709548914658
device=a-1, Date=2012/4/29/ 21:40:5,ave=545.75
device=a-2, Date=2012/4/29/ 21:40:5,ave=539.3333333333334
device=a-0, Date=2013/3/22/ 22:44:40,ave=49.47418363970848
device=a-1, Date=2013/3/22/ 22:44:40,ave=324.625
device=a-2, Date=2013/3/22/ 22:44:40,ave=319.4375

Front page   New List of pages Search Recent changes   Help   RSS of recent changes