Seeking monthly timer

Hi,
is there a node that I can use to trigger on the 1st of every month at 0:00 for example ?

I want to write counter readings in influxdb, so that I can build the difference in grafana for every month.

Grafana can only use by day or week, not by month: SELECT difference(distinct("Heizung")) FROM "WMZ" WHERE $timeFilter GROUP BY time(1d) fill(null)

Have a look at the cron-plus node. I believe it'll do just what you're looking for.

1 Like

As Nick said the cron-plus node would be ideal. It has an Expression Builder built-in so very easy to use.

Screen Shot 11-25-21 at 04.04 PM

2 Likes

very nice

I got it:

[
    {
        "id": "481597cd3803c3ba",
        "type": "debug",
        "z": "42651355.aa1f14",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "false",
        "statusVal": "",
        "statusType": "auto",
        "x": 630,
        "y": 2060,
        "wires": []
    },
    {
        "id": "d94e60f678da3d4b",
        "type": "cronplus",
        "z": "42651355.aa1f14",
        "name": "jeden Monat",
        "outputField": "payload",
        "timeZone": "",
        "persistDynamic": false,
        "commandResponseMsgOutput": "output1",
        "outputs": 1,
        "options": [
            {
                "name": "Heizung",
                "topic": "Heizung",
                "payloadType": "flow",
                "payload": "WMZ_Heizung",
                "expressionType": "cron",
                "expression": "0 0 0 1 * ? *",
                "location": "",
                "offset": "0",
                "solarType": "all",
                "solarEvents": "sunrise,sunset"
            },
            {
                "name": "Warmwasser",
                "topic": "WW",
                "payloadType": "flow",
                "payload": "WMZ_WW",
                "expressionType": "cron",
                "expression": "0 0 0 1 * ? *",
                "location": "",
                "offset": "0",
                "solarType": "all",
                "solarEvents": "sunrise,sunset"
            },
            {
                "name": "KĂĽhlung",
                "topic": "PC",
                "payloadType": "flow",
                "payload": "WMZ_PC",
                "expressionType": "cron",
                "expression": "0 0 0 1 * ? *",
                "location": "",
                "offset": "0",
                "solarType": "all",
                "solarEvents": "sunrise,sunset"
            },
            {
                "name": "Strom",
                "topic": "Strom",
                "payloadType": "flow",
                "payload": "WMZ_Wel",
                "expressionType": "cron",
                "expression": "0 0 0 1 * ? *",
                "location": "",
                "offset": "0",
                "solarType": "all",
                "solarEvents": "sunrise,sunset"
            }
        ],
        "x": 90,
        "y": 2060,
        "wires": [
            [
                "b1e6fc3ed2814713"
            ]
        ]
    },
    {
        "id": "b1e6fc3ed2814713",
        "type": "join",
        "z": "42651355.aa1f14",
        "name": "Objekt fĂĽr InfluxDB",
        "mode": "custom",
        "build": "object",
        "property": "payload",
        "propertyType": "msg",
        "key": "topic",
        "joiner": "\\n",
        "joinerType": "str",
        "accumulate": false,
        "timeout": "",
        "count": "4",
        "reduceRight": false,
        "reduceExp": "",
        "reduceInit": "",
        "reduceInitType": "",
        "reduceFixup": "",
        "x": 370,
        "y": 2060,
        "wires": [
            [
                "481597cd3803c3ba"
            ]
        ]
    }
]

thank you

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.