# I need help on my dashboard

**URL:** https://discourse.nodered.org/t/i-need-help-on-my-dashboard/56470
**Category:** Dashboard
**Tags:** node-red-dashboard, database
**Created:** [11 January 2022 14:02 UTC](https://discourse.nodered.org/t/i-need-help-on-my-dashboard/56470 "2022-01-11T14:02:35Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![diogoqwe](https://avatars.discourse-cdn.com/v4/letter/d/54ee81/32.png) [@diogoqwe](https://discourse.nodered.org/u/diogoqwe)
#### Post date: [11 January 2022 14:02 UTC](https://discourse.nodered.org/t/i-need-help-on-my-dashboard/56470/1 "2022-01-11T14:02:35Z")

</div>

I already store all data in phpmyadmin but i want to pick all the data that i saved and when i log node-red it all appears.  
How can I transform the array into a graphic

 ![Screenshot_38](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/f/bf9c41da9d6b11e870cfe7ff11fcb4b4b9ed8a3c.png)  
 ![Screenshot_37](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/0/70256cf0a3d6a3fcc77c313779ce8f0264c69d4a.png)

---

<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: [11 January 2022 14:30 UTC](https://discourse.nodered.org/t/i-need-help-on-my-dashboard/56470/2 "2022-01-11T14:30:18Z")

</div>

> [@diogoqwe](#):
>
> I already store all data in phpmyadmin

First off, you store your data in a database, phpMYAdmin is:

> phpMYAdmin is a free software tool written in PHP, intended to handle the administration of MySQL and MariaDB.

In Node-RED, there are nodes that will communicate with difference databases as I can se you are doing.

you ask

> How can I transform the array into a graphic

What array are you talking about, what kind of graphic...an image, a chart?

---

<div class="post-metadata">

### Author: ![diogoqwe](https://avatars.discourse-cdn.com/v4/letter/d/54ee81/32.png) [@diogoqwe](https://discourse.nodered.org/u/diogoqwe)
#### Post date: [11 January 2022 14:57 UTC](https://discourse.nodered.org/t/i-need-help-on-my-dashboard/56470/3 "2022-01-11T14:57:58Z")

</div>

![Screenshot_47](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/8/58e5c98f130f8bdd57547dbd5e599b3f27f6a04f.png)  
 ![Screenshot_48](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/0/2/027db901da6c4ee4e7ad5cc6164eeb51315f448b.png)  
I want to make a chart, basically i just want the chart to load all data

---

<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: [11 January 2022 15:16 UTC](https://discourse.nodered.org/t/i-need-help-on-my-dashboard/56470/4 "2022-01-11T15:16:48Z")

</div>

So what have you tried? What type of chart? line, bar, pie?  
Have you done a search in the flows library for existing examples you could examine? (try [Library - Node-RED](https://flows.nodered.org/search?term=chart&type=flow))

I recommend watching this playlist: [Node-RED Essentials](https://www.youtube.com/playlist?list=PLyNBB9VCLmo1hyO-4fIZ08gqFcXBkHy-6). The videos are done by the developers of node-red. They're nice & short and to the point. You will understand a whole lot more in about 1 hour. A small investment for a lot of gain.

Also there’s a great page in the docs 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)

[https://nodered.org/docs/user-guide/messages](https://nodered.org/docs/user-guide/messages)

---

<div class="post-metadata">

### Author: ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)
#### Post date: [11 January 2022 16:34 UTC](https://discourse.nodered.org/t/i-need-help-on-my-dashboard/56470/5 "2022-01-11T16:34:06Z")

</div>

Covered many many times on the forum.

Search **mysql chart**

Example: [Dynamic series identification from message, send data to Chart - #5 by Steve-Mcl](https://discourse.nodered.org/t/dynamic-series-identification-from-message-send-data-to-chart/36682/5)

There are many more threads too.  
Give something a try and when you get stuck on a specific bit, head back and ask.

---

<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: [10 February 2022 16:34 UTC](https://discourse.nodered.org/t/i-need-help-on-my-dashboard/56470/6 "2022-02-10T16:34:30Z")

</div>

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