Time series from CSV data

Grafana Dashboards
,
1

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.

image
image2139×228 17.1 KB

image
image2152×489 24.2 KB

Thank you for support!

3

(post deleted by author)

4

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?

5

not sure of the root cause

6

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

image
image2136×895 45.1 KB

image
image2136×934 72.5 KB

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.