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