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

**URL:** <https://discuss.elastic.co/t/is-there-any-possibilite-to-access-the-nested-arrays-in-json-input-data-to-show-it-in-kibana-charts/251711>\
**Category:** Kibana\
**Created:** [October 12, 2020, 4:50am UTC](https://discuss.elastic.co/t/is-there-any-possibilite-to-access-the-nested-arrays-in-json-input-data-to-show-it-in-kibana-charts/251711 "2020-10-12T04:50:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![chaithanya\_sivapuram](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chaithanya_sivapuram/32/47533_2.png) [@chaithanya\_sivapuram](https://discuss.elastic.co/u/chaithanya_sivapuram)\
**Post date:** [October 12, 2020, 4:50am UTC](https://discuss.elastic.co/t/is-there-any-possibilite-to-access-the-nested-arrays-in-json-input-data-to-show-it-in-kibana-charts/251711/1 "2020-10-12T04:50:15Z")

</div>

```javascript
{
  "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.

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [October 12, 2020, 10:28pm UTC](https://discuss.elastic.co/t/is-there-any-possibilite-to-access-the-nested-arrays-in-json-input-data-to-show-it-in-kibana-charts/251711/2 "2020-10-12T22:28:37Z")

</div>

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`.

---

<div class="post-metadata">

**Author:** ![chaithanya\_sivapuram](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chaithanya_sivapuram/32/47533_2.png) [@chaithanya\_sivapuram](https://discuss.elastic.co/u/chaithanya_sivapuram)\
**Post date:** [October 13, 2020, 4:29am UTC](https://discuss.elastic.co/t/is-there-any-possibilite-to-access-the-nested-arrays-in-json-input-data-to-show-it-in-kibana-charts/251711/3 "2020-10-13T04:29:16Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 10, 2020, 4:29am UTC](https://discuss.elastic.co/t/is-there-any-possibilite-to-access-the-nested-arrays-in-json-input-data-to-show-it-in-kibana-charts/251711/4 "2020-11-10T04:29:46Z")

</div>

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