Time series from CSV data

Hello, I am starting my journey with grafana so I am no expert, however I really want to learn it.

So this is my issue, I have simple CSV file with basic data as below:

2022-12-08 14:09:08;18,299
2022-12-08 14:15:54;16,367
2022-12-08 14:17:33;14,665
2022-12-08 14:18:01;21,953
2022-12-08 14:20:01;20,771
2022-12-08 14:22:01;24,088
2022-12-08 14:24:01;9,410
2022-12-08 14:26:01;28,648
2022-12-08 14:28:01;14,205
2022-12-08 14:30:01;27,080
2022-12-08 14:32:01;22,212
2022-12-08 14:34:01;10,402
2022-12-08 14:36:01;20,381
2022-12-08 14:38:01;9,956
2022-12-08 14:40:01;22,022
2022-12-08 14:42:01;21,631
2022-12-08 14:44:01;9,087
2022-12-08 14:46:01;26,375
2022-12-08 14:48:01;14,675
2022-12-08 14:50:01;17,145
2022-12-08 14:52:01;17,910
2022-12-08 14:54:01;10,974
2022-12-08 14:56:01;26,178
2022-12-08 14:58:01;16,128

I use CSV plugin to import data into grafana and there is no issue, issue is with time series graph which I want to create based on above data, however I am getting information: Data is missing a time field.

I am confused because my column with data looks ok, however can’t displayed time series graph. Some visualisation suggestions works. I set type filed as Time and Number.

Thank you for support!


Go to Transformation tab and choose convert to convert that column to time

(post deleted by author)

Thank you!! It works, but I am wondering why I need to transform my column into time type when I have correct values, at least I guess so. Any explenation of this root cause?

not sure of the root cause

I have another issue with my graph… not sure what is wrong… I am getting information “Data outside time range”

when I click zoom to data then data is showing, but not refreshing as I want to show always last 5 minutes
Thank you for support.

On the time filter on top you can make it to show last 5minutes

Maybe manually add?