Show grid tariff in dashboard

Hi,

I recently created my first dashboard and it worked pretty will.

But now I have a requirement for which I do not even have an idea how to start and I hope someone could give me a hint.

I have a solar system with battery backup and a variable grid tariff which typically looks like this:

Now, I would like to show this tariff curves (both the orange and the blue) on the dashboard at 00:00 for the full day ahead PLUS show with a yellow dot on where (what tariff) we currently are.

The yellow dot is not a problem. I can send every 15mins a value with a specific msg.topic an label this in yellow.

BUT how do I draw the 2 curves for the full day at once?

Many thanks for your hints.

Heinz

Can you confirm if you are using Dashboard v1 (node-red-dashboard) or v2 (@flowfuse/node-red-dashboard) ?

How do you obtain the data behind the orange and blue curves - via a single API call?
Once set for the day, are the tariffs fixed or variable?
An example of a day's worth of data would be informative.

Hi jbudd,

Many thanks for your help.

I am using the following dashboard nodes:
Bildschirmfoto vom 2025-03-30 20-07-03
does that help?

Yes, I get them in a single API call, but I could rearrange that via a for loop in a function node.

Once set, they will stay the same for the day

Please find below the array for tomorrow 31. March.

  • the blue tariff = "vario_plus"
  • the orange tariff = "dt_plus"
