How to populate multiple values in a graph?

Dashboard
1

Hi guys! I tried to go through all threads but did not find anything similar, I appologize if this subject already exists.
Well, I have a Tibber subscription. Tibber is a scandinavian electricity provider with a smart edge. I can see the electricity prices (spot price) hourly for this day, and after 12:00 also tomorrow's prices per hour.
When using Tibber's node, it returns these values successfully (thanks @ristomatti). But I am not sure how to use this values in a graph. I would be very grateful if someone can help to understand this, and I can probably find myself around from there?!
The graph should be based on time (hour) and the "Total" value that is returned below (not "Energy" or "Tax"). The values are arranged in different tags, like [0-9], [10-19] and so on.
Returned msg payload:

image
image1207×725 137 KB

 [{"id":"9af8501c.86c62","type":"tab","label":"Tibber","disabled":false,"info":""},{"id":"28e8800c.7a4d2","type":"tibber-query","z":"9af8501c.86c62","name":"","active":true,"apiEndpointRef":"d0fc33a0.73afe","x":910,"y":700,"wires":[["209e193c.d1cff6"]]},{"id":"958ff0ae.8eae3","type":"inject","z":"9af8501c.86c62","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"*/30 0-23 * * *","once":false,"onceDelay":0.1,"x":190,"y":420,"wires":[["86b39cb5.d2075"]]},{"id":"209e193c.d1cff6","type":"debug","z":"9af8501c.86c62","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":1070,"y":700,"wires":[]},{"id":"7629d65.defa428","type":"template","z":"9af8501c.86c62","name":"current prices query","field":"payload","fieldType":"msg","format":"text","syntax":"plain","template":"{\n  viewer {\n    homes {\n      currentSubscription{\n        priceInfo{\n          current{\n            total\n            energy\n            tax\n            startsAt\n          }\n        }\n      }\n    }\n  }\n}","output":"str","x":680,"y":700,"wires":[["28e8800c.7a4d2"]]},{"id":"6c95d13b.c5029","type":"template","z":"9af8501c.86c62","name":"Today's prices","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{\n  viewer {\n    homes {\n      currentSubscription{\n        priceInfo{\n          today{\n            total\n            energy\n            tax\n            startsAt\n          }\n        }\n      }\n    }\n  }\n}","output":"str","x":700,"y":860,"wires":[["59f615e5.40eddc"]]},{"id":"15fe3175.61bd4f","type":"template","z":"9af8501c.86c62","name":"Tomorrow's prices","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{\n  viewer {\n    homes {\n      currentSubscription{\n        priceInfo{\n          tomorrow{\n            total\n            energy\n            tax\n            startsAt\n          }\n        }\n      }\n    }\n  }\n}","output":"str","x":710,"y":980,"wires":[["13c294ac.270b7b"]]},{"id":"59f615e5.40eddc","type":"tibber-query","z":"9af8501c.86c62","name":"","active":true,"apiEndpointRef":"d0fc33a0.73afe","x":910,"y":860,"wires":[["7134f476.8f6b4c","a7e31730.563948"]]},{"id":"13c294ac.270b7b","type":"tibber-query","z":"9af8501c.86c62","name":"","active":true,"apiEndpointRef":"d0fc33a0.73afe","x":910,"y":980,"wires":[["f8ea6359.f86ce"]]},{"id":"7134f476.8f6b4c","type":"debug","z":"9af8501c.86c62","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":1110,"y":860,"wires":[]},{"id":"f8ea6359.f86ce","type":"debug","z":"9af8501c.86c62","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":1110,"y":980,"wires":[]},{"id":"a7e31730.563948","type":"ui_chart","z":"9af8501c.86c62","name":"elpriser idag","group":"76145810.90bbb8","order":4,"width":"4","height":"4","label":"Elpriser idag","chartType":"line","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":1110,"y":820,"wires":[[]]},{"id":"8c2a5484.f66bb8","type":"ui_chart","z":"9af8501c.86c62","name":"elpriser imorgon","group":"76145810.90bbb8","order":5,"width":"4","height":"4","label":"Elpriser imorgon","chartType":"line","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":1130,"y":940,"wires":[[]]},{"id":"92e7516e.59bb7","type":"ui_gauge","z":"9af8501c.86c62","name":"elpris nu","group":"76145810.90bbb8","order":0,"width":0,"height":0,"gtype":"gage","title":"Elpris nu","label":"","format":"{{value}}","min":0,"max":"1","colors":["#00b500","#e6e600","#ca3838"],"seg1":"0,19","seg2":"0,39","x":940,"y":280,"wires":[]},{"id":"739cd6c4.9202b8","type":"template","z":"9af8501c.86c62","name":"current prices query","field":"payload","fieldType":"msg","format":"text","syntax":"plain","template":"{\n  viewer {\n    homes {\n      currentSubscription{\n        priceInfo{\n          current{\n            total\n          }\n        }\n      }\n    }\n  }\n}","output":"str","x":760,"y":220,"wires":[["6bed56b3.d887d8"]]},{"id":"6bed56b3.d887d8","type":"tibber-query","z":"9af8501c.86c62","name":"","active":true,"apiEndpointRef":"d0fc33a0.73afe","x":770,"y":280,"wires":[["92e7516e.59bb7","a0e649c3.5ac7c8"]]},{"id":"a0e649c3.5ac7c8","type":"debug","z":"9af8501c.86c62","name":"pris till graf","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":950,"y":320,"wires":[],"inputLabels":["Elpris"]},{"id":"86b39cb5.d2075","type":"delay","z":"9af8501c.86c62","name":"","pauseType":"delay","timeout":"10","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":340,"y":420,"wires":[["739cd6c4.9202b8","7629d65.defa428","6c95d13b.c5029","15fe3175.61bd4f","6031a89c.3f2e98"]]},{"id":"6031a89c.3f2e98","type":"ui_toast","z":"9af8501c.86c62","position":"bottom right","displayTime":"5","highlight":"","sendall":true,"outputs":0,"ok":"OK","cancel":"","raw":false,"topic":"Priser uppdaterade","name":"Priser uppdaterade","x":230,"y":600,"wires":[]},{"id":"d0fc33a0.73afe","type":"tibber-api-endpoint","z":"","feedUrl":"wss://api.tibber.com/v1-beta/gql/subscriptions","queryUrl":"https://api.tibber.com/v1-beta/gql","name":"My Tibber account","info":"{\r\n  viewer {\r\n    homes {\r\n      currentSubscription{\r\n        priceInfo{\r\n          current{\r\n            total\r\n            energy\r\n            tax\r\n            startsAt\r\n          }\r\n        }\r\n      }\r\n    }\r\n  }\r\n}"},{"id":"76145810.90bbb8","type":"ui_group","z":"","name":"Elpriser","tab":"dc0faa70.1cf2c8","order":1,"disp":true,"width":"4","collapse":false},{"id":"dc0faa70.1cf2c8","type":"ui_tab","z":"","name":"Tibber","icon":"dashboard","order":3,"disabled":false,"hidden":false}]
2

You'll need to edit your post to properly format the flow export, otherwise it cannot be imported. See How to share code or flow json for info on how to do it.

3

(I edited the flow so it can be imported)

If you can reproduce the issue without the tibber nodes, it will be easier for someone to help you. You should try to create some dummy data to reflect your issue.

4

Sorry guys, I thought I did that according to the FAQ, but I didn't.

I have duplicated the flows but set it up with a demo token, so you will be able to fetch more or less the same values that I can.

[{"id":"d2e76b02.8ef1c8","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"fa10db26.cf6df8","type":"tibber-query","z":"d2e76b02.8ef1c8","name":"","active":true,"apiEndpointRef":"d0fc33a0.73afe","x":750,"y":160,"wires":[["351e2744.8b66e8"]]},{"id":"6eeef48c.c3b2dc","type":"inject","z":"d2e76b02.8ef1c8","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"*/30 0-23 * * *","once":false,"onceDelay":0.1,"x":170,"y":220,"wires":[["e24569e1.9bc748"]]},{"id":"351e2744.8b66e8","type":"debug","z":"d2e76b02.8ef1c8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":910,"y":160,"wires":[]},{"id":"5bc0a601.04efc8","type":"template","z":"d2e76b02.8ef1c8","name":"current prices query","field":"payload","fieldType":"msg","format":"text","syntax":"plain","template":"{\n  viewer {\n    homes {\n      currentSubscription{\n        priceInfo{\n          current{\n            total\n            energy\n            tax\n            startsAt\n          }\n        }\n      }\n    }\n  }\n}","output":"str","x":520,"y":160,"wires":[["fa10db26.cf6df8"]]},{"id":"93136d0.d5d0a9","type":"template","z":"d2e76b02.8ef1c8","name":"Today's prices","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{\n  viewer {\n    homes {\n      currentSubscription{\n        priceInfo{\n          today{\n            total\n            energy\n            tax\n            startsAt\n          }\n        }\n      }\n    }\n  }\n}","output":"str","x":540,"y":320,"wires":[["6f472881.fcff78"]]},{"id":"26c02ae9.3c6686","type":"template","z":"d2e76b02.8ef1c8","name":"Tomorrow's prices","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"{\n  viewer {\n    homes {\n      currentSubscription{\n        priceInfo{\n          tomorrow{\n            total\n            energy\n            tax\n            startsAt\n          }\n        }\n      }\n    }\n  }\n}","output":"str","x":550,"y":440,"wires":[["b5dd9ff8.ff94f"]]},{"id":"6f472881.fcff78","type":"tibber-query","z":"d2e76b02.8ef1c8","name":"","active":true,"apiEndpointRef":"d0fc33a0.73afe","x":750,"y":320,"wires":[["1e957589.00c9aa","1536cc30.726094"]]},{"id":"b5dd9ff8.ff94f","type":"tibber-query","z":"d2e76b02.8ef1c8","name":"","active":true,"apiEndpointRef":"d0fc33a0.73afe","x":750,"y":440,"wires":[["1c60736f.3538fd"]]},{"id":"1e957589.00c9aa","type":"debug","z":"d2e76b02.8ef1c8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":950,"y":320,"wires":[]},{"id":"1c60736f.3538fd","type":"debug","z":"d2e76b02.8ef1c8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","x":950,"y":440,"wires":[]},{"id":"1536cc30.726094","type":"ui_chart","z":"d2e76b02.8ef1c8","name":"elpriser idag","group":"76145810.90bbb8","order":4,"width":"4","height":"4","label":"Elpriser idag","chartType":"line","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":950,"y":280,"wires":[[]]},{"id":"402d5e93.b79d9","type":"ui_chart","z":"d2e76b02.8ef1c8","name":"elpriser imorgon","group":"76145810.90bbb8","order":5,"width":"4","height":"4","label":"Elpriser imorgon","chartType":"line","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":970,"y":400,"wires":[[]]},{"id":"e24569e1.9bc748","type":"delay","z":"d2e76b02.8ef1c8","name":"","pauseType":"delay","timeout":"10","timeoutUnits":"seconds","rate":"1","nbRateUnits":"1","rateUnits":"second","randomFirst":"1","randomLast":"5","randomUnits":"seconds","drop":false,"x":180,"y":300,"wires":[["5bc0a601.04efc8","93136d0.d5d0a9","26c02ae9.3c6686"]]},{"id":"d0fc33a0.73afe","type":"tibber-api-endpoint","z":"","feedUrl":"wss://api.tibber.com/v1-beta/gql/subscriptions","queryUrl":"https://api.tibber.com/v1-beta/gql","name":"Tibber demo account","info":"{\r\n  viewer {\r\n    homes {\r\n      currentSubscription{\r\n        priceInfo{\r\n          current{\r\n            total\r\n            energy\r\n            tax\r\n            startsAt\r\n          }\r\n        }\r\n      }\r\n    }\r\n  }\r\n}"},{"id":"76145810.90bbb8","type":"ui_group","z":"","name":"Elpriser","tab":"dc0faa70.1cf2c8","order":1,"disp":true,"width":"4","collapse":false},{"id":"dc0faa70.1cf2c8","type":"ui_tab","z":"","name":"Tibber","icon":"dashboard","order":3,"disabled":false,"hidden":false}]

There is also an awesome API Explorer that can be used, but it is maybe not relevent for this. The attached flow will result in three massages:
Current price
Todays prices
Tomorrow's prices (only available after 12:00 each day).

As I described in the first post, they are presented in a certain way, and I would like to get more information on how to present this in a graph instead. Like price/hour for today, and tomorrow when those prices are available.

5

Since flow exports do not export credentials, I can't test your flow.

What you need to do is put a debug node (set to display Complete msg object) on the output of the tibber node which will show the data retrieved. You can then use the copy button to copy all the data and provide that to show the data you are trying to plot.

6

Hi @zenofmud, that is strange. I thought it would work since Tibber provides a demo API to test with. Anyway, I hope I was able to export the output exactly how you like it.

{"viewer":{"homes":[{"currentSubscription":{"priceInfo":{"today":[{"total":0.1624,"energy":0.1104,"tax":0.052,"startsAt":"2020-07-02T00:00:00+02:00"},{"total":0.1299,"energy":0.0844,"tax":0.0455,"startsAt":"2020-07-02T01:00:00+02:00"},{"total":0.111,"energy":0.0693,"tax":0.0417,"startsAt":"2020-07-02T02:00:00+02:00"},{"total":0.1072,"energy":0.0662,"tax":0.041,"startsAt":"2020-07-02T03:00:00+02:00"},{"total":0.1213,"energy":0.0776,"tax":0.0437,"startsAt":"2020-07-02T04:00:00+02:00"},{"total":0.1466,"energy":0.0978,"tax":0.0488,"startsAt":"2020-07-02T05:00:00+02:00"},{"total":0.1867,"energy":0.1299,"tax":0.0568,"startsAt":"2020-07-02T06:00:00+02:00"},{"total":0.2217,"energy":0.1579,"tax":0.0638,"startsAt":"2020-07-02T07:00:00+02:00"},{"total":0.2606,"energy":0.189,"tax":0.0716,"startsAt":"2020-07-02T08:00:00+02:00"},{"total":0.2571,"energy":0.1862,"tax":0.0709,"startsAt":"2020-07-02T09:00:00+02:00"},{"total":0.2783,"energy":0.2032,"tax":0.0751,"startsAt":"2020-07-02T10:00:00+02:00"},{"total":0.2592,"energy":0.1879,"tax":0.0713,"startsAt":"2020-07-02T11:00:00+02:00"},{"total":0.2445,"energy":0.1761,"tax":0.0684,"startsAt":"2020-07-02T12:00:00+02:00"},{"total":0.2288,"energy":0.1635,"tax":0.0653,"startsAt":"2020-07-02T13:00:00+02:00"},{"total":0.2234,"energy":0.1592,"tax":0.0642,"startsAt":"2020-07-02T14:00:00+02:00"},{"total":0.215,"energy":0.1525,"tax":0.0625,"startsAt":"2020-07-02T15:00:00+02:00"},{"total":0.2103,"energy":0.1488,"tax":0.0615,"startsAt":"2020-07-02T16:00:00+02:00"},{"total":0.2082,"energy":0.1471,"tax":0.0611,"startsAt":"2020-07-02T17:00:00+02:00"},{"total":0.2047,"energy":0.1442,"tax":0.0605,"startsAt":"2020-07-02T18:00:00+02:00"},{"total":0.199,"energy":0.1397,"tax":0.0593,"startsAt":"2020-07-02T19:00:00+02:00"},{"total":0.193,"energy":0.1349,"tax":0.0581,"startsAt":"2020-07-02T20:00:00+02:00"},{"total":0.1867,"energy":0.1299,"tax":0.0568,"startsAt":"2020-07-02T21:00:00+02:00"},{"total":0.1743,"energy":0.1199,"tax":0.0544,"startsAt":"2020-07-02T22:00:00+02:00"},{"total":0.1579,"energy":0.1068,"tax":0.0511,"startsAt":"2020-07-02T23:00:00+02:00"}]}}}]}}

I hope it isn't to complicated. Each "line" consists of a certain date and hour (like 2020-07-02T23:00:00) where three different prices (total, energy, tax) are valid. In my case, I am only interested in displaying the "Total" value.

7

I'll give you a push to help you solve your issue. Forget the tibber node for the moment.

Add an inject node and set the payload using {} JSON and insert the data you just provided into it.

Next add a change node after the inject node and set it up like this:

Screen Shot 2020-07-02 at 8.30.30 AM
Screen Shot 2020-07-02 at 8.30.30 AM1141×601 62.3 KB

Now msg.payload will contain the array of data. So not you just need to format it the way you want.

I'll be gone for about an hour and a half so that should give you time to play with it.

8

Awesome, I will also step outside for a moment, but I will definetely have a look on this. Thanks!

9

Not sure what is the source of error here, I have tried a couple of times but I don't seem to get the same return from msg.payload:
Injector with JSON (copied from my input from my post):

image
image1164×360 14.5 KB

Change-node according to your input:

image
image1075×595 20.4 KB

I do get the array of data but lower down in the structure:

image
image549×596 14.7 KB

Maybe that is not an issue, but I would like to get the same output as you do in order to move forward.
I am so sorry to not be able to get this going, I am very eager to learn!!

10

Maybe there isn't a simple solution for this, and in that case we don't need to bother. :slight_smile:
But it is possible to just have the Total value and the date/time returned, it is just a matter of inserting that in a graph on the x and y axle. How hard can it be? :joy:
Would it make things easier if we could present the values straight up instead of using 0: object, 1: object etc?

11

Attach a copy of your flow so I can see what you have done

12

Maybe this would be enough?

[{"id":"fa542be4.1153c8","type":"inject","z":"d2e76b02.8ef1c8","name":"","topic":"","payload":"{\"viewer\":{\"homes\":[{\"currentSubscription\":{\"priceInfo\":{\"today\":[{\"total\":0.1624,\"energy\":0.1104,\"tax\":0.052,\"startsAt\":\"2020-07-02T00:00:00+02:00\"},{\"total\":0.1299,\"energy\":0.0844,\"tax\":0.0455,\"startsAt\":\"2020-07-02T01:00:00+02:00\"},{\"total\":0.111,\"energy\":0.0693,\"tax\":0.0417,\"startsAt\":\"2020-07-02T02:00:00+02:00\"},{\"total\":0.1072,\"energy\":0.0662,\"tax\":0.041,\"startsAt\":\"2020-07-02T03:00:00+02:00\"},{\"total\":0.1213,\"energy\":0.0776,\"tax\":0.0437,\"startsAt\":\"2020-07-02T04:00:00+02:00\"},{\"total\":0.1466,\"energy\":0.0978,\"tax\":0.0488,\"startsAt\":\"2020-07-02T05:00:00+02:00\"},{\"total\":0.1867,\"energy\":0.1299,\"tax\":0.0568,\"startsAt\":\"2020-07-02T06:00:00+02:00\"},{\"total\":0.2217,\"energy\":0.1579,\"tax\":0.0638,\"startsAt\":\"2020-07-02T07:00:00+02:00\"},{\"total\":0.2606,\"energy\":0.189,\"tax\":0.0716,\"startsAt\":\"2020-07-02T08:00:00+02:00\"},{\"total\":0.2571,\"energy\":0.1862,\"tax\":0.0709,\"startsAt\":\"2020-07-02T09:00:00+02:00\"},{\"total\":0.2783,\"energy\":0.2032,\"tax\":0.0751,\"startsAt\":\"2020-07-02T10:00:00+02:00\"},{\"total\":0.2592,\"energy\":0.1879,\"tax\":0.0713,\"startsAt\":\"2020-07-02T11:00:00+02:00\"},{\"total\":0.2445,\"energy\":0.1761,\"tax\":0.0684,\"startsAt\":\"2020-07-02T12:00:00+02:00\"},{\"total\":0.2288,\"energy\":0.1635,\"tax\":0.0653,\"startsAt\":\"2020-07-02T13:00:00+02:00\"},{\"total\":0.2234,\"energy\":0.1592,\"tax\":0.0642,\"startsAt\":\"2020-07-02T14:00:00+02:00\"},{\"total\":0.215,\"energy\":0.1525,\"tax\":0.0625,\"startsAt\":\"2020-07-02T15:00:00+02:00\"},{\"total\":0.2103,\"energy\":0.1488,\"tax\":0.0615,\"startsAt\":\"2020-07-02T16:00:00+02:00\"},{\"total\":0.2082,\"energy\":0.1471,\"tax\":0.0611,\"startsAt\":\"2020-07-02T17:00:00+02:00\"},{\"total\":0.2047,\"energy\":0.1442,\"tax\":0.0605,\"startsAt\":\"2020-07-02T18:00:00+02:00\"},{\"total\":0.199,\"energy\":0.1397,\"tax\":0.0593,\"startsAt\":\"2020-07-02T19:00:00+02:00\"},{\"total\":0.193,\"energy\":0.1349,\"tax\":0.0581,\"startsAt\":\"2020-07-02T20:00:00+02:00\"},{\"total\":0.1867,\"energy\":0.1299,\"tax\":0.0568,\"startsAt\":\"2020-07-02T21:00:00+02:00\"},{\"total\":0.1743,\"energy\":0.1199,\"tax\":0.0544,\"startsAt\":\"2020-07-02T22:00:00+02:00\"},{\"total\":0.1579,\"energy\":0.1068,\"tax\":0.0511,\"startsAt\":\"2020-07-02T23:00:00+02:00\"}]}}}]}}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":70,"y":200,"wires":[["76c97b30.84c944"]]},{"id":"76c97b30.84c944","type":"change","z":"d2e76b02.8ef1c8","name":"","rules":[{"t":"set","p":"payload-original","pt":"msg","to":"payload","tot":"msg"},{"t":"set","p":"payload","pt":"msg","to":"payload.viewer.homes[0].currentSubscription.priceinfo.today","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":280,"y":200,"wires":[["14955ee7.8b5231","810f8001.37fc4"]]},{"id":"14955ee7.8b5231","type":"debug","z":"d2e76b02.8ef1c8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":520,"y":200,"wires":[]},{"id":"810f8001.37fc4","type":"ui_chart","z":"d2e76b02.8ef1c8","name":"elpriser imorgon","group":"76145810.90bbb8","order":5,"width":"4","height":"4","label":"Elpriser idag test","chartType":"horizontalBar","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":540,"y":300,"wires":[[]]},{"id":"76145810.90bbb8","type":"ui_group","z":"","name":"Elpriser","tab":"dc0faa70.1cf2c8","order":1,"disp":true,"width":"4","collapse":false},{"id":"dc0faa70.1cf2c8","type":"ui_tab","z":"","name":"Tibber","icon":"dashboard","order":4,"disabled":false,"hidden":false}]
13

You have a typo in the change node. Case is important!

  • currentSubscription.priceinfo.today

should be

  • currentSubscription.priceInfo.today
14

You will need to reformat your data to display it , here is an example.

[{"id":"e4262229.7b7828","type":"inject","z":"ea03ca5a.9fe438","name":"","topic":"","payload":"{\"viewer\":{\"homes\":[{\"currentSubscription\":{\"priceInfo\":{\"today\":[{\"total\":0.1624,\"energy\":0.1104,\"tax\":0.052,\"startsAt\":\"2020-07-02T00:00:00+02:00\"},{\"total\":0.1299,\"energy\":0.0844,\"tax\":0.0455,\"startsAt\":\"2020-07-02T01:00:00+02:00\"},{\"total\":0.111,\"energy\":0.0693,\"tax\":0.0417,\"startsAt\":\"2020-07-02T02:00:00+02:00\"},{\"total\":0.1072,\"energy\":0.0662,\"tax\":0.041,\"startsAt\":\"2020-07-02T03:00:00+02:00\"},{\"total\":0.1213,\"energy\":0.0776,\"tax\":0.0437,\"startsAt\":\"2020-07-02T04:00:00+02:00\"},{\"total\":0.1466,\"energy\":0.0978,\"tax\":0.0488,\"startsAt\":\"2020-07-02T05:00:00+02:00\"},{\"total\":0.1867,\"energy\":0.1299,\"tax\":0.0568,\"startsAt\":\"2020-07-02T06:00:00+02:00\"},{\"total\":0.2217,\"energy\":0.1579,\"tax\":0.0638,\"startsAt\":\"2020-07-02T07:00:00+02:00\"},{\"total\":0.2606,\"energy\":0.189,\"tax\":0.0716,\"startsAt\":\"2020-07-02T08:00:00+02:00\"},{\"total\":0.2571,\"energy\":0.1862,\"tax\":0.0709,\"startsAt\":\"2020-07-02T09:00:00+02:00\"},{\"total\":0.2783,\"energy\":0.2032,\"tax\":0.0751,\"startsAt\":\"2020-07-02T10:00:00+02:00\"},{\"total\":0.2592,\"energy\":0.1879,\"tax\":0.0713,\"startsAt\":\"2020-07-02T11:00:00+02:00\"},{\"total\":0.2445,\"energy\":0.1761,\"tax\":0.0684,\"startsAt\":\"2020-07-02T12:00:00+02:00\"},{\"total\":0.2288,\"energy\":0.1635,\"tax\":0.0653,\"startsAt\":\"2020-07-02T13:00:00+02:00\"},{\"total\":0.2234,\"energy\":0.1592,\"tax\":0.0642,\"startsAt\":\"2020-07-02T14:00:00+02:00\"},{\"total\":0.215,\"energy\":0.1525,\"tax\":0.0625,\"startsAt\":\"2020-07-02T15:00:00+02:00\"},{\"total\":0.2103,\"energy\":0.1488,\"tax\":0.0615,\"startsAt\":\"2020-07-02T16:00:00+02:00\"},{\"total\":0.2082,\"energy\":0.1471,\"tax\":0.0611,\"startsAt\":\"2020-07-02T17:00:00+02:00\"},{\"total\":0.2047,\"energy\":0.1442,\"tax\":0.0605,\"startsAt\":\"2020-07-02T18:00:00+02:00\"},{\"total\":0.199,\"energy\":0.1397,\"tax\":0.0593,\"startsAt\":\"2020-07-02T19:00:00+02:00\"},{\"total\":0.193,\"energy\":0.1349,\"tax\":0.0581,\"startsAt\":\"2020-07-02T20:00:00+02:00\"},{\"total\":0.1867,\"energy\":0.1299,\"tax\":0.0568,\"startsAt\":\"2020-07-02T21:00:00+02:00\"},{\"total\":0.1743,\"energy\":0.1199,\"tax\":0.0544,\"startsAt\":\"2020-07-02T22:00:00+02:00\"},{\"total\":0.1579,\"energy\":0.1068,\"tax\":0.0511,\"startsAt\":\"2020-07-02T23:00:00+02:00\"}]}}}]}}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":270,"y":240,"wires":[["4c583ba9.2813ac"]]},{"id":"4c583ba9.2813ac","type":"function","z":"ea03ca5a.9fe438","name":"","func":"msg.topic = msg.payload.viewer.homes[0].currentSubscription.priceInfo.today[0].startsAt.split(\":00+\")[0].split(\"T\")[0];\nmsg.payloadorg = msg.payload;\nmsg.payload = [{\"series\":[\"Totals\"], \"data\": [[]], \"labels\": []}];\nfor ( var i in msg.payloadorg.viewer.homes[0].currentSubscription.priceInfo.today){\n  msg.payload[0].data[0][i]  = msg.payloadorg.viewer.homes[0].currentSubscription.priceInfo.today[i].total;\n  msg.payload[0].labels[i] = msg.payloadorg.viewer.homes[0].currentSubscription.priceInfo.today[i].startsAt.split(\":00+\")[0].split(\"T\")[1];\n}\nreturn msg;","outputs":1,"noerr":0,"x":390,"y":240,"wires":[["6ca24d1e.60f02c"]]},{"id":"6ca24d1e.60f02c","type":"ui_chart","z":"ea03ca5a.9fe438","name":"elpriser imorgon","group":"aab6cb81.d1aa5","order":5,"width":"4","height":"8","label":"{{msg.topic}}","chartType":"horizontalBar","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":560,"y":240,"wires":[["c418a275.963478"]]},{"id":"c418a275.963478","type":"debug","z":"ea03ca5a.9fe438","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":730,"y":240,"wires":[]},{"id":"aab6cb81.d1aa5","type":"ui_group","z":"","name":"Elpriser","tab":"c861607d.842248","order":1,"disp":true,"width":"4","collapse":false},{"id":"c861607d.842248","type":"ui_tab","z":"","name":"Tibber","icon":"dashboard","order":4,"disabled":false,"hidden":false}]

And here are examples of formatting

15

Oh wtf?! Sorry, my bad...when correcting that, it works as you showed me. A good step forward

16

Yes, thanks, this is probably something I need to adress. I will only have two values, time and total cost, on x and y axle respecively.

One concern I have is that the input now contains of old values, from an earlier date. I need more dynamic values, like fetch new ones every day

17

You can clear the chart with and empty array as payload, so to clear the info just use node.send({"payload": []}); ,

18

Thanks, actually I was able to retrieve that information. I was more concernec about the current input, like:
[{"id":"fa542be4.1153c8","type":"inject","z":"d2e76b02.8ef1c8","name":"","topic":"","payload":"{"viewer":{"homes":[{"currentSubscription":{"priceInfo":{"today":[{"total":0.1624,"energy":0.1104,"tax":0.052,"startsAt":"2020-07-02T00:00:00+02:00"}

This a "fixed" value that we pasted in order to see how the output looked like, this information needs to be replaced every day (preferrably after 00:00)

19

You can use the inject node to auto inject at set time and then use Tibber node to query and fetch the require data.

20

Nice! I will check if I can make a proper graph with the input I got from you! Thanks!