Hi folks,
i am dealing with a problem for hours but i can not get a solution.
The problem:
I do have two object as the result of 2 querys in two different databases.
i change the msg.topic with a change-node to the topics, displayed in the query results.
query 1 result
{"_msgid":"953a3907092f24cd","payload":[{"date":"2025-02-18T23:00:00.000Z","wert":0.49},{"date":"2025-02-19T03:25:00.000Z","wert":0.49},
{"date":"2025-02-19T13:50:00.000Z","wert":360.41},{"date":"2025-02-19T13:55:00.000Z","wert":363.44},{"date":"2025-02-19T14:00:00.000Z","wert":362.79},{"date":"2025-02-19T14:05:00.000Z","wert":369.39},{"date":"2025-02-19T14:10:00.000Z","wert":330.51},{"date":"2025-02-19T14:15:00.000Z","wert":321.89},{"date":"2025-02-19T14:20:00.000Z","wert":349.53},{"date":"2025-02-19T14:25:00.000Z","wert":336.25},{"date":"2025-02-19T14:30:00.000Z","wert":325.05}],
"topic":"leistung"}
query 2 result:
{"_msgid":"953a3907092f24cd","payload":
[{"date":"2025-02-18T23:00:00.000Z","wert":0},
{"date":"2025-02-19T08:30:00.000Z","wert":148},{"date":"2025-02-19T09:00:00.000Z","wert":189},{"date":"2025-02-19T09:30:00.000Z","wert":221},{"date":"2025-02-19T10:00:00.000Z","wert":332},{"date":"2025-02-19T10:30:00.000Z","wert":359},{"date":"2025-02-19T11:00:00.000Z","wert":415},{"date":"2025-02-19T11:30:00.000Z","wert":494},{"date":"2025-02-19T12:00:00.000Z","wert":535},{"date":"2025-02-19T12:30:00.000Z","wert":543},{"date":"2025-02-19T13:00:00.000Z","wert":516},{"date":"2025-02-19T13:30:00.000Z","wert":488},{"date":"2025-02-19T14:00:00.000Z","wert":416},{"date":"2025-02-19T14:30:00.000Z","wert":366}],
"topic":"globalstrahlung"}
Putting both results i the chart-node, just displays one line, not both.
I shortened the results here.
I want to display both values in "wert" in two different lines in a dashboard 2.0 chart.
Do i have to transform the results in a different structure or is it a question of adjusting the chart-node?
Does anyone have a hint?
Thanks
