Happy New Year!
What is the best way to display shift wise (3 shift in a day) data for a period of a selected month.
I am currently doing it in an HTML table (DB1) like so.. except that i cannot get each cell clickable, not having complaints, just want to know if there is a better way.
sample data in the example flow, if someone can help me improve.
[{"id":"ef443ba1d36fd04d","type":"inject","z":"9aa7804a0819ffec","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":460,"y":1450,"wires":[["b8cdd842a862c112"]]},{"id":"b8cdd842a862c112","type":"change","z":"9aa7804a0819ffec","name":"One Month Data","rules":[{"t":"set","p":"payload","pt":"msg","to":"[{\"date\":\"01-Dec-A\",\"count\":\"1\"},{\"date\":\"01-Dec-B\",\"count\":\"0\"},{\"date\":\"01-Dec-C\",\"count\":\"0\"},{\"date\":\"02-Dec-A\",\"count\":\"6,447\"},{\"date\":\"02-Dec-B\",\"count\":\"74,765\"},{\"date\":\"02-Dec-C\",\"count\":\"82,345\"},{\"date\":\"03-Dec-A\",\"count\":\"53,002\"},{\"date\":\"03-Dec-B\",\"count\":\"65,086\"},{\"date\":\"03-Dec-C\",\"count\":\"81,645\"},{\"date\":\"04-Dec-A\",\"count\":\"71,230\"},{\"date\":\"04-Dec-B\",\"count\":\"68,469\"},{\"date\":\"04-Dec-C\",\"count\":\"94,856\"},{\"date\":\"05-Dec-A\",\"count\":\"93,354\"},{\"date\":\"05-Dec-B\",\"count\":\"57,344\"},{\"date\":\"05-Dec-C\",\"count\":\"102,267\"},{\"date\":\"06-Dec-A\",\"count\":\"99,709\"},{\"date\":\"06-Dec-B\",\"count\":\"67,292\"},{\"date\":\"06-Dec-C\",\"count\":\"73,597\"},{\"date\":\"07-Dec-A\",\"count\":\"86,725\"},{\"date\":\"07-Dec-B\",\"count\":\"75,176\"},{\"date\":\"07-Dec-C\",\"count\":\"35,539\"},{\"date\":\"08-Dec-A\",\"count\":\"88,646\"},{\"date\":\"08-Dec-B\",\"count\":\"86,381\"},{\"date\":\"08-Dec-C\",\"count\":\"61,303\"},{\"date\":\"09-Dec-A\",\"count\":\"74,493\"},{\"date\":\"09-Dec-B\",\"count\":\"90,706\"},{\"date\":\"09-Dec-C\",\"count\":\"106,889\"},{\"date\":\"10-Dec-A\",\"count\":\"49,760\"},{\"date\":\"10-Dec-B\",\"count\":\"88,958\"},{\"date\":\"10-Dec-C\",\"count\":\"90,859\"},{\"date\":\"11-Dec-A\",\"count\":\"82,223\"},{\"date\":\"11-Dec-B\",\"count\":\"49,780\"},{\"date\":\"11-Dec-C\",\"count\":\"103,567\"},{\"date\":\"12-Dec-A\",\"count\":\"101,823\"},{\"date\":\"12-Dec-B\",\"count\":\"49,041\"},{\"date\":\"12-Dec-C\",\"count\":\"96,010\"},{\"date\":\"13-Dec-A\",\"count\":\"109,556\"},{\"date\":\"13-Dec-B\",\"count\":\"72,422\"},{\"date\":\"13-Dec-C\",\"count\":\"2\"},{\"date\":\"14-Dec-A\",\"count\":\"0\"},{\"date\":\"14-Dec-B\",\"count\":\"0\"},{\"date\":\"14-Dec-C\",\"count\":\"0\"},{\"date\":\"15-Dec-A\",\"count\":\"0\"},{\"date\":\"15-Dec-B\",\"count\":\"0\"},{\"date\":\"15-Dec-C\",\"count\":\"15\"},{\"date\":\"16-Dec-A\",\"count\":\"87,050\"},{\"date\":\"16-Dec-B\",\"count\":\"133,450\"},{\"date\":\"16-Dec-C\",\"count\":\"126,620\"},{\"date\":\"17-Dec-A\",\"count\":\"102,029\"},{\"date\":\"17-Dec-B\",\"count\":\"131,739\"},{\"date\":\"17-Dec-C\",\"count\":\"116,458\"},{\"date\":\"18-Dec-A\",\"count\":\"0\"},{\"date\":\"18-Dec-B\",\"count\":\"32,989\"},{\"date\":\"18-Dec-C\",\"count\":\"110,236\"},{\"date\":\"19-Dec-A\",\"count\":\"121,131\"},{\"date\":\"19-Dec-B\",\"count\":\"125,771\"},{\"date\":\"19-Dec-C\",\"count\":\"136,985\"},{\"date\":\"20-Dec-A\",\"count\":\"119,605\"},{\"date\":\"20-Dec-B\",\"count\":\"127,201\"},{\"date\":\"20-Dec-C\",\"count\":\"115,826\"},{\"date\":\"21-Dec-A\",\"count\":\"94,764\"},{\"date\":\"21-Dec-B\",\"count\":\"124,894\"},{\"date\":\"21-Dec-C\",\"count\":\"0\"},{\"date\":\"22-Dec-A\",\"count\":\"100,314\"},{\"date\":\"22-Dec-B\",\"count\":\"118,942\"},{\"date\":\"22-Dec-C\",\"count\":\"110,449\"},{\"date\":\"23-Dec-A\",\"count\":\"80,144\"},{\"date\":\"23-Dec-B\",\"count\":\"69,846\"},{\"date\":\"23-Dec-C\",\"count\":\"0\"},{\"date\":\"24-Dec-A\",\"count\":\"3\"},{\"date\":\"24-Dec-B\",\"count\":\"0\"},{\"date\":\"24-Dec-C\",\"count\":\"0\"},{\"date\":\"25-Dec-A\",\"count\":\"0\"},{\"date\":\"25-Dec-B\",\"count\":\"0\"},{\"date\":\"25-Dec-C\",\"count\":\"0\"},{\"date\":\"26-Dec-A\",\"count\":\"1\"},{\"date\":\"26-Dec-B\",\"count\":\"48,976\"},{\"date\":\"26-Dec-C\",\"count\":\"115,977\"},{\"date\":\"27-Dec-A\",\"count\":\"94,827\"},{\"date\":\"27-Dec-B\",\"count\":\"60,282\"},{\"date\":\"27-Dec-C\",\"count\":\"58,919\"},{\"date\":\"28-Dec-A\",\"count\":\"101,428\"},{\"date\":\"28-Dec-B\",\"count\":\"95,428\"},{\"date\":\"28-Dec-C\",\"count\":\"93,876\"},{\"date\":\"29-Dec-A\",\"count\":\"60,387\"},{\"date\":\"29-Dec-B\",\"count\":\"93,425\"},{\"date\":\"29-Dec-C\",\"count\":\"69,189\"},{\"date\":\"30-Dec-A\",\"count\":\"67,004\"},{\"date\":\"30-Dec-B\",\"count\":\"93,140\"},{\"date\":\"30-Dec-C\",\"count\":\"50,925\"},{\"date\":\"31-Dec-A\",\"count\":\"0\"},{\"date\":\"31-Dec-B\",\"count\":\"0\"},{\"date\":\"31-Dec-C\",\"count\":\"0\"}]","tot":"json"}],"action":"","property":"","from":"","to":"","reg":false,"x":655,"y":1450,"wires":[["7f7bab2b3423e87d"]]},{"id":"7f7bab2b3423e87d","type":"debug","z":"9aa7804a0819ffec","name":"Debug 1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":835,"y":1450,"wires":[]}]
