Manual Energy input for database and Grafana Dashboard

Hi,

i dont have any chance to monitore my electricity meter at home.
I try to add a number pad and Date field on the node-red Dashboard to input my Meterscores with date in a database of Node-red.

After this run fine i want to visualize it with a 5 year bar chart on grafana.
How i can solve it?

My first impressions i got from another solution to use "join" with "payload.L1 + payload.L2 +payload.L3 +payload.L4 +payload.L5 +payload.L6 +payload.L7 +payload.L8 +payload.L9 +payload.L10 +payload.L11 +payload.L12" for calculate my energy adapter to monitore and summ of all inputs:

But i have much problems to get a functional front and backend for the node-red Dashbord Input

The Date is in a weird format and i dont know, how i can use the date to save the state on the date in the db. if i monitore it, i only get the timestamp of creation (today and not for example 31.01.2022)

Here my Work:

[
    {
        "id": "a3601b868b3443f7",
        "type": "comment",
        "z": "e954db9cd434d6f3",
        "name": "Zählerstand",
        "info": "",
        "x": 310,
        "y": 1680,
        "wires": []
    },
    {
        "id": "96841b65b8917f41",
        "type": "ui_date_picker",
        "z": "e954db9cd434d6f3",
        "name": "",
        "label": "Datum des Zählerstandes",
        "group": "5934e2670cdcc8dc",
        "order": 8,
        "width": 0,
        "height": 0,
        "passthru": true,
        "topic": "date",
        "topicType": "msg",
        "className": "",
        "x": 350,
        "y": 1740,
        "wires": [
            [
                "339f4f1f01f6db42"
            ]
        ]
    },
    {
        "id": "b892d58aab71d208",
        "type": "debug",
        "z": "e954db9cd434d6f3",
        "name": "debug 1",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "false",
        "statusVal": "",
        "statusType": "auto",
        "x": 780,
        "y": 1660,
        "wires": []
    },
    {
        "id": "74c6308e0d42c692",
        "type": "join",
        "z": "e954db9cd434d6f3",
        "name": "",
        "mode": "custom",
        "build": "object",
        "property": "payload",
        "propertyType": "msg",
        "key": "topic",
        "joiner": "\\n",
        "joinerType": "str",
        "accumulate": true,
        "timeout": "",
        "count": "2",
        "reduceRight": false,
        "reduceExp": "",
        "reduceInit": "",
        "reduceInitType": "",
        "reduceFixup": "",
        "x": 710,
        "y": 1760,
        "wires": [
            [
                "b892d58aab71d208"
            ]
        ]
    },
    {
        "id": "daeca697d0b28a24",
        "type": "ui_text_input",
        "z": "e954db9cd434d6f3",
        "name": "",
        "label": "Zählerstand",
        "tooltip": "",
        "group": "5934e2670cdcc8dc",
        "order": 8,
        "width": 0,
        "height": 0,
        "passthru": true,
        "mode": "number",
        "delay": 300,
        "topic": "state",
        "sendOnBlur": true,
        "className": "",
        "topicType": "msg",
        "x": 310,
        "y": 1780,
        "wires": [
            [
                "26b3f992110a2ef1"
            ]
        ]
    },
    {
        "id": "339f4f1f01f6db42",
        "type": "change",
        "z": "e954db9cd434d6f3",
        "name": "date",
        "rules": [
            {
                "t": "set",
                "p": "topic",
                "pt": "msg",
                "to": "date",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 550,
        "y": 1740,
        "wires": [
            [
                "74c6308e0d42c692",
                "b892d58aab71d208"
            ]
        ]
    },
    {
        "id": "26b3f992110a2ef1",
        "type": "change",
        "z": "e954db9cd434d6f3",
        "name": "state",
        "rules": [
            {
                "t": "set",
                "p": "topic",
                "pt": "msg",
                "to": "state",
                "tot": "str"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 550,
        "y": 1780,
        "wires": [
            [
                "74c6308e0d42c692",
                "b892d58aab71d208"
            ]
        ]
    },
    {
        "id": "5934e2670cdcc8dc",
        "type": "ui_group",
        "name": "Stromzähler",
        "tab": "7c6fa6e7.e5b808",
        "order": 7,
        "disp": true,
        "width": "6",
        "collapse": false,
        "className": ""
    },
    {
        "id": "7c6fa6e7.e5b808",
        "type": "ui_tab",
        "name": "Home",
        "icon": "dashboard",
        "order": 1,
        "disabled": false,
        "hidden": false
    }
]

Thanks

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