Plotting only selected fields from a JSON object

Grafana Time Series Panel
1

  • What Grafana version and what operating system are you using?
    Grafana v10.2.2 / Windows 10

  • What are you trying to achieve?
    Display only selected JSON fields in a Time Series Visualization

  • How are you trying to achieve it?
    Subscribing to an MQTT stream that is sending a JSON string.
    The JSON string has the following format:
    { “seq”:1, “value1”:1,“value2”:2}

  • What happened?
    All the fields present in the data object are printed in the Time Series.
    I get a graph line for seq, value1 and value2 when I would like only a few selected values to be plotted

  • What did you expect to happen?
    I would like, for instance, to only plot the value associated with the seq field

  • Can you copy/paste the configuration(s) that you are having problems with?
    I did try different solutions though I do not think they generated configurations I can share

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    None that I can identify

  • Did you follow any online instructions? If so, what is the URL?
    Google a few things including “Transform Data” and selecting “Extract Fields”, then JSON, adding a path to the field (“seq”) and selecting “Replace all fields”

2

Welcome @jsstoezel

You have a few options

  1. create a dashboard variable of seqs and use that for filtering
  2. use Query filter transformation

But is { "seq":1, "value1":1,"value2":2} really what the result looks like? Please post real structure of data minus confidential stuff

image
image936×607 31.3 KB