Nested data for Kibana analyzis

Elastic Stack Kibana
1

Hi all,

I am new to Kibana and I am trying to create a dashboard with nested data. The idea would be to create live orderbook dashboard.

The kind of document I create is :

[{'index': {'_index': 'live-prices-binance_', '_id': 3511396120}}, {'name': '1733573683814_BTCUSDT', 'timestamp': 1733573683814, 'symbol': 'BTCUSDT', 'bids': [{'price': 89699.0, 'quantity': 0.0002}, {'price': 89698.0, 'quantity': 0.0}], 'asks': [{'price': 99666.0, 'quantity': 2.41304}, {'price': 99676.4, 'quantity': 0.01}, {'price': 99748.14, 'quantity': 0.0}, {'price': 99748.15, 'quantity': 0.0}, {'price': 99755.97, 'quantity': 0.0}, {'price': 99785.1, 'quantity': 6e-05}]}]

And the mapping of my index is the following :

{
  "live-prices-binance_": {
    "mappings": {
      "properties": {
        "asks": {
          "type": "nested",
          "properties": {
            "price": {"type": "float"},
            "quantity": {"type": "float"}
          }
        },
        "bids": {
          "type": "nested",
          "properties": {
            "price": {"type": "float"},
            "quantity": {"type": "float"}
          }
        },
        "name": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },
        "symbol": {
          "type": "keyword"
        },
        "timestamp": {
          "type": "long"
        }
      }
    }
  }
}

The problem is when I try to create visualization in kibana from the nested data, the fields asks.price, asks.quantity, bids.price and bids.quantity are empty.

Any idea please?

Thanks