[{"start_timestamp":"2025-03-31T00:00:00+02:00","end_timestamp":"2025-03-31T00:15:00+02:00","vario_plus":23.01,"vario_grid":5.17,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T00:15:00+02:00","end_timestamp":"2025-03-31T00:30:00+02:00","vario_plus":22.8,"vario_grid":4.98,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T00:30:00+02:00","end_timestamp":"2025-03-31T00:45:00+02:00","vario_plus":22,"vario_grid":4.24,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T00:45:00+02:00","end_timestamp":"2025-03-31T01:00:00+02:00","vario_plus":21.34,"vario_grid":3.63,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T01:00:00+02:00","end_timestamp":"2025-03-31T01:15:00+02:00","vario_plus":23.65,"vario_grid":5.76,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T01:15:00+02:00","end_timestamp":"2025-03-31T01:30:00+02:00","vario_plus":23.27,"vario_grid":5.41,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T01:30:00+02:00","end_timestamp":"2025-03-31T01:45:00+02:00","vario_plus":21.94,"vario_grid":4.19,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T01:45:00+02:00","end_timestamp":"2025-03-31T02:00:00+02:00","vario_plus":20.54,"vario_grid":2.89,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T02:00:00+02:00","end_timestamp":"2025-03-31T02:15:00+02:00","vario_plus":21.12,"vario_grid":3.43,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T02:15:00+02:00","end_timestamp":"2025-03-31T02:30:00+02:00","vario_plus":20.34,"vario_grid":2.7,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T02:30:00+02:00","end_timestamp":"2025-03-31T02:45:00+02:00","vario_plus":19.93,"vario_grid":2.33,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T02:45:00+02:00","end_timestamp":"2025-03-31T03:00:00+02:00","vario_plus":19.35,"vario_grid":1.79,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T03:00:00+02:00","end_timestamp":"2025-03-31T03:15:00+02:00","vario_plus":19.53,"vario_grid":1.96,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T03:15:00+02:00","end_timestamp":"2025-03-31T03:30:00+02:00","vario_plus":19.25,"vario_grid":1.7,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T03:30:00+02:00","end_timestamp":"2025-03-31T03:45:00+02:00","vario_plus":19.02,"vario_grid":1.48,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T03:45:00+02:00","end_timestamp":"2025-03-31T04:00:00+02:00","vario_plus":18.83,"vario_grid":1.31,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T04:00:00+02:00","end_timestamp":"2025-03-31T04:15:00+02:00","vario_plus":19.42,"vario_grid":1.85,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T04:15:00+02:00","end_timestamp":"2025-03-31T04:30:00+02:00","vario_plus":19.58,"vario_grid":2,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T04:30:00+02:00","end_timestamp":"2025-03-31T04:45:00+02:00","vario_plus":19.91,"vario_grid":2.31,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T04:45:00+02:00","end_timestamp":"2025-03-31T05:00:00+02:00","vario_plus":20.43,"vario_grid":2.79,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T05:00:00+02:00","end_timestamp":"2025-03-31T05:15:00+02:00","vario_plus":22.05,"vario_grid":4.29,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T05:15:00+02:00","end_timestamp":"2025-03-31T05:30:00+02:00","vario_plus":22.73,"vario_grid":4.91,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T05:30:00+02:00","end_timestamp":"2025-03-31T05:45:00+02:00","vario_plus":23.62,"vario_grid":5.74,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T05:45:00+02:00","end_timestamp":"2025-03-31T06:00:00+02:00","vario_plus":24.79,"vario_grid":6.82,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T06:00:00+02:00","end_timestamp":"2025-03-31T06:15:00+02:00","vario_plus":26.13,"vario_grid":8.06,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T06:15:00+02:00","end_timestamp":"2025-03-31T06:30:00+02:00","vario_plus":27.53,"vario_grid":9.36,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T06:30:00+02:00","end_timestamp":"2025-03-31T06:45:00+02:00","vario_plus":28.88,"vario_grid":10.61,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T06:45:00+02:00","end_timestamp":"2025-03-31T07:00:00+02:00","vario_plus":29.95,"vario_grid":11.6,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T07:00:00+02:00","end_timestamp":"2025-03-31T07:15:00+02:00","vario_plus":34.73,"vario_grid":11.72,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T07:15:00+02:00","end_timestamp":"2025-03-31T07:30:00+02:00","vario_plus":35.79,"vario_grid":12.7,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T07:30:00+02:00","end_timestamp":"2025-03-31T07:45:00+02:00","vario_plus":36.48,"vario_grid":13.33,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T07:45:00+02:00","end_timestamp":"2025-03-31T08:00:00+02:00","vario_plus":36.55,"vario_grid":13.4,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T08:00:00+02:00","end_timestamp":"2025-03-31T08:15:00+02:00","vario_plus":36.78,"vario_grid":13.62,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T08:15:00+02:00","end_timestamp":"2025-03-31T08:30:00+02:00","vario_plus":36.47,"vario_grid":13.33,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T08:30:00+02:00","end_timestamp":"2025-03-31T08:45:00+02:00","vario_plus":34.93,"vario_grid":11.91,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T08:45:00+02:00","end_timestamp":"2025-03-31T09:00:00+02:00","vario_plus":34.13,"vario_grid":11.16,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T09:00:00+02:00","end_timestamp":"2025-03-31T09:15:00+02:00","vario_plus":35.12,"vario_grid":12.07,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T09:15:00+02:00","end_timestamp":"2025-03-31T09:30:00+02:00","vario_plus":33.73,"vario_grid":10.8,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T09:30:00+02:00","end_timestamp":"2025-03-31T09:45:00+02:00","vario_plus":31.52,"vario_grid":8.74,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T09:45:00+02:00","end_timestamp":"2025-03-31T10:00:00+02:00","vario_plus":29.78,"vario_grid":7.14,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T10:00:00+02:00","end_timestamp":"2025-03-31T10:15:00+02:00","vario_plus":28.4,"vario_grid":5.86,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T10:15:00+02:00","end_timestamp":"2025-03-31T10:30:00+02:00","vario_plus":26.51,"vario_grid":4.11,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T10:30:00+02:00","end_timestamp":"2025-03-31T10:45:00+02:00","vario_plus":25.03,"vario_grid":2.74,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T10:45:00+02:00","end_timestamp":"2025-03-31T11:00:00+02:00","vario_plus":24.47,"vario_grid":2.23,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T11:00:00+02:00","end_timestamp":"2025-03-31T11:15:00+02:00","vario_plus":20.45,"vario_grid":-1.49,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T11:15:00+02:00","end_timestamp":"2025-03-31T11:30:00+02:00","vario_plus":19.04,"vario_grid":-2.8,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T11:30:00+02:00","end_timestamp":"2025-03-31T11:45:00+02:00","vario_plus":18.67,"vario_grid":-3.14,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T11:45:00+02:00","end_timestamp":"2025-03-31T12:00:00+02:00","vario_plus":18.23,"vario_grid":-3.55,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T12:00:00+02:00","end_timestamp":"2025-03-31T12:15:00+02:00","vario_plus":15.64,"vario_grid":-5.94,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T12:15:00+02:00","end_timestamp":"2025-03-31T12:30:00+02:00","vario_plus":15.39,"vario_grid":-6.17,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T12:30:00+02:00","end_timestamp":"2025-03-31T12:45:00+02:00","vario_plus":13.66,"vario_grid":-7.77,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T12:45:00+02:00","end_timestamp":"2025-03-31T13:00:00+02:00","vario_plus":11.7,"vario_grid":-9.58,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T13:00:00+02:00","end_timestamp":"2025-03-31T13:15:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T13:15:00+02:00","end_timestamp":"2025-03-31T13:30:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T13:30:00+02:00","end_timestamp":"2025-03-31T13:45:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T13:45:00+02:00","end_timestamp":"2025-03-31T14:00:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T14:00:00+02:00","end_timestamp":"2025-03-31T14:15:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T14:15:00+02:00","end_timestamp":"2025-03-31T14:30:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T14:30:00+02:00","end_timestamp":"2025-03-31T14:45:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T14:45:00+02:00","end_timestamp":"2025-03-31T15:00:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T15:00:00+02:00","end_timestamp":"2025-03-31T15:15:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T15:15:00+02:00","end_timestamp":"2025-03-31T15:30:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T15:30:00+02:00","end_timestamp":"2025-03-31T15:45:00+02:00","vario_plus":11.65,"vario_grid":-9.63,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T15:45:00+02:00","end_timestamp":"2025-03-31T16:00:00+02:00","vario_plus":12.04,"vario_grid":-9.27,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T16:00:00+02:00","end_timestamp":"2025-03-31T16:15:00+02:00","vario_plus":13.87,"vario_grid":-7.58,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T16:15:00+02:00","end_timestamp":"2025-03-31T16:30:00+02:00","vario_plus":15.13,"vario_grid":-6.41,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T16:30:00+02:00","end_timestamp":"2025-03-31T16:45:00+02:00","vario_plus":16.41,"vario_grid":-5.23,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T16:45:00+02:00","end_timestamp":"2025-03-31T17:00:00+02:00","vario_plus":17.54,"vario_grid":-4.18,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T17:00:00+02:00","end_timestamp":"2025-03-31T17:15:00+02:00","vario_plus":17.83,"vario_grid":-3.92,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T17:15:00+02:00","end_timestamp":"2025-03-31T17:30:00+02:00","vario_plus":18.91,"vario_grid":-2.92,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T17:30:00+02:00","end_timestamp":"2025-03-31T17:45:00+02:00","vario_plus":21.56,"vario_grid":-0.46,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T17:45:00+02:00","end_timestamp":"2025-03-31T18:00:00+02:00","vario_plus":23.54,"vario_grid":1.37,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T18:00:00+02:00","end_timestamp":"2025-03-31T18:15:00+02:00","vario_plus":27.58,"vario_grid":5.11,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T18:15:00+02:00","end_timestamp":"2025-03-31T18:30:00+02:00","vario_plus":29.77,"vario_grid":7.13,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T18:30:00+02:00","end_timestamp":"2025-03-31T18:45:00+02:00","vario_plus":31.57,"vario_grid":8.79,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T18:45:00+02:00","end_timestamp":"2025-03-31T19:00:00+02:00","vario_plus":33.66,"vario_grid":10.73,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T19:00:00+02:00","end_timestamp":"2025-03-31T19:15:00+02:00","vario_plus":35.14,"vario_grid":12.1,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T19:15:00+02:00","end_timestamp":"2025-03-31T19:30:00+02:00","vario_plus":36.18,"vario_grid":13.06,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T19:30:00+02:00","end_timestamp":"2025-03-31T19:45:00+02:00","vario_plus":37.24,"vario_grid":14.04,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T19:45:00+02:00","end_timestamp":"2025-03-31T20:00:00+02:00","vario_plus":37.71,"vario_grid":14.48,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T20:00:00+02:00","end_timestamp":"2025-03-31T20:15:00+02:00","vario_plus":37.26,"vario_grid":14.06,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T20:15:00+02:00","end_timestamp":"2025-03-31T20:30:00+02:00","vario_plus":37.12,"vario_grid":13.93,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T20:30:00+02:00","end_timestamp":"2025-03-31T20:45:00+02:00","vario_plus":37.49,"vario_grid":14.27,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T20:45:00+02:00","end_timestamp":"2025-03-31T21:00:00+02:00","vario_plus":36.75,"vario_grid":13.58,"dt_plus":31.65,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T21:00:00+02:00","end_timestamp":"2025-03-31T21:15:00+02:00","vario_plus":31.88,"vario_grid":13.38,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T21:15:00+02:00","end_timestamp":"2025-03-31T21:30:00+02:00","vario_plus":31.69,"vario_grid":13.2,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T21:30:00+02:00","end_timestamp":"2025-03-31T21:45:00+02:00","vario_plus":31.07,"vario_grid":12.63,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T21:45:00+02:00","end_timestamp":"2025-03-31T22:00:00+02:00","vario_plus":30.26,"vario_grid":11.88,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T22:00:00+02:00","end_timestamp":"2025-03-31T22:15:00+02:00","vario_plus":30.23,"vario_grid":11.86,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T22:15:00+02:00","end_timestamp":"2025-03-31T22:30:00+02:00","vario_plus":29.43,"vario_grid":11.11,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T22:30:00+02:00","end_timestamp":"2025-03-31T22:45:00+02:00","vario_plus":28.71,"vario_grid":10.45,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T22:45:00+02:00","end_timestamp":"2025-03-31T23:00:00+02:00","vario_plus":27.9,"vario_grid":9.7,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T23:00:00+02:00","end_timestamp":"2025-03-31T23:15:00+02:00","vario_plus":28.67,"vario_grid":10.41,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T23:15:00+02:00","end_timestamp":"2025-03-31T23:30:00+02:00","vario_plus":28.46,"vario_grid":10.22,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T23:30:00+02:00","end_timestamp":"2025-03-31T23:45:00+02:00","vario_plus":27.78,"vario_grid":9.59,"dt_plus":21.3,"unit":"Rp./kWh"},{"start_timestamp":"2025-03-31T23:45:00+02:00","end_timestamp":"2025-04-01T00:00:00+02:00","vario_plus":26.98,"vario_grid":8.85,"dt_plus":21.3,"unit":"Rp./kWh"}]

