Display influxdb-2 data in dashboard-2

Dashboard
1

Hello everyone,

I have created a flow that is receiving fake temperature values (using random function) from an ESP32 using MQTT. I use influxdb v2 to store the values.

My problem is that I cannot display the last hour data in a dashboard chart, when pressing a button.

The flow that I'm using in order to display the data is

flow
flow921×284 12.4 KB

and the query is

from(bucket:"test1")
  |> range(start: -1h)
  |> filter(fn: (r) => r["_measurement"] == "test1" and r["_field"] == "temperature")

As you can see in the following image, the table shows the data but the chart doesn't.

screenshot
screenshot1404×1147 58.8 KB

Thank you in advance.

2

I cannot determine from your screenshot if the time axis is using 24h time or AM/PM, but are you sure that the time values in the table (14:31, etc.) are included in the timespan on the graph? In other words, can you expand the time window out and see any points?

3

Does the format of the data that you are sending to the chart match one of the valid alternatives for the chart node?

4

Thank you both for your time.

I'm using AM/PM in the time axis.

Here is the chart node

chart
chart1247×1046 49.6 KB

5

That looks like dashboard1 chart config, not dashboard2. I think the node colour should be changed to stop confusion,

6

Hello @E1cid

Isn't that a dashboard-2 node?

dashboard-2
dashboard-21312×1061 73.6 KB

7

You're correct, see told you i find it confusing.

What is your data like , best show an example in text format.

You need to set the x and y property keys. Probably msg._time/msg._value

8

I'm sending the debug messages.
Is it enough for you?

debug
debug1438×1157 58.3 KB

9

I did say in text format so we can copy the data, we do not need all the array just say 5 or 6 rows.

There’s a great page in the docs (Working with messages : Node-RED) that will explain how to use the debug panel to find the right path/value 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

So use copy value and the edit the array down to 5 or 6 elements, then

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

``` 
   code goes here 
```

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

See this post for more details - How to share code or flow json

10

Should that be copy value?

11

I'm not sure that I fully understand...
Sorry about that.

I have used a text node in order to take the values of the last minute.
Is it correct?

[ { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:36:43.772Z", "_value": 12, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:36:48.773Z", "_value": 1, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:36:53.774Z", "_value": 15, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:36:58.774Z", "_value": 16, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:37:03.778Z", "_value": 1, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:37:08.775Z", "_value": 15, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:37:13.778Z", "_value": 15, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:37:18.78Z", "_value": 19, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:37:23.78Z", "_value": 1, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:37:28.781Z", "_value": 9, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:37:33.784Z", "_value": 3, "_field": "temperature", "_measurement": "test1" }, { "result": "_result", "table": 0, "_start": "2024-02-25T17:36:42.18868378Z", "_stop": "2024-02-25T17:37:42.18868378Z", "_time": "2024-02-25T17:37:38.784Z", "_value": 7, "_field": "temperature", "_measurement": "test1" } ]
12

Seems the new dashboard2 chart only likes the x property in unix timestamp milliseconds
e.g.

[{"id":"1e590caec784e108","type":"inject","z":"b779de97.b1b46","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"test","payload":"[{\"result\":\"_result\",\"table\":0,\"_start\":\"2024-02-25T17:36:42.18868378Z\",\"_stop\":\"2024-02-25T17:37:42.18868378Z\",\"_time\":\"2024-02-25T17:36:43.772Z\",\"_value\":12,\"_field\":\"temperature\",\"_measurement\":\"test1\"},{\"result\":\"_result\",\"table\":0,\"_start\":\"2024-02-25T17:36:42.18868378Z\",\"_stop\":\"2024-02-25T17:37:42.18868378Z\",\"_time\":\"2024-02-25T17:36:48.773Z\",\"_value\":1,\"_field\":\"temperature\",\"_measurement\":\"test1\"},{\"result\":\"_result\",\"table\":0,\"_start\":\"2024-02-25T17:36:42.18868378Z\",\"_stop\":\"2024-02-25T17:37:42.18868378Z\",\"_time\":\"2024-02-25T17:36:53.774Z\",\"_value\":15,\"_field\":\"temperature\",\"_measurement\":\"test1\"},{\"result\":\"_result\",\"table\":0,\"_start\":\"2024-02-25T17:36:42.18868378Z\",\"_stop\":\"2024-02-25T17:37:42.18868378Z\",\"_time\":\"2024-02-25T17:36:58.774Z\",\"_value\":16,\"_field\":\"temperature\",\"_measurement\":\"test1\"},{\"result\":\"_result\",\"table\":0,\"_start\":\"2024-02-25T17:36:42.18868378Z\",\"_stop\":\"2024-02-25T17:37:42.18868378Z\",\"_time\":\"2024-02-25T17:37:03.778Z\",\"_value\":1,\"_field\":\"temperature\",\"_measurement\":\"test1\"}]","payloadType":"json","x":150,"y":4860,"wires":[["001081e723930cef"]]},{"id":"001081e723930cef","type":"change","z":"b779de97.b1b46","name":"","rules":[{"t":"set","p":"payload","pt":"msg","to":"$$.payload ~> |$|{\"_time\":$toMillis($._time)}|","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":220,"y":4920,"wires":[["58069540b7e65fbf"]]},{"id":"58069540b7e65fbf","type":"ui-chart","z":"b779de97.b1b46","group":"fa6f27a81c4d2539","name":"","label":"chart","order":9007199254740991,"chartType":"line","category":"topic","categoryType":"msg","xAxisProperty":"_time","xAxisPropertyType":"msg","xAxisType":"linear","yAxisProperty":"_value","ymin":"","ymax":"","action":"replace","pointShape":"circle","pointRadius":4,"showLegend":true,"removeOlder":"1","removeOlderUnit":"86400","removeOlderPoints":"","colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"width":6,"height":8,"className":"","x":310,"y":4860,"wires":[["a2714c8c86961aad"]]},{"id":"a2714c8c86961aad","type":"debug","z":"b779de97.b1b46","name":"debug 2482","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":490,"y":4860,"wires":[]},{"id":"fa6f27a81c4d2539","type":"ui-group","name":"Tank Status","page":"b74745b3765efdef","width":"6","height":"1","order":-1,"showTitle":true,"className":"","visible":"true","disabled":"false"},{"id":"b74745b3765efdef","type":"ui-page","name":"Tank Status Page","ui":"f2eea23e252f30f6","path":"/page2","icon":"home","layout":"grid","theme":"a965ccfef139317a","order":-1,"className":"","visible":"true","disabled":"false"},{"id":"f2eea23e252f30f6","type":"ui-base","name":"Dolores DB2","path":"/dashboard","includeClientData":true,"acceptsClientConfig":["ui-notification","ui-control"],"showPathInSidebar":false},{"id":"a965ccfef139317a","type":"ui-theme","name":"HN Theme","colors":{"surface":"#5c5c5c","primary":"#00fdff","bgPage":"#383838","groupBg":"#4f4f4f","groupOutline":"#858585"},"sizes":{"pagePadding":"12px","groupGap":"12px","groupBorderRadius":"4px","widgetGap":"12px"}}]

See my example inject with test data, that is all that is required to test not a 620 element array.

13

After many attempts, I couldn't find out the solution to my problem.
So I used influxdb v1.8 and everything worked fine.
I think that this version is more easy to handle.

Thank you for your time.
Best regards.

14

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