# Barchart from InfluxDB request

**URL:** <https://discourse.nodered.org/t/barchart-from-influxdb-request/84635>\
**Category:** Dashboard\
**Tags:** database, influxdb\
**Created:** [17 January 2024 09:21 UTC](https://discourse.nodered.org/t/barchart-from-influxdb-request/84635 "2024-01-17T09:21:32Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![polareisbaer](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/polareisbaer/32/84274_2.png) [@polareisbaer](https://discourse.nodered.org/u/polareisbaer)\
**Post date:** [17 January 2024 09:21 UTC](https://discourse.nodered.org/t/barchart-from-influxdb-request/84635/1 "2024-01-17T09:21:32Z")

</div>

Hello,

I am trying to create a bar chart from a query from my InfluxDB using the max values of several days. Unfortunately, I am not able to do this.

After converting using function node, it looks like this:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/d/6d50bcda6de5c3feae3c3d12085ac1d71e7d6dd3.png)

This is the flow:

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/e/4e5dc3718c87aa532361f13d95b02eed2296ffe6.png)

```auto
[
    {
        "id": "b84ff6a83df2a030",
        "type": "inject",
        "z": "aff59ea3f84b5123",
        "name": "Select * from opendtu",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "query",
                "v": "SELECT max(\"value\") from mqtt_consumer WHERE (topic='open/dtu/114184019984/0/yieldday') and (time >= now() - 9d) Group by time(1d)",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 760,
        "y": 2540,
        "wires": [
            [
                "326357f7bb7c5fcb"
            ]
        ]
    },
    {
        "id": "326357f7bb7c5fcb",
        "type": "influxdb in",
        "z": "aff59ea3f84b5123",
        "influxdb": "69cee814.fcbdb8",
        "name": "OpenDTU",
        "query": "",
        "rawOutput": false,
        "precision": "",
        "retentionPolicy": "",
        "org": "organisation",
        "x": 1080,
        "y": 2540,
        "wires": [
            [
                "aa14700c096b3e10",
                "61752de52dbefa60"
            ]
        ]
    },
    {
        "id": "0cddcc96761b211a",
        "type": "ui_chart",
        "z": "aff59ea3f84b5123",
        "name": "",
        "group": "dd5579511605b911",
        "order": 2,
        "width": 0,
        "height": 0,
        "label": "chart",
        "chartType": "bar",
        "legend": "false",
        "xformat": "HH:mm:ss",
        "interpolate": "linear",
        "nodata": "",
        "dot": false,
        "ymin": "",
        "ymax": "",
        "removeOlder": 1,
        "removeOlderPoints": "",
        "removeOlderUnit": "3600",
        "cutout": 0,
        "useOneColor": false,
        "useUTC": false,
        "colors": [
            "#1f77b4",
            "#aec7e8",
            "#ff7f0e",
            "#2ca02c",
            "#98df8a",
            "#d62728",
            "#ff9896",
            "#9467bd",
            "#c5b0d5"
        ],
        "outputs": 1,
        "useDifferentColor": false,
        "className": "",
        "x": 1470,
        "y": 2540,
        "wires": [
            []
        ]
    },
    {
        "id": "61752de52dbefa60",
        "type": "debug",
        "z": "aff59ea3f84b5123",
        "name": "debug 1",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "false",
        "statusVal": "",
        "statusType": "auto",
        "x": 1220,
        "y": 2620,
        "wires": []
    },
    {
        "id": "aa14700c096b3e10",
        "type": "function",
        "z": "aff59ea3f84b5123",
        "name": "function 9",
        "func": "// Assuming msg.payload contains your data array\nvar data = msg.payload.map(function(item) {\n return { x: new Date(item.time), y: item.max };\n});\n\nmsg.payload = {\n series: ['Max'],\n data: [data]\n};\n\nreturn msg;",
        "outputs": 1,
        "timeout": 0,
        "noerr": 0,
        "initialize": "",
        "finalize": "",
        "libs": [],
        "x": 1300,
        "y": 2540,
        "wires": [
            [
                "0cddcc96761b211a",
                "9114a63405a9dd1c"
            ]
        ]
    },
    {
        "id": "9114a63405a9dd1c",
        "type": "debug",
        "z": "aff59ea3f84b5123",
        "name": "debug 2",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "false",
        "statusVal": "",
        "statusType": "auto",
        "x": 1480,
        "y": 2620,
        "wires": []
    },
    {
        "id": "69cee814.fcbdb8",
        "type": "influxdb",
        "hostname": "192.168.178.10",
        "port": "8086",
        "protocol": "http",
        "database": "opendtu",
        "name": "",
        "usetls": false,
        "tls": "",
        "influxdbVersion": "1.x",
        "url": "http://localhost:8086",
        "rejectUnauthorized": false
    },
    {
        "id": "dd5579511605b911",
        "type": "ui_group",
        "name": "Group 1",
        "tab": "f1504e48476c784c",
        "order": 1,
        "disp": true,
        "width": 6
    },
    {
        "id": "f1504e48476c784c",
        "type": "ui_tab",
        "name": "Test",
        "icon": "dashboard",
        "order": 9,
        "disabled": false,
        "hidden": false
    }
]

```

What is my mistake?

