Skip to content

Data visualization in Grafana

You must create a Grafana dashboard that allows you to view the temporary record of the data stored in the database.

Remember that the guide document for the first part of the project explains step by step how to add an InfluxDB database to Grafana and how to generate a graphic panel within a dashboard.

It is recommended that at this point you run the Node-RED flow reading data automatically, configuring the Inject block as seen in the following screenshot:

Objectives

  1. Create a dashboard where they can be consulted: a. The preprocessed data written to the database from the Node-RED flow. b. The results written to the database from script 3 in Matlab Online.

In the capture that you have as an example, two Grafana panels are shown:

  • The first with the measured data of the Kurtosis parameter, which has a new value every 5 seconds. Remember that this corresponds to the fact that the Node-RED flow only writes to the database every time it reads new data from the PLC.
  • The second with the processed data of the Kurtosis parameter. In this case, the processed data is only calculated and written to the database each time you run the MATLAB script.

Visualization of data and results stored in Matlab

For the last part of the project, you will have to generate a Grafana dashboard that allows you to visualize the data that you have written from the MATLAB Online script.

For this part of the project, no specific dashboard structure is set. It is suggested that you explore the possibilities of Grafana to generate a graphic panel that contains:

  • Panels that show the evolution of a component of the data (either known or unknown) over time.

  • Panels that show the membership value as a percentage of the operating conditions (“Healthy” and “Bearing failure”) of the diagnosed data.

  • Dashboards showing membership value progress over time.
  • Scatter-type panels that allow visualizing the distribution of the data, both of the diagnosed data and of the unknown data. Keep in mind that you should see something similar to the figures that are generated in the MATLAB script, you may have to adjust the values of the axes so that the same area is graphed.

Take into account if the use of different colors helps to clearly differentiate both the graphs from each other and the ranges of values that the data take.