Dashboard 2.0 Chart not showing timestamped data from mysql

Dashboard
, ,
21

It's not really relevant, because originally it wasn't there, and adding it changed nothing, but here you are:

Screenshot 2025-10-17 171117
Screenshot 2025-10-17 171117511Ɨ336 19.3 KB

It was suggested on some forum as a method to make the msg object have only msg.payload, and no other msg.xxxx. As I said, it makes no difference to the outcome whether I have it in the flow or not.

22

That change node does nothing. It leaves other properties as they were. Try using the function node as I suggested, that will remove all other properties.

23

OK, it seems I was looking at the wrong thing.

24

Also try setting the x axis time limit to 52 weeks. It should not make a difference, it should take no notice of that when using Replace mode, but I think there may be a bug there. That should at least stop the data from being cleared on page refresh.

25

The x-axis limit was at default, 1 hour, and yet it happily displayed a day and even a full week. I've changed it to 52 weeks, no dice. But yes, it does stop the data being cleared on refresh.

I used a function node as you suggested, the topic was stripped, no change.

26

Well at least we have got to the bottom of that part of the problem. There will be some improvements on how that works in, hopefully, the next release.

Can you import this and see how it performs. Don't change anything before trying it please. Click the Test data inject node to run it.

[{"id":"499faac5dd30f2d1","type":"inject","z":"997da33a0beedade","name":"Clear chart","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[]","payloadType":"json","x":380,"y":4940,"wires":[["d532784a4045c2da","22ec42a80412beb0"]]},{"id":"5fde1e2b394cd67b","type":"inject","z":"997da33a0beedade","name":"Test data","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"Time\":1759856450000,\"Temp\":19.4,\"Humid\":60.04},{\"Time\":1759856510000,\"Temp\":19.43,\"Humid\":60.12},{\"Time\":1759856570000,\"Temp\":19.56,\"Humid\":59.98},{\"Time\":1759856630000,\"Temp\":19.59,\"Humid\":59.51},{\"Time\":1759856690000,\"Temp\":19.46,\"Humid\":59.29},{\"Time\":1759856750000,\"Temp\":19.35,\"Humid\":60},{\"Time\":1759856810000,\"Temp\":19.39,\"Humid\":60.1},{\"Time\":1759856870000,\"Temp\":19.49,\"Humid\":59.98},{\"Time\":1759856930000,\"Temp\":19.59,\"Humid\":59.8},{\"Time\":1759856990000,\"Temp\":19.56,\"Humid\":59.21},{\"Time\":1759857050000,\"Temp\":19.32,\"Humid\":59.69},{\"Time\":1759857110000,\"Temp\":19.35,\"Humid\":60.06},{\"Time\":1759857170000,\"Temp\":19.44,\"Humid\":60.04},{\"Time\":1759857230000,\"Temp\":19.53,\"Humid\":59.87},{\"Time\":1759857290000,\"Temp\":19.57,\"Humid\":59.3},{\"Time\":1759857350000,\"Temp\":19.37,\"Humid\":59.42},{\"Time\":1759857410000,\"Temp\":19.33,\"Humid\":60.07},{\"Time\":1759857470000,\"Temp\":19.4,\"Humid\":60.02},{\"Time\":1759857530000,\"Temp\":19.53,\"Humid\":59.89},{\"Time\":1759857590000,\"Temp\":19.6,\"Humid\":59.49},{\"Time\":1759857650000,\"Temp\":19.43,\"Humid\":59.23},{\"Time\":1759857710000,\"Temp\":19.33,\"Humid\":59.92},{\"Time\":1759857770000,\"Temp\":19.37,\"Humid\":59.98},{\"Time\":1759857830000,\"Temp\":19.46,\"Humid\":59.91},{\"Time\":1759857890000,\"Temp\":19.59,\"Humid\":59.71},{\"Time\":1759857950000,\"Temp\":19.47,\"Humid\":59.13},{\"Time\":1759858010000,\"Temp\":19.33,\"Humid\":59.58},{\"Time\":1759858070000,\"Temp\":19.37,\"Humid\":59.94},{\"Time\":1759858130000,\"Temp\":19.46,\"Humid\":59.9},{\"Time\":1759858190000,\"Temp\":19.57,\"Humid\":59.77},{\"Time\":1759858250000,\"Temp\":19.56,\"Humid\":59.16},{\"Time\":1759858310000,\"Temp\":19.35,\"Humid\":59.26},{\"Time\":1759858370000,\"Temp\":19.33,\"Humid\":59.92},{\"Time\":1759858430000,\"Temp\":19.4,\"Humid\":59.99},{\"Time\":1759858490000,\"Temp\":19.49,\"Humid\":59.85},{\"Time\":1759858550000,\"Temp\":19.59,\"Humid\":59.58},{\"Time\":1759858610000,\"Temp\":19.39,\"Humid\":59.31},{\"Time\":1759858670000,\"Temp\":19.31,\"Humid\":59.81},{\"Time\":1759858730000,\"Temp\":19.39,\"Humid\":59.9},{\"Time\":1759858790000,\"Temp\":19.46,\"Humid\":59.85},{\"Time\":1759858850000,\"Temp\":19.57,\"Humid\":59.71},{\"Time\":1759858910000,\"Temp\":19.52,\"Humid\":59.17},{\"Time\":1759858970000,\"Temp\":19.28,\"Humid\":59.55},{\"Time\":1759859030000,\"Temp\":19.33,\"Humid\":59.99},{\"Time\":1759859090000,\"Temp\":19.42,\"Humid\":59.89},{\"Time\":1759859151000,\"Temp\":19.52,\"Humid\":59.81},{\"Time\":1759859211000,\"Temp\":19.54,\"Humid\":59.39},{\"Time\":1759859271000,\"Temp\":19.39,\"Humid\":59.31},{\"Time\":1759859331000,\"Temp\":19.33,\"Humid\":59.94},{\"Time\":1759859391000,\"Temp\":19.35,\"Humid\":59.94},{\"Time\":1759859451000,\"Temp\":19.47,\"Humid\":59.81},{\"Time\":1759859511000,\"Temp\":19.6,\"Humid\":59.63},{\"Time\":1759859571000,\"Temp\":19.49,\"Humid\":59.06},{\"Time\":1759859631000,\"Temp\":19.33,\"Humid\":59.51},{\"Time\":1759859691000,\"Temp\":19.37,\"Humid\":59.89},{\"Time\":1759859751000,\"Temp\":19.47,\"Humid\":59.86},{\"Time\":1759859811000,\"Temp\":19.56,\"Humid\":59.69},{\"Time\":1759859871000,\"Temp\":19.54,\"Humid\":59.11},{\"Time\":1759859931000,\"Temp\":19.37,\"Humid\":59.28},{\"Time\":1759859991000,\"Temp\":19.36,\"Humid\":59.82}]","payloadType":"json","x":240,"y":5000,"wires":[["22ec42a80412beb0","d532784a4045c2da","715b42e799599fc6"]]},{"id":"22ec42a80412beb0","type":"ui-chart","z":"997da33a0beedade","group":"4f87bd59a15b847e","name":"Another test","label":"Another test","order":4,"chartType":"line","category":"","categoryType":"none","xAxisLabel":"","xAxisProperty":"Time","xAxisPropertyType":"property","xAxisType":"time","xAxisFormat":"","xAxisFormatType":"{HH}:{mm}:{ss}","xmin":"","xmax":"","yAxisLabel":"","yAxisProperty":"Temp","yAxisPropertyType":"property","ymin":"","ymax":"","bins":10,"action":"replace","stackSeries":false,"pointShape":"circle","pointRadius":"3","showLegend":true,"removeOlder":"52","removeOlderUnit":"604800","removeOlderPoints":"","colors":["#0095ff","#ff0000","#ff7f0e","#2ca02c","#a347e1","#d62728","#ff9896","#9467bd","#c5b0d5"],"textColor":["#346cda"],"textColorDefault":false,"gridColor":["#2dd920"],"gridColorDefault":false,"width":"4","height":"4","className":"","interpolation":"linear","x":790,"y":5000,"wires":[[]]},{"id":"4f87bd59a15b847e","type":"ui-group","name":"test","page":"c6ff182a4185f2f2","width":"6","height":"1","order":1,"showTitle":true,"className":"","visible":"true","disabled":"false","groupType":"default"},{"id":"c6ff182a4185f2f2","type":"ui-page","name":"Test page","ui":"ID-BASE-1","path":"/testpage","icon":"home","layout":"grid","theme":"f9b6670b127dc219","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":6,"className":"","visible":"true","disabled":"false"},{"id":"ID-BASE-1","type":"ui-base","name":"Dashboard","path":"/dashboard","appIcon":"","includeClientData":false,"acceptsClientConfig":["ui-control","ui-notification","ui-gauge-classic"],"showPathInSidebar":false,"headerContent":"page","titleBarStyle":"default","showReconnectNotification":false,"notificationDisplayTime":"1","showDisconnectNotification":true,"allowInstall":true},{"id":"f9b6670b127dc219","type":"ui-theme","name":"FlowForge Theme","colors":{"surface":"#152a47","primary":"#005aff","bgPage":"#ffffff","groupBg":"#ffffff","groupOutline":"#cc3e3e"},"sizes":{"pagePadding":"12px","groupGap":"12px","groupBorderRadius":"4px","widgetGap":"12px","density":"default"}},{"id":"2060bed60a038d90","type":"global-config","env":[],"modules":{"@flowfuse/node-red-dashboard":"1.29.0"}}]
27

The inject creates the chart immediately, the clear clears the chart immediately (I opened the tabs side by side). The flows are working correctly.

28

Is your flow still not working? The flow I posted is merely the data you posted.

What happens if you connect your real flow to the chart I posted?

29

I connected it to the graphs, and they show when injected. I also put the data into a change node so I could initiate using a dashboard button, that also works.

Ah, I've finally figured it out. I was getting a data input from a text input/date picker in order to choose the date to do the query. It was set to default, send on focus leave, so it never sent a date input until I actually left the page? Which is not the behavior I'd expect, shouldn't it be focus leave of the date picker only? So basically it just wasn't getting the query done until I left the page entirely. Pressing enter doesn't do it, choosing the date doesn't do it, only until I click somewhere else. Anyways, cause found, thanks for your patience.

I'm guessing I should choose "delay" instead, and supposedly it sends the msg after I pick it plus the delay? There isn't any info on the help for this option. Hmm, choosing all the send options seems to do it.

30

For me the default is Focus Leave and Return both selected. I have just checked with a date picker and if I select a date and then click elsewhere on the same page (to remove the focus) it does send it. If you want it to happen as soon as you select a date (without clicking away) then select Delay with a short value. Then you will not have to change the focus by clicking away.