Hey @jbudd thanks for your reply.
i want to take DB2 but until now it seems it cant represent the data i need.
There are 5 meter values, on 7 days from now on.
The Data came from 2 inverter, and my smartmeter. I take the absolute value from 00:00 on until 23:59 clock.
Here you can see what im doin:
[
{
"id": "72cfdaa6aebf9f83",
"type": "function",
"z": "a6c69280.aefa",
"name": "to kW",
"func": "msg.payload = Number(msg.payload);\nmsg.payload = (msg.payload);\nreturn msg;",
"outputs": 1,
"timeout": "",
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 890,
"y": 240,
"wires": [
[
"7ffda706e6dbea44",
"c98f1903d5953265",
"af3e38670e208f92"
]
]
},
{
"id": "0de79a72377e6a4e",
"type": "link in",
"z": "a6c69280.aefa",
"name": "Stromverbrauch",
"links": [
"ccd51eb342950375"
],
"x": 1015,
"y": 300,
"wires": [
[
"c98f1903d5953265",
"af3e38670e208f92"
]
]
},
{
"id": "5d9032f3e9f18949",
"type": "link in",
"z": "a6c69280.aefa",
"name": "Einspeisung",
"links": [
"d7b57d0bd0c062c7"
],
"x": 955,
"y": 280,
"wires": [
[
"c98f1903d5953265",
"af3e38670e208f92"
]
]
},
{
"id": "d1d750de307d88cd",
"type": "ui_chart",
"z": "a6c69280.aefa",
"name": "",
"group": "21e21de62ae423cf",
"order": 8,
"width": "6",
"height": "6",
"label": "Stromerzeugung ",
"chartType": "bar",
"legend": "false",
"xformat": "HH:mm",
"interpolate": "linear",
"nodata": "",
"dot": false,
"ymin": "",
"ymax": "",
"removeOlder": "24",
"removeOlderPoints": "",
"removeOlderUnit": "3600",
"cutout": 0,
"useOneColor": false,
"useUTC": false,
"colors": [
"#ff0000",
"#ffff00",
"#00ff00",
"#0080ff",
"#0080ff",
"#d62728",
"#ff9896",
"#9467bd",
"#c5b0d5"
],
"outputs": 1,
"useDifferentColor": false,
"className": "",
"x": 1980,
"y": 280,
"wires": [
[]
]
},
{
"id": "c98f1903d5953265",
"type": "bar-chart-data",
"z": "a6c69280.aefa",
"name": "Stromerzeugung",
"x_interval": "days",
"x_size": "7",
"unit": "KWh",
"precision": "1",
"is_meter_reading": "True",
"agg_by": "sum",
"prevent_negative": true,
"x": 1780,
"y": 280,
"wires": [
[
"d1d750de307d88cd"
]
]
},
{
"id": "d9f453f8cba1647a",
"type": "link in",
"z": "a6c69280.aefa",
"name": "",
"links": [
"1dfc60da4c44c31c"
],
"x": 1155,
"y": 320,
"wires": [
[
"c98f1903d5953265",
"af3e38670e208f92"
]
]
},
{
"id": "c2c114cb7f37aedd",
"type": "link in",
"z": "a6c69280.aefa",
"name": "Erzeugung gesamt",
"links": [
"f0c4f7efed051d5b"
],
"x": 1335,
"y": 320,
"wires": [
[
"c98f1903d5953265",
"af3e38670e208f92"
]
]
},
{
"id": "af3e38670e208f92",
"type": "debug",
"z": "a6c69280.aefa",
"name": "debug 3",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 1800,
"y": 200,
"wires": []
},
{
"id": "21e21de62ae423cf",
"type": "ui_group",
"name": "Stromnetz",
"tab": "65932f903b8c920f",
"order": 2,
"disp": true,
"width": "6",
"collapse": false,
"className": ""
},
{
"id": "65932f903b8c920f",
"type": "ui_tab",
"name": "Strom",
"icon": "power",
"order": 5,
"disabled": false,
"hidden": false
}
]
Hope you understand ... the inputs are the 5 values inverter 1, inverter 2, power consumtion, power give to the grid, and abolute power created by solar from a smartplug.
Regards,
Snot