Cannot use time series on CSV data collected by telegraf

[supersers]

• What Grafana version and what operating system are you using?
  v10.3.1 (00a22ff8b2), READ HAT

• What are you trying to achieve?
  visualize my data with time series

• How are you trying to achieve it?
  by trying to use the visualization model

• What happened?
  I get this message “Data is missing a number field”

• What did you expect to happen?
  To see the trend line

• Can you copy/paste the configuration(s) that you are having problems with?
  yes, it is a input.file telegraf configuration

[inputs.file]]
files = [“/output_sc_LTE.csv”]
data_format = “csv”
csv_header_row_count = 0
csv_column_names = [“SERVINGCELL”, “STATE”, “TECN”, “is_tdd”, “mcc”, “mnc”, “cellid”, “pcid”, “earfcn”, “freq_band_ind”, “ul_band width”, “dl_bandwidth”, “tac”, “rsrp”, “rsrq”, “rssi”, “cqi”, “tx_power”, “srxlev”]
csv_column_types = [“string”, “string”, “string”, “string”, “integer”, “integer”, “integer”, “integer”, “integer”, “integer”, “integer”, “integer”, “string”, “integer”, “integer”, “integer”, “integer”, “integer”, “integer”]
name_override = “ServingCellLTE”
csv_tag_columns = [“host”]
interval = “10m”
collection_offset = “6m”

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
  No errors, just a message that says that the data is missing a number field. I do not know why since I have integers defined in each column.

• Did you follow any online instructions? If so, what is the URL?
  No

I would like to have a trend line for the RSSI value I collect with telegraf from a CSV file. The configuration is defined to have that column as integers but grafana is not detecting it. Can anyone help please?

[yosiasz]

please share a sampling of your data csv file?
I assume you are pushing this data to influxdb?
are you using influxql or flux query language?

[supersers]

Hi, thank you. This is the output

"servingcell","NOCONN","LTE","FDD",736,03,272B02,262,5790,17,3,3,B8F0,-93,-17,-57,6,-,-

my code generates this CSV that is used for the inputs.file.
My answers: Yes, I am pushing it to influxDB, and I am using influxQL. I unfortunately cannot see the DB but I can see the data in Grafana if it is in table format. So I know that the data is being sent to the DB

[yosiasz]

so one of those columns needs to be converted to number using transformation.

[supersers]

ok, i will try to do that, I did not think about that. Thank you