Select time field rather than timestamp for graphing data

Grafana InfluxDB
1

Hello,
I’m importing historical csv data from 30 sensors (30 files) using node-red into influxdb.

Its coming fine, with temperature as the value, and then sensor name and time as tags.

I’m struggling to plot the values as grafana seems to be looking at the timestamp of the data import, and I can’t quite see how to use the imported time from the csv file. Is tag the wrong place?
Should it be temp and time as values, then sensor name as the tag?

Any tips?

Thanks.,

2

your best bet for support here is probably to share your raw, unformatted data. That way we can mock up your data and help troubleshoot this issue.

In the meantime, there are a lot of transformations that might help you here:

3

Fantastic, i’ll look at the transformations.
I’ve also attached some sample csv data here…

As I mentioned the sensor and time are sent in as tags.

Sensor,Time,Temperature,,
W1 (12),2022-01-24T04:44:42Z,22.38,,
W1 (12),2022-01-24T04:49:42Z,22.44,,
W1 (12),2022-01-24T04:54:42Z,22.44,,
W1 (12),2022-01-24T04:59:42Z,22.44,,
W1 (12),2022-01-24T05:04:42Z,22.31,,
W1 (12),2022-01-24T05:09:42Z,22.38,,
W1 (12),2022-01-24T05:14:42Z,22.38,,
W1 (12),2022-01-24T05:19:42Z,22.31,,
W1 (12),2022-01-24T05:24:42Z,22.38,,
W1 (12),2022-01-24T05:29:42Z,22.56,,
W1 (12),2022-01-24T05:34:42Z,22.44,,
W1 (12),2022-01-24T05:39:42Z,22.38,,
W1 (12),2022-01-24T05:44:42Z,22.38,,
W1 (12),2022-01-24T05:49:42Z,22.38,,
W1 (12),2022-01-24T05:54:42Z,22.25,,
W1 (12),2022-01-24T05:59:42Z,22.19,,
W1 (12),2022-01-24T06:04:42Z,22.13,,
W1 (12),2022-01-24T06:09:42Z,22,,
W1 (12),2022-01-24T06:14:42Z,22,,
W1 (12),2022-01-24T06:19:42Z,22,,
W1 (12),2022-01-24T06:24:42Z,22,,
W1 (11),2022-01-24T06:25:58Z,22,,
W1 (12),2022-01-24T06:29:42Z,22,,
W1 (11),2022-01-24T06:30:58Z,21.94,,
W1 (12),2022-01-24T06:34:42Z,21.94,,
W1 (11),2022-01-24T06:35:58Z,21.88,,
W1 (12),2022-01-24T06:39:42Z,21.94,,
W1 (11),2022-01-24T06:40:58Z,21.81,,
W1 (12),2022-01-24T06:44:42Z,21.88,,
W1 (11),2022-01-24T06:45:58Z,21.81,,
W1 (12),2022-01-24T06:49:42Z,21.81,,
W1 (11),2022-01-24T06:50:58Z,21.69,,
W1 (12),2022-01-24T06:54:42Z,21.88,,
W1 (11),2022-01-24T06:55:58Z,21.75,,
W1 (12),2022-01-24T06:59:42Z,21.75,,