Where can I know how to use or how to modify visulization tools

Grafana
1

Hi, I’m using Grafana 8.0 to visualize my data.

I tried to install csv datasource plugin and successfully to read my data in table view.

But I get trouble in visualizing it with the visulization tools of Grafana. It shows “Data does not have a time field”.

Details are shown in the following pictures.

屏幕截图 2021-06-21 182829
屏幕截图 2021-06-21 1828291832×437 72.3 KB

屏幕截图 2021-06-21 182845
屏幕截图 2021-06-21 1828451836×439 42.8 KB

It confused me and I want to know where can I get help like documentation if I want to successfully use it.

Thanks for your reading and help.

2

Hi, can you go into your query view and view the underlying SQL for your table? I see you have a column called “datetime”. You may have to alias this in your SQL to “time”. If your query was something like:

SELECT datetime FROM mytable;

Change it to:

SELECT datetime as "time" FROM mytable;

Also check whether your panel is formatted as a “Time series” or a “Table”. I think that “Table” is the option that you want. I hope this helps?

3

Thanks! Your answer helps a lot!