# Dashboard 2 multiple line from sql database

**URL:** <https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774>\
**Category:** Dashboard\
**Tags:** dashboard-2\
**Created:** [25 November 2025 11:48 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774 "2025-11-25T11:48:06Z")\
**Posts on this page:** 14\
**Page:** 2

<div class="post-metadata">

**Author:** ![warnert](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/warnert/32/108132_2.png) [@warnert](https://discourse.nodered.org/u/warnert)\
**Post date:** [3 December 2025 12:45 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/21 "2025-12-03T12:45:58Z")

</div>

I have found a solution: the selection for Properties: Series should be "NONE".  
Then I have a nice single color line.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [3 December 2025 13:20 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/22 "2025-12-03T13:20:13Z")

</div>

Can you show us how the chart is configured now please, and tell us what you had in the Series field previously? I want to check whether there is a bug there.

---

<div class="post-metadata">

**Author:** ![warnert](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/warnert/32/108132_2.png) [@warnert](https://discourse.nodered.org/u/warnert)\
**Post date:** [7 December 2025 12:45 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/23 "2025-12-07T12:45:47Z")

</div>

I'm still struggeling with the chart node. If I take an inject node and feed a number value into a chart node I get a nice line in one color, but the dotcolor is changing along the colors that are in the bottom of the config field.

 ![chart_example](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/c/dc238af69ca52e5071b4744cdf35c6ffe3e4eb2b.jpeg)  
Chart:  
 ![Group1](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/6/56d86e5bc3cc28fdea818a9a06f03ac78a8496cc.jpeg)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [7 December 2025 13:25 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/24 "2025-12-07T13:25:18Z")

</div>

Can you select the inject and chart nodes and export and paste them here please, so that we can try to replicate the problem?

---

<div class="post-metadata">

**Author:** ![warnert](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/warnert/32/108132_2.png) [@warnert](https://discourse.nodered.org/u/warnert)\
**Post date:** [7 December 2025 13:34 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/25 "2025-12-07T13:34:15Z")

</div>

This way?

```auto
[
    {
        "id": "7b2befb6ea2b9d9d",
        "type": "ui-chart",
        "z": "e4af61b6bed14a3b",
        "group": "971780555e73f287",
        "name": "",
        "label": "chart",
        "order": 1,
        "chartType": "line",
        "category": "",
        "categoryType": "none",
        "xAxisLabel": "",
        "xAxisProperty": "",
        "xAxisPropertyType": "timestamp",
        "xAxisType": "time",
        "xAxisFormat": "",
        "xAxisFormatType": "{HH}:{mm}",
        "xmin": "",
        "xmax": "",
        "yAxisLabel": "",
        "yAxisProperty": "payload",
        "yAxisPropertyType": "msg",
        "ymin": "0",
        "ymax": "4",
        "bins": 10,
        "action": "append",
        "stackSeries": false,
        "pointShape": "circle",
        "pointRadius": "10",
        "showLegend": true,
        "removeOlder": 1,
        "removeOlderUnit": "3600",
        "removeOlderPoints": "20",
        "colors": [
            "#0095ff",
            "#ff0000",
            "#ff7f0e",
            "#2ca02c",
            "#a347e1",
            "#d62728",
            "#ff9896",
            "#9467bd",
            "#c5b0d5"
        ],
        "textColor": [
            "#666666"
        ],
        "textColorDefault": true,
        "gridColor": [
            "#e5e5e5"
        ],
        "gridColorDefault": true,
        "width": "3",
        "height": "5",
        "className": "",
        "interpolation": "linear",
        "x": 870,
        "y": 340,
        "wires": [
            []
        ]
    },
    {
        "id": "7b3d9ebe6e681e1d",
        "type": "inject",
        "z": "e4af61b6bed14a3b",
        "name": "",
        "props": [
            {
                "p": "payload"
            }
        ],
        "repeat": "2",
        "crontab": "",
        "once": true,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "2",
        "payloadType": "num",
        "x": 730,
        "y": 340,
        "wires": [
            [
                "7b2befb6ea2b9d9d"
            ]
        ]
    },
    {
        "id": "971780555e73f287",
        "type": "ui-group",
        "name": "Group 1",
        "page": "3f2c174003ae29c4",
        "width": "3",
        "height": 1,
        "order": 1,
        "showTitle": true,
        "className": "",
        "visible": "true",
        "disabled": "false",
        "groupType": "default"
    },
    {
        "id": "3f2c174003ae29c4",
        "type": "ui-page",
        "name": "Page 1",
        "ui": "36321428c4348ec0",
        "path": "/page1",
        "icon": "home",
        "layout": "grid",
        "theme": "7061b9268c29c944",
        "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": "36321428c4348ec0",
        "type": "ui-base",
        "name": "My Dashboard",
        "path": "/dashboard",
        "appIcon": "",
        "includeClientData": true,
        "acceptsClientConfig": [
            "ui-notification",
            "ui-control"
        ],
        "showPathInSidebar": false,
        "headerContent": "page",
        "navigationStyle": "default",
        "titleBarStyle": "default",
        "showReconnectNotification": true,
        "notificationDisplayTime": 1,
        "showDisconnectNotification": true,
        "allowInstall": false
    },
    {
        "id": "7061b9268c29c944",
        "type": "ui-theme",
        "name": "Default Theme",
        "colors": {
            "surface": "#ffffff",
            "primary": "#0094CE",
            "bgPage": "#eeeeee",
            "groupBg": "#ffffff",
            "groupOutline": "#cccccc"
        },
        "sizes": {
            "density": "default",
            "pagePadding": "12px",
            "groupGap": "12px",
            "groupBorderRadius": "4px",
            "widgetGap": "12px"
        }
    },
    {
        "id": "feefc0c38dafec53",
        "type": "global-config",
        "env": [],
        "modules": {
            "@flowfuse/node-red-dashboard": "1.29.0"
        }
    }
]

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [7 December 2025 14:13 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/26 "2025-12-07T14:13:31Z")

</div>

> [@warnert](#):
>
> This way?

Close, but the backticks should have been on separate lines in the post.

When using the chart like that should provide the series name in, for example, msg.topic. Specify msg.topic for Series and add a msg.topic with a series name into the Inject node and it should be ok.

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [7 December 2025 14:14 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/27 "2025-12-07T14:14:00Z")

</div>

> [@warnert](#):
>
> I have found a solution: the selection for Properties: Series should be "NONE".

Reconsider this "solution", it's not helping you.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [7 December 2025 14:18 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/28 "2025-12-07T14:18:35Z")

</div>

> [@Colin](#):
>
> should provide the series name in, for example, msg.topic.

Actually I realise there is no need to do that. If you only have one line to draw then set Series to a string containing the series name, and you don't need to provide msg.topic.

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [7 December 2025 16:27 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/29 "2025-12-07T16:27:48Z")

</div>

That's right, but i think that unless msg.topic exists, contains at least an empty string, the legend will not show up.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [7 December 2025 16:49 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/30 "2025-12-07T16:49:17Z")

</div>

If so then that is a bug I think.

---

<div class="post-metadata">

**Author:** ![warnert](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/warnert/32/108132_2.png) [@warnert](https://discourse.nodered.org/u/warnert)\
**Post date:** [7 December 2025 18:48 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/31 "2025-12-07T18:48:29Z")

</div>

I have changed the entry after Series in string and entered NUMBER in there and now the dots are the same color as the line. And NUMBER is displayed.  
And, BTW, in the inject node I removed the msg.topic entry and it still works...  
I've try an inject node with a msg.topic. Result is the same.

But as soon as I select for series NONE the dotcolor changes

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [8 December 2025 08:41 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/32 "2025-12-08T08:41:54Z")

</div>

> [@warnert](#):
>
> But as soon as I select for series NONE the dotcolor changes

Don't do that. You have a series so give it a name.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [17 December 2025 14:27 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/33 "2025-12-17T14:27:43Z")

</div>

> [@warnert](#):
>
> ![GraphProps](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/f/cf891a007919698aca92e4c27a27a44101a30285.jpeg)

For the record, there is a bug in the chart code causing this not to work. The error occurs when using the array definition for Series, but with only a single series, so `["mw","anotherSeries"]` works but `["mw"]` does not. See [Chart node will not show historical data with single series using ["series"] syntax in Series field · Issue #1975 · FlowFuse/node-red-dashboard · GitHub](https://github.com/FlowFuse/node-red-dashboard/issues/1975)

I am working on a fix now.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [16 January 2026 14:28 UTC](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774/34 "2026-01-16T14:28:40Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

[Previous page](https://discourse.nodered.org/t/dashboard-2-multiple-line-from-sql-database/99774.md?page=1)