Erledigt:
schedule("*/5 * * * * *", function () {
//durchschnitt von
sendTo('influxdb.0', 'query', 'SELECT MEAN(*) FROM "0_userdata.0.Kosten_Strom.Stromkosten_gestern"', function (result) {
if (result.error) {
console.error(result.error);
} else {
//console.log(JSON.stringify(result.result[0][0].mean_value ));
//[{"ack":true,"from":"system.adapter.javascript.0","q":0,"value":2.59,"ts":1698620400012}]
var valueYear = (JSON.stringify(result.result[0][0].mean_value * 365));
var KostenYear = parseFloat(valueYear);
setState('0_userdata.0.Kosten_Strom.Stromkosten_ca_Jahr', KostenYear);
}
});
});