I am using Grafana server (version 8.1.5) on a raspberry pi and want to create dashboards for data stored locally. Therefore, I included the CSV plugin and can also access the data.
The issue is that the csv files contain a column date (20210901) and a time column (120000). I couldn’t find a transformation to format these two columns to one time stamp column (2021-09-01 12:00:00). Any idea how to do that? It would be highly appreciated!