Is there any possibilite to access the nested arrays in json input data to show it in kibana charts

Elastic Stack Kibana
1 
{
  "freqIteration": [
    {
      "frequency": "2.4GHz",
      "channel": "1",
      "antenna": "2x2",
      "bandwidth": "40MHz",
      "rawData": [
        {
          "angle": "0",
          "testLocation": "10",
          "speed": 1,
          "stream": "upstream"
        },
        {
          "angle": "0",
          "testLocation": "KITCHEN",
          "speed": 15,
          "stream": "downstream"
        },
        {
          "angle": "45",
          "testLocation": "KITCHEN",
          "speed": 10,
          "stream": "upstream"
        },
        {
          "angle": "45",
          "testLocation": "KITCHEN",
          "speed": 16,
          "stream": "downstream"
        },
      
      ]
    },
    {
      "frequency": "5GHz",
      "channel": "36",
      "antenna": "4x4",
      "bandwidth": "80MHz",
      "rawData": [
        {
          "angle": "0",
          "testLocation": "KITCHEN",
          "speed": 50,
          "stream": "upstream"
        },
        {
          "angle": "0",
          "testLocation": "KITCHEN",
          "speed": 55,
          "stream": "downstream"
        },
        {
          "angle": "45",
          "testLocation": "KITCHEN",
          "speed": 50,
          "stream": "upstream"
        },
        {
          "angle": "45",
          "testLocation": "KITCHEN",
          "speed": 56,
          "stream": "downstream"
        },
        
        ]
}

is there possible way to access the data for example i want to display the kibana charts in such a way that.. on x axis to represent angle like 0,45,90 available..which were collected from the json input 'angle' and on y axis i need to match corresponding speed for that particular angle which were shown in json data like if on x axis for '0' i need to display speed as '15' on y axis ..so corresponding nested array angle and speed to be display in chart (can be any chart)...please suggest me im new to the kibana.

2

Hi @chaithanya_sivapuram. Most Kibana charts can not access nested arrays in the format you are presenting. It may be possible to do this with a custom Vega visualization, but building that can be a difficult process.

If I were you, I would denormalize the rawData array into separate documents in Elasticsearch. So each document contains the frequency, channel, antenna, bandwidth, angle, testLocation, speed and stream.

3

Hi @nickpeihl. thank you so much for the reply. I understand the complexity and we were working on that approach you have suggested. It clarified all our doubts regarding accessing the nested array data.

1 Like
4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.