Time series from CSV data

[majan3k]

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:

Time;CPU
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!

[yosiasz]

Welcome

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

[majan3k]

(post deleted by author)

[majan3k]

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?

[yosiasz]

not sure of the root cause

[majan3k]

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.

[yosiasz]

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

Maybe manually add?

-5m

Or