Ralf

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [17 January 2024 10:03 UTC](https://discourse.nodered.org/t/barchart-from-influxdb-request/84635/2 "2024-01-17T10:03:56Z")

</div>

The `x` item must be a number so it should look like this:

```auto
{"x":1703953800000,"y":9}

```

Not knowing what the input data to your function node looks like makes it difficult to determine what your issue is. If the info I provided doesn't help, add a `debug` to the output of the `influxdb-in` node and **copy and paste** the output to a response.

There’s a great page in the docs ([Working with messages : Node-RED](https://nodered.org/docs/user-guide/messages)) that will explain how to use the debug panel to find the right path to any data item.

Pay particular attention to the part about the buttons that appear under your mouse pointer when you over hover a debug message property in the sidebar.

![BX00Cy7yHi](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/d/bd1f333a9e043b061b39917c328b0094d3e52d30.gif)

In order to make code readable and usable it is necessary to surround your code with three backticks (also known as a left quote or backquote `````)

````auto
``` 
   code goes here 
```

````

You can edit and correct your post by clicking the pencil ✏ icon.

See this post for more details - [How to share code or flow json](https://discourse.nodered.org/t/how-to-share-code-or-flow-json/506)

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [17 January 2024 11:41 UTC](https://discourse.nodered.org/t/barchart-from-influxdb-request/84635/3 "2024-01-17T11:41:12Z")

</div>

A bar chart does not use X Y time series data. It should be of this format

```auto
[{
    "series": ["X"],
    "data": [[5,6,9] ],
    "labels": ["Jan", "Feb", "Mar"]
}]

```

Your dates should be in the label and values in the data. Format the dates as you want them displayed.

More info on formats here [node-red-dashboard/Charts.md at master · node-red/node-red-dashboard · GitHub](https://github.com/node-red/node-red-dashboard/blob/master/Charts.md) as noted in the sidebar help text.

---

<div class="post-metadata">

**Author:** ![polareisbaer](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/polareisbaer/32/84274_2.png) [@polareisbaer](https://discourse.nodered.org/u/polareisbaer)\
**Post date:** [17 January 2024 12:11 UTC](https://discourse.nodered.org/t/barchart-from-influxdb-request/84635/4 "2024-01-17T12:11:31Z")

</div>

Can you please give me a practical example of how I can transform this value?

```auto
[{"time":"2024-01-08T00:00:00.000Z","max":593},{"time":"2024-01-09T00:00:00.000Z","max":730},{"time":"2024-01-10T00:00:00.000Z","max":719},{"time":"2024-01-11T00:00:00.000Z","max":703},{"time":"2024-01-12T00:00:00.000Z","max":115},{"time":"2024-01-13T00:00:00.000Z","max":168},{"time":"2024-01-14T00:00:00.000Z","max":280},{"time":"2024-01-15T00:00:00.000Z","max":321},{"time":"2024-01-16T00:00:00.000Z","max":655},{"time":"2024-01-17T00:00:00.000Z","max":363}]

```

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [17 January 2024 12:28 UTC](https://discourse.nodered.org/t/barchart-from-influxdb-request/84635/5 "2024-01-17T12:28:02Z")

</div>

Try

```auto
[{"id":"b84ff6a83df2a030","type":"inject","z":"d1395164b4eec73e","name":"Select * from opendtu","props":[{"p":"payload"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"time\":\"2024-01-08T00:00:00.000Z\",\"max\":593},{\"time\":\"2024-01-09T00:00:00.000Z\",\"max\":730},{\"time\":\"2024-01-10T00:00:00.000Z\",\"max\":719},{\"time\":\"2024-01-11T00:00:00.000Z\",\"max\":703},{\"time\":\"2024-01-12T00:00:00.000Z\",\"max\":115},{\"time\":\"2024-01-13T00:00:00.000Z\",\"max\":168},{\"time\":\"2024-01-14T00:00:00.000Z\",\"max\":280},{\"time\":\"2024-01-15T00:00:00.000Z\",\"max\":321},{\"time\":\"2024-01-16T00:00:00.000Z\",\"max\":655},{\"time\":\"2024-01-17T00:00:00.000Z\",\"max\":363}]","payloadType":"json","x":380,"y":3500,"wires":[["61752de52dbefa60","aa14700c096b3e10"]]},{"id":"61752de52dbefa60","type":"debug","z":"d1395164b4eec73e","name":"debug 1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":560,"y":3580,"wires":[]},{"id":"aa14700c096b3e10","type":"function","z":"d1395164b4eec73e","name":"function 9","func":"// Assuming msg.payload contains your data array\nlet data = []\nlet labels = []\nmsg.payload.forEach(function(item) {\n labels.push(item.time);\n data.push(item.max );\n});\n\nmsg.payload = [{\n series: ['Max'],\n data: [data],\n labels : labels\n}];\n\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":580,"y":3500,"wires":[["0cddcc96761b211a","9114a63405a9dd1c"]]},{"id":"0cddcc96761b211a","type":"ui_chart","z":"d1395164b4eec73e","name":"","group":"dd5579511605b911","order":2,"width":0,"height":0,"label":"chart","chartType":"bar","legend":"false","xformat":"HH:mm:ss","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"className":"","x":810,"y":3500,"wires":[[]]},{"id":"9114a63405a9dd1c","type":"debug","z":"d1395164b4eec73e","name":"debug 2","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":820,"y":3580,"wires":[]},{"id":"dd5579511605b911","type":"ui_group","name":"Group 1","tab":"f1504e48476c784c","order":1,"disp":true,"width":6},{"id":"f1504e48476c784c","type":"ui_tab","name":"Test","icon":"dashboard","order":9,"disabled":false,"hidden":false}]

```

---

<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:** [31 January 2024 14:34 UTC](https://discourse.nodered.org/t/barchart-from-influxdb-request/84635/7 "2024-01-31T14:34:31Z")

</div>

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