Cannot use time series on CSV data collected by telegraf

  • 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

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?

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?

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?

Hi, thank you. This is the output


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

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

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