I want to show a sparkline / bargraph in a ui-table. but unable to get an example.
I tried feeding msg.payload set as [1,2,3,4,5] but it is not working.
I am intending to eventually plot a series of values from mysql table.
providing an example of mysql query output for some one who can help.
again, i am into the confusion of objects and arrays...
[{"id":"1153aebaea540bc9","type":"ui-table","z":"0717a61e1ce5f6fe","group":"4fd95451107e52de","name":"Production-Trend","label":"Production Trend","order":3,"width":"","height":"","maxrows":"","passthru":false,"autocols":false,"showSearch":false,"deselect":true,"selectionType":"none","columns":[{"title":"Trend ","key":"trend","keyType":"key","type":"sparkline-trend","width":"","align":"end"}],"mobileBreakpoint":"","mobileBreakpointType":"none","action":"replace","x":470,"y":1480,"wires":[[]]},{"id":"51079dac77f167d7","type":"inject","z":"0717a61e1ce5f6fe","name":"","props":[{"p":"trend","v":"[{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":1},{\"m\":1},{\"m\":5},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":1},{\"m\":6},{\"m\":5},{\"m\":5},{\"m\":4},{\"m\":5},{\"m\":5},{\"m\":4},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":3},{\"m\":6},{\"m\":5},{\"m\":5},{\"m\":3},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":4},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":5},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":1},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":5},{\"m\":5},{\"m\":5},{\"m\":4},{\"m\":5},{\"m\":5},{\"m\":4},{\"m\":5},{\"m\":5},{\"m\":0},{\"m\":0},{\"m\":2},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":1},{\"m\":0},{\"m\":4},{\"m\":5},{\"m\":6},{\"m\":3},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":2},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":4},{\"m\":4},{\"m\":5},{\"m\":4},{\"m\":5},{\"m\":4},{\"m\":5},{\"m\":4},{\"m\":5},{\"m\":5},{\"m\":6},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":5},{\"m\":6},{\"m\":3},{\"m\":4},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":4},{\"m\":0},{\"m\":0},{\"m\":2},{\"m\":4},{\"m\":3},{\"m\":4},{\"m\":4},{\"m\":2},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":4},{\"m\":5},{\"m\":4},{\"m\":5},{\"m\":4},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":3},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":4},{\"m\":4},{\"m\":4},{\"m\":4},{\"m\":4},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":0},{\"m\":3},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":5},{\"m\":6},{\"m\":6},{\"m\":5},{\"m\":6}]","vt":"json"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","x":270,"y":1480,"wires":[["1153aebaea540bc9"]]},{"id":"4fd95451107e52de","type":"ui-group","name":"Outputs","page":"42b40ffce547bedc","width":"15","height":"1","order":1,"showTitle":false,"className":"","visible":"true","disabled":"false","groupType":"default"},{"id":"42b40ffce547bedc","type":"ui-page","name":"ODT","ui":"0aa5ac292a3ec726","path":"/odt","icon":"home","layout":"flex","theme":"b0fed2b0e19988c3","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":"0aa5ac292a3ec726","type":"ui-base","name":"DEL MONTE HOSUR","path":"/dashboard","appIcon":"","includeClientData":true,"acceptsClientConfig":["ui-notification","ui-control","ui-form","ui-text-input","ui-number-input","ui-file-input","ui-button","ui-button-group","ui-radio-group","ui-slider","ui-switch","ui-text","ui-table","ui-chart","ui-gauge","ui-markdown","ui-template","ui-tabulator"],"showPathInSidebar":true,"headerContent":"dashboard","navigationStyle":"temporary","titleBarStyle":"fixed","showReconnectNotification":true,"notificationDisplayTime":"1","showDisconnectNotification":true,"allowInstall":true},{"id":"b0fed2b0e19988c3","type":"ui-theme","name":"MyTheme","colors":{"surface":"#000000","primary":"#059bd6","bgPage":"#050505","groupBg":"#303030","groupOutline":"#297500"},"sizes":{"density":"default","pagePadding":"2px","groupGap":"10px","groupBorderRadius":"10px","widgetGap":"2px"}}]
and i couldn't see for the first time. All i need now is to convert my mysql query into the required format.