grafana-csv-datasource
grafana-csv-datasource copied to clipboard
Fields parsing not working as expected
Querying a csv file with this plugin works as expected.
However, when I try to use the fields tab for parsing the columns, it does not work.
The data looks like this:
Now I want to parse the "Date (CET)" column to Time and the "SSP (BMRS)" column to Number.
After doing so nothing happens and even if I save the dashboard, the content of the two field cells just disappears.
I also tried putting them in like strings ("Date (CET)" and "SSP (BMRS)") which did not work.
Last thing I tried was skipping the first two columns and deactivating the "Header" toggle to just use the generic column names as explained in the documentation ("Field 1", "Field 2", ...). This also did not lead to the columns being parsed.
At the moment, I am using the grafana transformation (Convert field type) to get the numeric values but this is not the solution I am looking for, because it leads to NaN values in the original csv being replaced with 0.
Please let me know how to resolve that issue. Best
Hey @LudwigJan, Can you please provide us the csv file so we can investigate this?
as we got no response we are closing the issue. we will reopen it if we receive new info.