Is possible apply transform "rows to columns" in a "time series" visualization?

[durantci]

I’m using Grafana 9.4.3 running on a Debian 11

I’m newie on Grafana. I think that I’m doing a very basic question, but I was looking on google about it and I don’t find any example of grafana “Rows to fields” transformation with “time series” visualization. I don’t see examples neither on Grafana community site, perhaps it means that I’m wrong on the way that I’m doing this?

I’m trying to visualize a CSV datasource (marcusolsson-csv-datasource plugin) on a “time series” visualization. But when I apply the transform “Rows to fields” to the data, the panel said “Data is missing a time field”. I’m trying to have drawn the URLs with their values in a time series chart in order to see what values have the URLs over the time.

My first idea is representing URLs in the chart as Fields are represented on “time series”… but no luck

This is an example of data source:
1679230800000,,902
1679230800000,,791
1679230800000,,309
1679230800000,,787
1679231900000,,729
1679231900000,,439
1679231900000,,951
1679231900000,,684

Here you can see the Query:

And here you can see the Transform:

Please, could someone with experience in “time series” and transformations help me on this?
Any advice or suggestion is always welcome

Thanks in advance.
Warm regards.

[usman.ahmad]

Hi @durantci,

Welcome to the community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community

Did you already check the documentation regarding Transformations as it explains in good detail how to use different transformations.

Let us know if this helps.