This is an R Markdown
Notebook. When you execute code within the notebook, the results appear
beneath the code.
Try executing this chunk by clicking the Run button within
the chunk or by placing your cursor inside it and pressing
Ctrl+Shift+Enter.
Nr=NROW(TAGs)
i=1
for (i in 1:Nr) {
QryText<-paste('select TimeStamp,Value,Good from ASECA where Tag=',paste('"',TAGs$TAG[i],'"',sep=''),'order by timestamp ASC')
ValueQry <- dbSendQuery(Cx,QryText)
ValLst <- fetch(ValueQry,n=-1)
dbClearResult(ValueQry)
## Con la nueva lista calcula las estadisticas de cada TAG
hist(ValLst$Value, xlab = i, main = paste("Histogram of TAG", TAGs$TAG[i]),col = "lightblue")
}
Add a new chunk by clicking the Insert Chunk button on the
toolbar or by pressing Ctrl+Alt+I.
When you save the notebook, an HTML file containing the code and
output will be saved alongside it (click the Preview button or
press Ctrl+Shift+K to preview the HTML file).
The preview shows you a rendered HTML copy of the contents of the
editor. Consequently, unlike Knit, Preview does not
run any R code chunks. Instead, the output of the chunk when it was last
run in the editor is displayed.
LS0tDQp0aXRsZTogIlIgTm90ZWJvb2siDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KDQpUaGlzIGlzIGFuIFtSIE1hcmtkb3duXShodHRwOi8vcm1hcmtkb3duLnJzdHVkaW8uY29tKSBOb3RlYm9vay4gV2hlbiB5b3UgZXhlY3V0ZSBjb2RlIHdpdGhpbiB0aGUgbm90ZWJvb2ssIHRoZSByZXN1bHRzIGFwcGVhciBiZW5lYXRoIHRoZSBjb2RlLiANCg0KVHJ5IGV4ZWN1dGluZyB0aGlzIGNodW5rIGJ5IGNsaWNraW5nIHRoZSAqUnVuKiBidXR0b24gd2l0aGluIHRoZSBjaHVuayBvciBieSBwbGFjaW5nIHlvdXIgY3Vyc29yIGluc2lkZSBpdCBhbmQgcHJlc3NpbmcgKkN0cmwrU2hpZnQrRW50ZXIqLiANCg0KYGBge3J9DQpOcj1OUk9XKFRBR3MpDQppPTENCmZvciAoaSBpbiAxOk5yKSB7IA0KICBRcnlUZXh0PC1wYXN0ZSgnc2VsZWN0IFRpbWVTdGFtcCxWYWx1ZSxHb29kIGZyb20gQVNFQ0Egd2hlcmUgVGFnPScscGFzdGUoJyInLFRBR3MkVEFHW2ldLCciJyxzZXA9JycpLCdvcmRlciBieSB0aW1lc3RhbXAgQVNDJykNCiAgVmFsdWVRcnkgPC0gZGJTZW5kUXVlcnkoQ3gsUXJ5VGV4dCkNCiAgDQogIFZhbExzdCA8LSBmZXRjaChWYWx1ZVFyeSxuPS0xKQ0KICBkYkNsZWFyUmVzdWx0KFZhbHVlUXJ5KQ0KICAjIyBDb24gbGEgbnVldmEgbGlzdGEgY2FsY3VsYSBsYXMgZXN0YWRpc3RpY2FzIGRlIGNhZGEgVEFHDQogIGhpc3QoVmFsTHN0JFZhbHVlLCB4bGFiID0gaSwgbWFpbiA9IHBhc3RlKCJIaXN0b2dyYW0gb2YgVEFHIiwgVEFHcyRUQUdbaV0pLGNvbCA9ICJsaWdodGJsdWUiKSAgDQogIH0NCg0KDQpgYGANCg0KQWRkIGEgbmV3IGNodW5rIGJ5IGNsaWNraW5nIHRoZSAqSW5zZXJ0IENodW5rKiBidXR0b24gb24gdGhlIHRvb2xiYXIgb3IgYnkgcHJlc3NpbmcgKkN0cmwrQWx0K0kqLg0KDQpXaGVuIHlvdSBzYXZlIHRoZSBub3RlYm9vaywgYW4gSFRNTCBmaWxlIGNvbnRhaW5pbmcgdGhlIGNvZGUgYW5kIG91dHB1dCB3aWxsIGJlIHNhdmVkIGFsb25nc2lkZSBpdCAoY2xpY2sgdGhlICpQcmV2aWV3KiBidXR0b24gb3IgcHJlc3MgKkN0cmwrU2hpZnQrSyogdG8gcHJldmlldyB0aGUgSFRNTCBmaWxlKS4NCg0KVGhlIHByZXZpZXcgc2hvd3MgeW91IGEgcmVuZGVyZWQgSFRNTCBjb3B5IG9mIHRoZSBjb250ZW50cyBvZiB0aGUgZWRpdG9yLiBDb25zZXF1ZW50bHksIHVubGlrZSAqS25pdCosICpQcmV2aWV3KiBkb2VzIG5vdCBydW4gYW55IFIgY29kZSBjaHVua3MuIEluc3RlYWQsIHRoZSBvdXRwdXQgb2YgdGhlIGNodW5rIHdoZW4gaXQgd2FzIGxhc3QgcnVuIGluIHRoZSBlZGl0b3IgaXMgZGlzcGxheWVkLg0K