elasticsearch - 具有百分比计算的 Kibana 仪表板

Question

我有一个index学生的出勤数据。

{
  "date" : "24/07/2018",
  "Total students" : 30,
  "present" : 10,
  "absent" : 20
},
{
  "date" : "24/08/2018",
  "Total students" : 40,
  "present" : 20,
  "absent" : 20
}

我想为以下内容创建仪表板Kibana visualize：

1. 按月汇总的缺勤学生百分比
   
2. 按月汇总的在场学生百分比

elastic search查询可能如下：

POST students_data/_search
{
    "size": 0,
    "aggs" : {
        "agg_per_month" : {
            "date_histogram" : {
                "field" : "date",
                "calendar_interval" : "month"
            },
            "aggs": {
                "total_students": {
                    "sum": {
                        "field": "Total students"
                    }
                },
                "tot_absentees": {
                  "sum": {
                        "field": "absent"
                    }
                },
                "absentees-percentage": {
                    "bucket_script": {
                        "buckets_path": {
                          "param_tot_absentees": "tot_absentees",
                          "param_tot_students": "total_students"
                        },
                        "script": "params.param_tot_absentees / params.param_tot_students * 100"
                    }
                }
            }
        }
    }
}

我不知道如何在 Kibana 可视化工具中完成这项工作

标签： elasticsearchkibana-7