averageSince not working in Influxdb

i tried finding something which could help me in the forum but i run out of luck. Hopefully somebody can help me

I try to get the averageSince for the power usage of my dishwasher, but i always get null returned instead of the average.

I do see the values in influxdb and also in grafana.

    Number Dishwasher_Power_Usage "Geschirrspüler Verbrauch" <whitegood> { channel="shelly:shellyplugs:....:meter#currentWatts" }

Here the rule

    val telegramAction = getActions("telegram",".....")
    logInfo("dishwasher", Dishwasher_Power_Usage.state.toString)
    logInfo("dishwasher", Dishwasher_Status.state.toString)
    logInfo("dishwasher", Dishwasher_Power_Usage.averageSince(now.minusMinutes(3,"influxdb")).toString)

    if (Dishwasher_Power_Usage.state == 0.0) {
    } else if (Dishwasher_Power_Usage.state > 2) {
    } else if (Dishwasher_Status.state.toString == "finished") {

    } else {
        if (Dishwasher_Power_Usage.averageSince(now.minusMinutes(3,"influxdb")) <= 2 && Dishwasher_Status.state.toString == "active") {
            telegramAction.sendTelegram("[Geschirrspüler] Ich bin fertig.")
            TV_Living_Room_Toast.sendCommand("[Geschirrspüler] Ich bin fertig.")
        } else {

Here the persistence settings

Strategies {
    everyMinute : "0 * * * * ?"
    default= everyChange

Items {
    Dishwasher_Power_Usage: strategy = everyMinute

So i know that averageSince is returning null.

Does somebody know how to fix it or if its is a bug?

Running oh2.5 with influxdb persistence 1.14.0

PS: Also checked for null values in the db, nothing. Only floats

This is your problem. The correct usage is:

1 Like

Thanks, thats it.

So its an error in the documentation.


Yes, I’ve already create a pull request to change it

1 Like