Elasticsearch visualize nested data

Grafana Elasticsearch
1

  • What Grafana version and what operating system are you using?
    Grafana v10.4.2

  • What are you trying to achieve?
    I have a nested field in elasticsearch called Components. When I visualize it in a table in grafana the column components looks like this:

components:

[ ... 
    { 
        "bitrate": 0, 
        "children": [ 
            { "bitrate": 361427,  "codec": "H.264", "content_type": "Video", "framerate": "50.00","resolution": "640x360p" }, 
            { "content_type": "Audio", "index": 1, "level": -15.7, "level_3sec": -16.9, 
                "loudness": { 
                    "daily": { "integrated": -16.8, "lra": 8.9 }, 
                    "per_channel": [ 
                        { "ch": 1, "level": -15.7, "level_3sec": -16.9, "peak": -6.7 }, 
                        { "ch": 2, "level": -15.7, "level_3sec": -16.9, "peak": -6.7 } 
                        ]
        ]
    },
    {},
]

I want to be able to create a table that has… for specific values in the nest. Or even a visual so i can access the data inside the nested fields
For example

components.children where content_type = “Video”

|Bitrate | codec | content_type | framerate|
|361427 | H.264 | Video | 50.0|

How do I access the nested data

2

Ended up doing multiple extracted fields within transform.

1 Like