Hope, that helps.

Heinz

Thanks, yes that's Dashboard v1.

Since you have not been working with the dashboard for long, it might be wise to switch to the new version.
Charts are handled very differently in the new dashboard, in many ways much easier than in v1.

Anyway, for v1 you need a "stored data" type chart where you pass the entire day's data to the chart in a single message.
It has to be in a specific format with x and y coordinates, something like this:

[{
"series": ["Tariff 1", "Tariff 2"],
"data": [
    [{ "x": 1504029632890, "y": 5 },
     { "x": 1504029636001, "y": 4 },
     { "x": 1504029638656, "y": 2 }
    ],
    [{ "x": 1504029633514, "y": 6 },
     { "x": 1504029636622, "y": 7 },
     { "x": 1504029639539, "y": 6 }
    ]
],
"labels": [""]
}]

If you search the forum for stored data chart you should be able to find examples of how to transform your API data into this format.

Many thanks jbudd,

I will try this out. How do I switch to the new version of the dashboard?

Heinz

In Manage Palette search for @flowfuse/node-red-dashboard & install.

You can have both dashboards installed together.
The v1 dashboard is at <IP address>:1880/ui, v2 at <IP address>:1880/dashboard.

Ok, I switched to V2 .... and....yes, much better! :slight_smile:

If I want to display the tariff in V2, I do that the same way as in V1?

Many thanks

Heinz

In Dashboard 2 you need to :

  • Create a ui-base. All this does is define the /dashboard URL
  • Create a ui-page. This defines the page URL eg /dashboard/grid, the theme and layout options.
  • Create a ui-group. Your chart will belong inside this group on the page. The most important option here is size. "12x1" fills my screen, yours may be different. You can safely ignore the "x1" bit.
  • Note you can do the three steps above after dragging a chart widget onto the editor & going into the config. Use the + icon on the grid line and subsequent popups.
  • Try these chart options
  • Connect your API output array to the chart node. There is no need to reformat it as (x,y) coordinates.

Hi jbudd,

Many thanks for the hints. V2 works well:

However, the tariff does not show yet. Here is what I did:

