How to Create a Gantt Chart in Node-RED Dashboard 2.0 with SQL Data

In this video, I’ll show you how to create a dynamic Gantt chart in Node-RED Dashboard 2.0 using data from Siemens' Opcenter Advanced Scheduling software. We’ll start by fetching data from an SQL Server database, process it using Node-RED function nodes, and visualize it with Mermaid syntax in a Markdown node. This tutorial also includes features like adding buttons to dynamically show or clear the Gantt chart, ensuring real-time updates and accuracy. By the end of the video, you’ll learn how to integrate database-driven data into Node-RED for clear and organized Gantt chart visualization. 💡 References: • FlowFuse Documentation: https://dashboard-demos.flowfuse.cloud/dashboard/markdown-viewer Learn how to use the Markdown node • Mermaid.js: https://mermaid.js.org/syntax/gantt.html Syntax for creating Gantt charts Link example flow: 1. Github: https://yaseralie.github.io/Gantt-Chart-Node-RED-Dashboard-2.0/ 2. Google Drive: https://drive.google.com/file/d/1fgeLXAmo7GiBtrDA8wVHEw1OKszelEvY/view?usp=sharing Don’t forget to like, subscribe, and leave a comment if you find this helpful! #NodeRED #GanttChart #SQLServer #MermaidJS #Dashboard2_0