Load a csv in Node Red with unlabelled rows and column to display it as a x-y axis heatmap in Grafana

Grafana InfluxDB
1

Hello all,

I load into Node Red a csv file with 100 unlabelled columns and 100 unlabelled rows.
What output should I chose in the read file and csv nodes to send to InfluxDB my data as a table that I can use in Grafana heatmap module to plot?

For now, I manage to see my data in Grafana as aggregated by time, with a time-based x-axis.

My goal is to have my columns as x-axis and rows as y-axis, with the value of each individual cell.

2

Hi @sigmaman

Instead of sending the CSV to InfluxDB, have you considered using the Infinity plugin and just viewing the CSV (with the heatmap visualization) using that datasource?

2 Likes
3

I will look into this, thank you.
Ideally, I want to keep the InfluxDB structure, since I use it for all my other data sources.