Extract Field gives blank chart for JSON data

  • What Grafana version and what operating system are you using?
    I am using Grafana 9.5.3

  • What are you trying to achieve?
    I am querying “time” and one more column “processes” from a PSQL table. The query works fine. The “processes” field is essentially a JSON output. I need to plot a time series Graph with respect to the JSON output and time. The data in table format looks like below in Grafana:

  • How are you trying to achieve it?
    In Transform tab, I am trying to Extract the values from JSON field from the processes column and keeping the time as well to plot the time series chart

  • What happened?
    As soon as i extract the JSON value the Chart goes blank and does not show anything and looks like it has crashed as below:

  • What did you expect to happen?
    I expected it to plot a time series chart where with respect to time, the key should be seen as a Legend and the value as the point on the chart. The chart works fine in Grafana 10.0.3, BUT It is not working in 9.5.3.

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No UI logs found or any errors seen

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

is your time field UTC?

I have set it to Auto. It picks up to CDT

1 Like