[{"id":"a24e38778640256c","type":"group","z":"c0259f4054b12973","name":"Display Vario Tariff on Dashboard","style":{"label":true},"nodes":["3c508277fa8b38ea","2b68b93ca338d45e","c936afdaccdd9367","bec0324695906c17","6ca8ad4be6c72827"],"x":34,"y":699,"w":772,"h":142},{"id":"3c508277fa8b38ea","type":"inject","z":"c0259f4054b12973","g":"a24e38778640256c","name":"Everyday after midnight","props":[{"p":"payload"}],"repeat":"","crontab":"05 00 * * *","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":190,"y":740,"wires":[["2b68b93ca338d45e"]]},{"id":"2b68b93ca338d45e","type":"change","z":"c0259f4054b12973","g":"a24e38778640256c","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"TodaysData","tot":"flow"}],"action":"","property":"","from":"","to":"","reg":false,"x":430,"y":740,"wires":[["bec0324695906c17","c936afdaccdd9367"]]},{"id":"c936afdaccdd9367","type":"debug","z":"c0259f4054b12973","g":"a24e38778640256c","name":"debug 63","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":700,"y":800,"wires":[]},{"id":"bec0324695906c17","type":"ui-chart","z":"c0259f4054b12973","g":"a24e38778640256c","group":"2ee1d37e41b0bdaf","name":"Tarif Information","label":"Tarif Information","order":1,"chartType":"line","category":"[\"vario_plus\",\"dt_plus\"]","categoryType":"json","xAxisLabel":"Tageszeit","xAxisProperty":"start_timestamp","xAxisPropertyType":"property","xAxisType":"time","xAxisFormat":"","xAxisFormatType":"HH:mm","xmin":"","xmax":"","yAxisLabel":"Fr. / kWh","yAxisProperty":"payload","yAxisPropertyType":"msg","ymin":"0","ymax":"1","bins":10,"action":"append","stackSeries":false,"pointShape":"line","pointRadius":"1","showLegend":false,"removeOlder":"12","removeOlderUnit":"3600","removeOlderPoints":"","colors":["#1f36e5","#ff7f0e","#ff7f0e","#2ca02c","#a347e1","#d62728","#ff9896","#9467bd","#c5b0d5"],"textColor":["#ffffff"],"textColorDefault":false,"gridColor":["#e5e5e5"],"gridColorDefault":false,"width":"3","height":"6","className":"","interpolation":"linear","x":700,"y":740,"wires":[[]]},{"id":"6ca8ad4be6c72827","type":"function","z":"c0259f4054b12973","g":"a24e38778640256c","name":"function 3","func":"const JasonTariff = msg.payload;\nvar DashboardTariff = [];\n\n\nfor (var i = 0; i < JasonTariff.length; i++) {\n    DashboardTariff[i] = {};\n    DashboardTariff[i][\"timestamp\"] = JasonTariff[i][\"end_timestamp\"];\n    DashboardTariff[i][\"VarioPlus\"] = JasonTariff[i][\"vario_plus\"];\n    DashboardTariff[i][\"DtPlus\"] = JasonTariff[i][\"dt_plus\"];\n}\n\nmsg.payload = DashboardTariff;\n\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":500,"y":800,"wires":[[]]},{"id":"2ee1d37e41b0bdaf","type":"ui-group","name":"Vario Tarif Information","page":"c4ee7ecd338225ac","width":"3","height":"6","order":6,"showTitle":true,"className":"","visible":"true","disabled":"false","groupType":"default"},{"id":"c4ee7ecd338225ac","type":"ui-page","name":"Leistung PV Anlage Hintere Gasse 2/3","ui":"76d5fd200daa146c","path":"/PV Leistung","icon":"home","layout":"grid","theme":"1ef67418aa7b26f5","breakpoints":[{"name":"Default","px":"0","cols":"3"},{"name":"Tablet","px":"576","cols":"6"},{"name":"Small Desktop","px":"768","cols":"9"},{"name":"Desktop","px":"1024","cols":"12"}],"order":1,"className":"","visible":true,"disabled":false},{"id":"76d5fd200daa146c","type":"ui-base","name":"Leistung PV Anlage Hintere Gasse 2/3","path":"/dashboard","appIcon":"","includeClientData":true,"acceptsClientConfig":["ui-notification","ui-control"],"showPathInSidebar":false,"headerContent":"page","navigationStyle":"default","titleBarStyle":"default","showReconnectNotification":true,"notificationDisplayTime":"1","showDisconnectNotification":true},{"id":"1ef67418aa7b26f5","type":"ui-theme","name":"Default Theme","colors":{"surface":"#3f51b5","primary":"#0094ce","bgPage":"#363636","groupBg":"#525252","groupOutline":"#cccccc"},"sizes":{"density":"default","pagePadding":"12px","groupGap":"5px","groupBorderRadius":"12px","widgetGap":"12px"}}]

The data and it's structure is still the same.

Because it did not work, I had it running through the "function 3" node with adapted values in the dashboard node. Also I tried to set the timestamp in a "HH:mm" format (i.e. "10:30") but it didn't work as well.

May I have a problem setting the time format?

Many thanks for your help

Heinz

Feed the sample data you first shared directly into a chart node configured as i suggested.
Do not modify the data in any way.

What do you see?

I am not at my PC or I would give you a sample flow.

Thanks jbudd,

Yes, I do feed it directly again now. I just made a trial & error exercise in between. :slight_smile:

Unfortunately the chart does not show anything.

Heinz

image

[{"id":"007684400ba5fb52","type":"inject","z":"d0812e07f4e78e1f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":true,"onceDelay":0.1,"topic":"","payload":"[{\"start_timestamp\":\"2025-03-31T00:00:00+02:00\",\"end_timestamp\":\"2025-03-31T00:15:00+02:00\",\"vario_plus\":23.01,\"vario_grid\":5.17,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T00:15:00+02:00\",\"end_timestamp\":\"2025-03-31T00:30:00+02:00\",\"vario_plus\":22.8,\"vario_grid\":4.98,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T00:30:00+02:00\",\"end_timestamp\":\"2025-03-31T00:45:00+02:00\",\"vario_plus\":22,\"vario_grid\":4.24,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T00:45:00+02:00\",\"end_timestamp\":\"2025-03-31T01:00:00+02:00\",\"vario_plus\":21.34,\"vario_grid\":3.63,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T01:00:00+02:00\",\"end_timestamp\":\"2025-03-31T01:15:00+02:00\",\"vario_plus\":23.65,\"vario_grid\":5.76,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T01:15:00+02:00\",\"end_timestamp\":\"2025-03-31T01:30:00+02:00\",\"vario_plus\":23.27,\"vario_grid\":5.41,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T01:30:00+02:00\",\"end_timestamp\":\"2025-03-31T01:45:00+02:00\",\"vario_plus\":21.94,\"vario_grid\":4.19,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T01:45:00+02:00\",\"end_timestamp\":\"2025-03-31T02:00:00+02:00\",\"vario_plus\":20.54,\"vario_grid\":2.89,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T02:00:00+02:00\",\"end_timestamp\":\"2025-03-31T02:15:00+02:00\",\"vario_plus\":21.12,\"vario_grid\":3.43,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T02:15:00+02:00\",\"end_timestamp\":\"2025-03-31T02:30:00+02:00\",\"vario_plus\":20.34,\"vario_grid\":2.7,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T02:30:00+02:00\",\"end_timestamp\":\"2025-03-31T02:45:00+02:00\",\"vario_plus\":19.93,\"vario_grid\":2.33,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T02:45:00+02:00\",\"end_timestamp\":\"2025-03-31T03:00:00+02:00\",\"vario_plus\":19.35,\"vario_grid\":1.79,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T03:00:00+02:00\",\"end_timestamp\":\"2025-03-31T03:15:00+02:00\",\"vario_plus\":19.53,\"vario_grid\":1.96,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T03:15:00+02:00\",\"end_timestamp\":\"2025-03-31T03:30:00+02:00\",\"vario_plus\":19.25,\"vario_grid\":1.7,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T03:30:00+02:00\",\"end_timestamp\":\"2025-03-31T03:45:00+02:00\",\"vario_plus\":19.02,\"vario_grid\":1.48,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T03:45:00+02:00\",\"end_timestamp\":\"2025-03-31T04:00:00+02:00\",\"vario_plus\":18.83,\"vario_grid\":1.31,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T04:00:00+02:00\",\"end_timestamp\":\"2025-03-31T04:15:00+02:00\",\"vario_plus\":19.42,\"vario_grid\":1.85,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T04:15:00+02:00\",\"end_timestamp\":\"2025-03-31T04:30:00+02:00\",\"vario_plus\":19.58,\"vario_grid\":2,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T04:30:00+02:00\",\"end_timestamp\":\"2025-03-31T04:45:00+02:00\",\"vario_plus\":19.91,\"vario_grid\":2.31,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T04:45:00+02:00\",\"end_timestamp\":\"2025-03-31T05:00:00+02:00\",\"vario_plus\":20.43,\"vario_grid\":2.79,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T05:00:00+02:00\",\"end_timestamp\":\"2025-03-31T05:15:00+02:00\",\"vario_plus\":22.05,\"vario_grid\":4.29,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T05:15:00+02:00\",\"end_timestamp\":\"2025-03-31T05:30:00+02:00\",\"vario_plus\":22.73,\"vario_grid\":4.91,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T05:30:00+02:00\",\"end_timestamp\":\"2025-03-31T05:45:00+02:00\",\"vario_plus\":23.62,\"vario_grid\":5.74,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T05:45:00+02:00\",\"end_timestamp\":\"2025-03-31T06:00:00+02:00\",\"vario_plus\":24.79,\"vario_grid\":6.82,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T06:00:00+02:00\",\"end_timestamp\":\"2025-03-31T06:15:00+02:00\",\"vario_plus\":26.13,\"vario_grid\":8.06,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T06:15:00+02:00\",\"end_timestamp\":\"2025-03-31T06:30:00+02:00\",\"vario_plus\":27.53,\"vario_grid\":9.36,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T06:30:00+02:00\",\"end_timestamp\":\"2025-03-31T06:45:00+02:00\",\"vario_plus\":28.88,\"vario_grid\":10.61,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T06:45:00+02:00\",\"end_timestamp\":\"2025-03-31T07:00:00+02:00\",\"vario_plus\":29.95,\"vario_grid\":11.6,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T07:00:00+02:00\",\"end_timestamp\":\"2025-03-31T07:15:00+02:00\",\"vario_plus\":34.73,\"vario_grid\":11.72,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T07:15:00+02:00\",\"end_timestamp\":\"2025-03-31T07:30:00+02:00\",\"vario_plus\":35.79,\"vario_grid\":12.7,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T07:30:00+02:00\",\"end_timestamp\":\"2025-03-31T07:45:00+02:00\",\"vario_plus\":36.48,\"vario_grid\":13.33,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T07:45:00+02:00\",\"end_timestamp\":\"2025-03-31T08:00:00+02:00\",\"vario_plus\":36.55,\"vario_grid\":13.4,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T08:00:00+02:00\",\"end_timestamp\":\"2025-03-31T08:15:00+02:00\",\"vario_plus\":36.78,\"vario_grid\":13.62,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T08:15:00+02:00\",\"end_timestamp\":\"2025-03-31T08:30:00+02:00\",\"vario_plus\":36.47,\"vario_grid\":13.33,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T08:30:00+02:00\",\"end_timestamp\":\"2025-03-31T08:45:00+02:00\",\"vario_plus\":34.93,\"vario_grid\":11.91,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T08:45:00+02:00\",\"end_timestamp\":\"2025-03-31T09:00:00+02:00\",\"vario_plus\":34.13,\"vario_grid\":11.16,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T09:00:00+02:00\",\"end_timestamp\":\"2025-03-31T09:15:00+02:00\",\"vario_plus\":35.12,\"vario_grid\":12.07,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T09:15:00+02:00\",\"end_timestamp\":\"2025-03-31T09:30:00+02:00\",\"vario_plus\":33.73,\"vario_grid\":10.8,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T09:30:00+02:00\",\"end_timestamp\":\"2025-03-31T09:45:00+02:00\",\"vario_plus\":31.52,\"vario_grid\":8.74,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T09:45:00+02:00\",\"end_timestamp\":\"2025-03-31T10:00:00+02:00\",\"vario_plus\":29.78,\"vario_grid\":7.14,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T10:00:00+02:00\",\"end_timestamp\":\"2025-03-31T10:15:00+02:00\",\"vario_plus\":28.4,\"vario_grid\":5.86,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T10:15:00+02:00\",\"end_timestamp\":\"2025-03-31T10:30:00+02:00\",\"vario_plus\":26.51,\"vario_grid\":4.11,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T10:30:00+02:00\",\"end_timestamp\":\"2025-03-31T10:45:00+02:00\",\"vario_plus\":25.03,\"vario_grid\":2.74,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T10:45:00+02:00\",\"end_timestamp\":\"2025-03-31T11:00:00+02:00\",\"vario_plus\":24.47,\"vario_grid\":2.23,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T11:00:00+02:00\",\"end_timestamp\":\"2025-03-31T11:15:00+02:00\",\"vario_plus\":20.45,\"vario_grid\":-1.49,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T11:15:00+02:00\",\"end_timestamp\":\"2025-03-31T11:30:00+02:00\",\"vario_plus\":19.04,\"vario_grid\":-2.8,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T11:30:00+02:00\",\"end_timestamp\":\"2025-03-31T11:45:00+02:00\",\"vario_plus\":18.67,\"vario_grid\":-3.14,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T11:45:00+02:00\",\"end_timestamp\":\"2025-03-31T12:00:00+02:00\",\"vario_plus\":18.23,\"vario_grid\":-3.55,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T12:00:00+02:00\",\"end_timestamp\":\"2025-03-31T12:15:00+02:00\",\"vario_plus\":15.64,\"vario_grid\":-5.94,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T12:15:00+02:00\",\"end_timestamp\":\"2025-03-31T12:30:00+02:00\",\"vario_plus\":15.39,\"vario_grid\":-6.17,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T12:30:00+02:00\",\"end_timestamp\":\"2025-03-31T12:45:00+02:00\",\"vario_plus\":13.66,\"vario_grid\":-7.77,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T12:45:00+02:00\",\"end_timestamp\":\"2025-03-31T13:00:00+02:00\",\"vario_plus\":11.7,\"vario_grid\":-9.58,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T13:00:00+02:00\",\"end_timestamp\":\"2025-03-31T13:15:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T13:15:00+02:00\",\"end_timestamp\":\"2025-03-31T13:30:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T13:30:00+02:00\",\"end_timestamp\":\"2025-03-31T13:45:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T13:45:00+02:00\",\"end_timestamp\":\"2025-03-31T14:00:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T14:00:00+02:00\",\"end_timestamp\":\"2025-03-31T14:15:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T14:15:00+02:00\",\"end_timestamp\":\"2025-03-31T14:30:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T14:30:00+02:00\",\"end_timestamp\":\"2025-03-31T14:45:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T14:45:00+02:00\",\"end_timestamp\":\"2025-03-31T15:00:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T15:00:00+02:00\",\"end_timestamp\":\"2025-03-31T15:15:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T15:15:00+02:00\",\"end_timestamp\":\"2025-03-31T15:30:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T15:30:00+02:00\",\"end_timestamp\":\"2025-03-31T15:45:00+02:00\",\"vario_plus\":11.65,\"vario_grid\":-9.63,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T15:45:00+02:00\",\"end_timestamp\":\"2025-03-31T16:00:00+02:00\",\"vario_plus\":12.04,\"vario_grid\":-9.27,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T16:00:00+02:00\",\"end_timestamp\":\"2025-03-31T16:15:00+02:00\",\"vario_plus\":13.87,\"vario_grid\":-7.58,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T16:15:00+02:00\",\"end_timestamp\":\"2025-03-31T16:30:00+02:00\",\"vario_plus\":15.13,\"vario_grid\":-6.41,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T16:30:00+02:00\",\"end_timestamp\":\"2025-03-31T16:45:00+02:00\",\"vario_plus\":16.41,\"vario_grid\":-5.23,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T16:45:00+02:00\",\"end_timestamp\":\"2025-03-31T17:00:00+02:00\",\"vario_plus\":17.54,\"vario_grid\":-4.18,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T17:00:00+02:00\",\"end_timestamp\":\"2025-03-31T17:15:00+02:00\",\"vario_plus\":17.83,\"vario_grid\":-3.92,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T17:15:00+02:00\",\"end_timestamp\":\"2025-03-31T17:30:00+02:00\",\"vario_plus\":18.91,\"vario_grid\":-2.92,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T17:30:00+02:00\",\"end_timestamp\":\"2025-03-31T17:45:00+02:00\",\"vario_plus\":21.56,\"vario_grid\":-0.46,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T17:45:00+02:00\",\"end_timestamp\":\"2025-03-31T18:00:00+02:00\",\"vario_plus\":23.54,\"vario_grid\":1.37,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T18:00:00+02:00\",\"end_timestamp\":\"2025-03-31T18:15:00+02:00\",\"vario_plus\":27.58,\"vario_grid\":5.11,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T18:15:00+02:00\",\"end_timestamp\":\"2025-03-31T18:30:00+02:00\",\"vario_plus\":29.77,\"vario_grid\":7.13,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T18:30:00+02:00\",\"end_timestamp\":\"2025-03-31T18:45:00+02:00\",\"vario_plus\":31.57,\"vario_grid\":8.79,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T18:45:00+02:00\",\"end_timestamp\":\"2025-03-31T19:00:00+02:00\",\"vario_plus\":33.66,\"vario_grid\":10.73,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T19:00:00+02:00\",\"end_timestamp\":\"2025-03-31T19:15:00+02:00\",\"vario_plus\":35.14,\"vario_grid\":12.1,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T19:15:00+02:00\",\"end_timestamp\":\"2025-03-31T19:30:00+02:00\",\"vario_plus\":36.18,\"vario_grid\":13.06,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T19:30:00+02:00\",\"end_timestamp\":\"2025-03-31T19:45:00+02:00\",\"vario_plus\":37.24,\"vario_grid\":14.04,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T19:45:00+02:00\",\"end_timestamp\":\"2025-03-31T20:00:00+02:00\",\"vario_plus\":37.71,\"vario_grid\":14.48,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T20:00:00+02:00\",\"end_timestamp\":\"2025-03-31T20:15:00+02:00\",\"vario_plus\":37.26,\"vario_grid\":14.06,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T20:15:00+02:00\",\"end_timestamp\":\"2025-03-31T20:30:00+02:00\",\"vario_plus\":37.12,\"vario_grid\":13.93,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T20:30:00+02:00\",\"end_timestamp\":\"2025-03-31T20:45:00+02:00\",\"vario_plus\":37.49,\"vario_grid\":14.27,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T20:45:00+02:00\",\"end_timestamp\":\"2025-03-31T21:00:00+02:00\",\"vario_plus\":36.75,\"vario_grid\":13.58,\"dt_plus\":31.65,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T21:00:00+02:00\",\"end_timestamp\":\"2025-03-31T21:15:00+02:00\",\"vario_plus\":31.88,\"vario_grid\":13.38,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T21:15:00+02:00\",\"end_timestamp\":\"2025-03-31T21:30:00+02:00\",\"vario_plus\":31.69,\"vario_grid\":13.2,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T21:30:00+02:00\",\"end_timestamp\":\"2025-03-31T21:45:00+02:00\",\"vario_plus\":31.07,\"vario_grid\":12.63,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T21:45:00+02:00\",\"end_timestamp\":\"2025-03-31T22:00:00+02:00\",\"vario_plus\":30.26,\"vario_grid\":11.88,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T22:00:00+02:00\",\"end_timestamp\":\"2025-03-31T22:15:00+02:00\",\"vario_plus\":30.23,\"vario_grid\":11.86,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T22:15:00+02:00\",\"end_timestamp\":\"2025-03-31T22:30:00+02:00\",\"vario_plus\":29.43,\"vario_grid\":11.11,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T22:30:00+02:00\",\"end_timestamp\":\"2025-03-31T22:45:00+02:00\",\"vario_plus\":28.71,\"vario_grid\":10.45,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T22:45:00+02:00\",\"end_timestamp\":\"2025-03-31T23:00:00+02:00\",\"vario_plus\":27.9,\"vario_grid\":9.7,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T23:00:00+02:00\",\"end_timestamp\":\"2025-03-31T23:15:00+02:00\",\"vario_plus\":28.67,\"vario_grid\":10.41,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T23:15:00+02:00\",\"end_timestamp\":\"2025-03-31T23:30:00+02:00\",\"vario_plus\":28.46,\"vario_grid\":10.22,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T23:30:00+02:00\",\"end_timestamp\":\"2025-03-31T23:45:00+02:00\",\"vario_plus\":27.78,\"vario_grid\":9.59,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"},{\"start_timestamp\":\"2025-03-31T23:45:00+02:00\",\"end_timestamp\":\"2025-04-01T00:00:00+02:00\",\"vario_plus\":26.98,\"vario_grid\":8.85,\"dt_plus\":21.3,\"unit\":\"Rp./kWh\"}]","payloadType":"json","x":270,"y":40,"wires":[["94777f9549dbf905"]]},{"id":"94777f9549dbf905","type":"ui-chart","z":"d0812e07f4e78e1f","group":"086177714ce3990f","name":"","label":"chart","order":9007199254740991,"chartType":"line","category":"[\"vario_grid\", \"vario_plus\"]","categoryType":"json","xAxisLabel":"","xAxisProperty":"start_timestamp","xAxisPropertyType":"property","xAxisType":"time","xAxisFormat":"","xAxisFormatType":"HH:mm","xmin":"","xmax":"","yAxisLabel":"","yAxisProperty":"payload","yAxisPropertyType":"msg","ymin":"","ymax":"","bins":10,"action":"replace","stackSeries":false,"pointShape":"circle","pointRadius":4,"showLegend":true,"removeOlder":1,"removeOlderUnit":"3600","removeOlderPoints":"","colors":["#0095ff","#ff0000","#ff7f0e","#2ca02c","#a347e1","#d62728","#ff9896","#9467bd","#c5b0d5"],"textColor":["#666666"],"textColorDefault":true,"gridColor":["#e5e5e5"],"gridColorDefault":true,"width":6,"height":8,"className":"","interpolation":"linear","x":450,"y":40,"wires":[[]]},{"id":"086177714ce3990f","type":"ui-group","name":"Chart","page":"0956c4073e2cdfa6","width":"12","height":"1","order":1,"showTitle":true,"className":"","visible":"true","disabled":"false","groupType":"default"},{"id":"0956c4073e2cdfa6","type":"ui-page","name":"Stacked chart","ui":"d45641ed6d39fea1","path":"/stack","icon":"progress-wrench","layout":"flex","theme":"4c9d95876fd3a57d","breakpoints":[{"name":"Default","px":"0","cols":"3"},{"name":"Tablet","px":"576","cols":"6"},{"name":"Small Desktop","px":"768","cols":"9"},{"name":"Desktop","px":"1024","cols":"12"}],"order":10,"className":"","visible":true,"disabled":false},{"id":"d45641ed6d39fea1","type":"ui-base","name":"This is my ui-base","path":"/dashboard","appIcon":"","includeClientData":true,"acceptsClientConfig":["ui-notification","ui-control"],"showPathInSidebar":false,"headerContent":"page","navigationStyle":"default","titleBarStyle":"default","notificationDisplayTime":5},{"id":"4c9d95876fd3a57d","type":"ui-theme","name":"Light","colors":{"surface":"#ffffff","primary":"#0094ce","bgPage":"#eeeeee","groupBg":"#ffffff","groupOutline":"#cccccc"},"sizes":{"pagePadding":"12px","groupGap":"12px","groupBorderRadius":"4px","widgetGap":"12px"}}]

Many thanks jbudd,

What a stupid error: I first tried with Fr./kWh and set the scale accordingly and later tried with cts/kWh and forgot to change the scale! :frowning:
Hence, it worked but nothing was shown due to the scale.

Now it looks as i want to have it:

Now i want to show on the graph at what tariff segment we currently are and I was hoping I could just add a value (vario_current) to the array at segments which have passed already.
So basically I would like the blue curve to be yellow up to the current time of the day.

This is how I tried it, but unfortunately the "vario_current" values do not show up. Do you maybe have a better idea?

[{"id":"b299b520082cda12","type":"group","z":"c0259f4054b12973","name":"Get EV charging values for dashboard","style":{"label":true},"nodes":["3af13defcf892f25","5eb22245b09582d1","c155319ca2e690ba","8a87898f4989cfb1"],"x":34,"y":539,"w":772,"h":122},{"id":"3af13defcf892f25","type":"inject","z":"c0259f4054b12973","g":"b299b520082cda12","name":"Every 30 s","props":[{"p":"payload"}],"repeat":"30","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":150,"y":580,"wires":[["5eb22245b09582d1"]]},{"id":"5eb22245b09582d1","type":"function","z":"c0259f4054b12973","g":"b299b520082cda12","name":"Build sum of values","func":"//this function gets the charging power for all\n//EV's from global and sum's them up\n\nconst EVChargingState = new Object(global.get(\"EVCharging\")); //current charging power of all charging points in an array\nconst TotalChargingPower = Object.values(EVChargingState).reduce((a, b) => a + b, 0); //Sum of charging power of all charging points\n\nmsg.payload = TotalChargingPower;\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":370,"y":580,"wires":[["c155319ca2e690ba","8a87898f4989cfb1"]]},{"id":"c155319ca2e690ba","type":"ui-gauge","z":"c0259f4054b12973","g":"b299b520082cda12","name":"Aktuelle Ladeleistung","group":"1145a4d5fd9ac3a7","order":2,"width":3,"height":3,"gtype":"gauge-half","gstyle":"needle","title":"Aktuelle Ladeleistung","units":"Watt","icon":"","prefix":"","suffix":"","segments":[{"from":"0","color":"#00b500"},{"from":"10000","color":"#fbff00"}],"min":"0","max":"15000","sizeThickness":16,"sizeGap":4,"sizeKeyThickness":8,"styleRounded":true,"styleGlow":false,"className":"","x":680,"y":580,"wires":[]},{"id":"8a87898f4989cfb1","type":"ui-chart","z":"c0259f4054b12973","g":"b299b520082cda12","group":"1145a4d5fd9ac3a7","name":"Ladeleistung in Watt","label":"Ladeleistung in Watt","order":1,"chartType":"line","category":"topic","categoryType":"msg","xAxisLabel":"Tageszeit","xAxisProperty":"","xAxisPropertyType":"timestamp","xAxisType":"time","xAxisFormat":"","xAxisFormatType":"HH:mm","xmin":"","xmax":"","yAxisLabel":"Watt","yAxisProperty":"payload","yAxisPropertyType":"msg","ymin":"0","ymax":"15000","bins":10,"action":"append","stackSeries":false,"pointShape":"line","pointRadius":"1","showLegend":false,"removeOlder":"12","removeOlderUnit":"3600","removeOlderPoints":"","colors":["#00b500","#ff0000","#ff7f0e","#2ca02c","#a347e1","#d62728","#ff9896","#9467bd","#c5b0d5"],"textColor":["#ffffff"],"textColorDefault":false,"gridColor":["#e5e5e5"],"gridColorDefault":false,"width":"3","height":"4","className":"","interpolation":"linear","x":680,"y":620,"wires":[[]]},{"id":"1145a4d5fd9ac3a7","type":"ui-group","name":"Ladeleistung Elektrofahrzeuge","page":"c4ee7ecd338225ac","width":"3","height":"6","order":5,"showTitle":true,"className":"","visible":"true","disabled":"false","groupType":"default"},{"id":"c4ee7ecd338225ac","type":"ui-page","name":"Leistung PV Anlage Hintere Gasse 2/3","ui":"76d5fd200daa146c","path":"/PV Leistung","icon":"home","layout":"grid","theme":"1ef67418aa7b26f5","breakpoints":[{"name":"Default","px":"0","cols":"3"},{"name":"Tablet","px":"576","cols":"6"},{"name":"Small Desktop","px":"768","cols":"9"},{"name":"Desktop","px":"1024","cols":"12"}],"order":1,"className":"","visible":true,"disabled":false},{"id":"76d5fd200daa146c","type":"ui-base","name":"Leistung PV Anlage Hintere Gasse 2/3","path":"/dashboard","appIcon":"","includeClientData":true,"acceptsClientConfig":["ui-notification","ui-control"],"showPathInSidebar":false,"headerContent":"page","navigationStyle":"default","titleBarStyle":"default","showReconnectNotification":true,"notificationDisplayTime":"1","showDisconnectNotification":true},{"id":"1ef67418aa7b26f5","type":"ui-theme","name":"Default Theme","colors":{"surface":"#3f51b5","primary":"#0094ce","bgPage":"#363636","groupBg":"#525252","groupOutline":"#cccccc"},"sizes":{"density":"default","pagePadding":"12px","groupGap":"5px","groupBorderRadius":"12px","widgetGap":"12px"}}]

Many thanks

Heinz

I think you'll need to manipulate the data:

In a function node loop through the array and for every element where the start time is less than current time, change the relevant string to something different.
Now you will have three data sets and have to change the chart config to match.

Ha! Works!

Wanted to make it too complicated by having both values in the modified array at the same time. Now I have either one value or the other and now it works perfectly, the curve is now yellow up to the current time of the day (21:00)!

Revised code:

[{"id":"a24e38778640256c","type":"group","z":"c0259f4054b12973","name":"Display Vario Tariff on Dashboard","style":{"label":true},"nodes":["3c508277fa8b38ea","c936afdaccdd9367","bec0324695906c17","bf6b9aec21496b8e"],"x":34,"y":699,"w":772,"h":142},{"id":"3c508277fa8b38ea","type":"inject","z":"c0259f4054b12973","g":"a24e38778640256c","name":"Every 15mins","props":[{"p":"payload"}],"repeat":"900","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":740,"wires":[["bf6b9aec21496b8e"]]},{"id":"c936afdaccdd9367","type":"debug","z":"c0259f4054b12973","g":"a24e38778640256c","name":"debug 63","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":700,"y":800,"wires":[]},{"id":"bec0324695906c17","type":"ui-chart","z":"c0259f4054b12973","g":"a24e38778640256c","group":"2ee1d37e41b0bdaf","name":"Tarif Information","label":"Tarif Information","order":1,"chartType":"line","category":"[\"vario_plus\",\"dt_plus\", \"vario_current\"]","categoryType":"json","xAxisLabel":"Tageszeit","xAxisProperty":"start_timestamp","xAxisPropertyType":"property","xAxisType":"time","xAxisFormat":"","xAxisFormatType":"HH:mm","xmin":"","xmax":"","yAxisLabel":"Rp. / kWh","yAxisProperty":"payload","yAxisPropertyType":"msg","ymin":"","ymax":"","bins":10,"action":"replace","stackSeries":false,"pointShape":"line","pointRadius":"1","showLegend":true,"removeOlder":"12","removeOlderUnit":"3600","removeOlderPoints":"","colors":["#1f36e5","#ff7f0e","#fbff00","#2ca02c","#a347e1","#d62728","#ff9896","#9467bd","#c5b0d5"],"textColor":["#ffffff"],"textColorDefault":false,"gridColor":["#e5e5e5"],"gridColorDefault":false,"width":"3","height":"6","className":"","interpolation":"linear","x":700,"y":740,"wires":[[]]},{"id":"bf6b9aec21496b8e","type":"function","z":"c0259f4054b12973","g":"a24e38778640256c","name":"Format Data","func":"const JsonData = flow.get(\"TodaysData\").slice(0); //copy of the original tariff data\nvar JsonCopy = [];\nconst CurrentTime = new Date();\n\nfor (var i = 0; i< JsonData.length; i++){\n    JsonCopy[i] = {};\n    JsonCopy[i][\"start_timestamp\"] = JsonData[i][\"start_timestamp\"];\n    JsonCopy[i][\"dt_plus\"] = JsonData[i][\"dt_plus\"];\n\n    if (CurrentTime >= new Date(JsonData[i][\"start_timestamp\"])){\n\n        JsonCopy[i][\"vario_current\"] = JsonData[i][\"vario_plus\"];\n    } else {\n        JsonCopy[i][\"vario_plus\"] = JsonData[i][\"vario_plus\"];    \n    }\n}\n\nmsg.payload = JsonCopy;\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":410,"y":740,"wires":[["c936afdaccdd9367","bec0324695906c17"]]},{"id":"2ee1d37e41b0bdaf","type":"ui-group","name":"Vario Tarif Information","page":"c4ee7ecd338225ac","width":"3","height":"6","order":6,"showTitle":true,"className":"","visible":"true","disabled":"false","groupType":"default"},{"id":"c4ee7ecd338225ac","type":"ui-page","name":"Leistung PV Anlage Hintere Gasse 2/3","ui":"76d5fd200daa146c","path":"/PV Leistung","icon":"home","layout":"grid","theme":"1ef67418aa7b26f5","breakpoints":[{"name":"Default","px":"0","cols":"3"},{"name":"Tablet","px":"576","cols":"6"},{"name":"Small Desktop","px":"768","cols":"9"},{"name":"Desktop","px":"1024","cols":"12"}],"order":1,"className":"","visible":true,"disabled":false},{"id":"76d5fd200daa146c","type":"ui-base","name":"Leistung PV Anlage Hintere Gasse 2/3","path":"/dashboard","appIcon":"","includeClientData":true,"acceptsClientConfig":["ui-notification","ui-control"],"showPathInSidebar":false,"headerContent":"page","navigationStyle":"default","titleBarStyle":"default","showReconnectNotification":true,"notificationDisplayTime":"1","showDisconnectNotification":true},{"id":"1ef67418aa7b26f5","type":"ui-theme","name":"Default Theme","colors":{"surface":"#3f51b5","primary":"#0094ce","bgPage":"#363636","groupBg":"#525252","groupOutline":"#cccccc"},"sizes":{"density":"default","pagePadding":"12px","groupGap":"5px","groupBorderRadius":"12px","widgetGap":"12px"}}]

Many, many thanks for your phantastic help!

Heinz

You could probably draw a vertical line on the chart at the current time too. After Looping through the array, add two additional elements where start_timestamp is the current timestamp and "now" is 0 and with start_timestamp current timestamp plus a minute and "now" is 40.
I have not tried it!

Many thanks jbudd,

No need for anything more, I now called the yellow part "Progress" and that shows the progress on the tariff good enough I think. :slight_smile:

Again, big thanks for your awesome help!
Best regards
Heinz

1 Like