grafana-csv-datasource icon indicating copy to clipboard operation
grafana-csv-datasource copied to clipboard

Fields parsing not working as expected

Open LudwigJan opened this issue 2 years ago • 1 comments

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: Screenshot 2023-08-30 at 13 11 13

Now I want to parse the "Date (CET)" column to Time and the "SSP (BMRS)" column to Number. Screenshot 2023-08-30 at 13 09 05

After doing so nothing happens and even if I save the dashboard, the content of the two field cells just disappears. Screenshot 2023-08-30 at 13 25 07

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

LudwigJan avatar Aug 30 '23 11:08 LudwigJan

Hey @LudwigJan, Can you please provide us the csv file so we can investigate this?

zoltanbedi avatar Nov 28 '23 10:11 zoltanbedi

as we got no response we are closing the issue. we will reopen it if we receive new info.

gabor avatar May 24 '24 08:05 gabor