charts - 如何使用 Vega 在雷达图中显示平均值

Question

我正在尝试使用 Vega 构建雷达图。

我的示例数据如下：

"data": [
{
  "name": "table",
  "values": [
    {
      "country": "Egypt",
      "Rating": 9,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "General Application Xperience Survey",
      "department_displayvalue": "Coffee"
    },
    {
      "country": "Japan",
      "Rating": 8,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "General Application Xperience Survey",
      "department_displayvalue": "Digital"
    },
    {
      "country": "Greece",
      "Rating": 4,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "Business Application Xperience Survey",
      "department_displayvalue": "Medicine"
    },
    {
      "country": "France",
      "Rating": 8,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "Business Application Xperience Survey",
      "department_displayvalue": "HR"
    },
    {
      "country": "Japan",
      "Rating": 7,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "Business Application Xperience Survey",
      "department_displayvalue": "Digital"
    },
    {
      "country": "Japan",
      "Rating": 10,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "Business Application Xperience Survey",
      "department_displayvalue": "Pc"
    },
    {
      "country": "Japan",
      "Rating": 8,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "Business Application Xperience Survey",
      "department_displayvalue": "Pc"
    },
    {
      "country": "Japan",
      "Rating": 8,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "Business Application Xperience Survey",
      "department_displayvalue": "Medicine"
    },
    {
      "country": "Denmark",
      "Rating": 3,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "Business Application Xperience Survey",
      "department_displayvalue": "Pc"
    },
    {
      "country": "Netherlands",
      "Rating": 6,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "General Application Xperience Survey",
      "department_displayvalue": "HR"
    },
    {
      "country": "Turkiye",
      "Rating": 5,
      "taken_on": "2021-06-09 10:00:57",
      "dv_survey": "Business Application Xperience Survey",
      "department_displayvalue": "Coffee"
    }
  ]

我能够使用在线示例（以下链接）创建雷达图。但我想显示平均值而不是每个部门的每个值。目前，通过调查着色并不重要。如何更改此代码以使用平均评分？

任何帮助表示赞赏！

我在编辑器中的代码

标签： chartskibanavega-litevegaradar-chart

Answer 1

看来您正在寻找的是一种转变。特别是聚合转换，这是您需要实现的工作示例。

  "transform": [
    {
      "type": "aggregate",
      "groupby": [
        "department_displayvalue"
      ],
      "fields": [
        "Rating"
      ],
      "ops": [
        "average"
      ],
      "as": [
        "Rating"
      ]
    }
  ]

我最终得到了这个......这是源代码。