VEGA Kibana -多视图图表扁平化变换

Question

我很难弄清楚如何在Vega中使用聚合/嵌套来构建多视图图表。

我相信这与我试图将我的数据转换为Vega多视图图表的方式有关。有人能帮我理解一下吗？

我知道扁平化转换可以像debug显示的那样工作。

​

​

但我得到的是

​

​

这就是我想要实现的

​

​

这是我构建图表的方案

{
  "$schema": "https://vega.github.io/schema/vega/v3.json",
  "width": 400,
  "height": 200,
  "padding": 5,
  "data": [
    {
      "name": "source",
      "values": {
        "aggregations": {
          "order_labels": {
            "buckets": [
              {
                "key": "USD/CAD",
                "doc_count": 1,
                "orders": {
                  "doc_count": 40,
                  "orders_id": {
                    "buckets": [
                      {
                        "key": 5241,
                        "doc_count": 1,
                        "orders_price": {"value": 0.01991}
                      },
                      {
                        "key": 5242,
                        "doc_count": 1,
                        "orders_price": {"value": 0.02021}
                      }
                    ]
                  }
                }
              },
              {
                "key": "CAD/COD",
                "doc_count": 1,
                "orders": {
                  "doc_count": 40,
                  "orders_id": {
                    "buckets": [
                      {
                        "key": 5041,
                        "doc_count": 1,
                        "orders_price": {"value": 0.00002953}
                      },
                      {
                        "key": 5042,
                        "doc_count": 1,
                        "orders_price": {"value": 0.00002971}
                      }
                    ]
                  }
                }
              }
            ]
          }
        }
      },
    "format": {"property": "aggregations.order_labels.buckets"},
    "transform": [
      {
        "type": "flatten",
        "fields": ["orders.orders_id.buckets"],
        "as": ["orders"]
      }
    ]
  }
  ],
  "mark": "bar",
  "encoding": {
    "row": {
      "field": "orders.key",
      "type": "ordinal"
    },
    "x": {
      "aggregate": "sum",
      "field": "orders.orders_price.value",
      "type": "quantitative",
      "scale": { "zero": false }
    },
    "y": {
      "field": "key",
      "type": "ordinal",
      "scale": { "rangeStep": 12 }
    }
  }
}

我做了很多事情，但都不明白出了什么问题。

Answer 1

Kibana 6.4肯定支持扁平变换。我认为它在6.3中也得到了支持。