透视表

在仪表板中您可以添加各种可视化组件来展示数据，本节以一张最简单的透视表示例为例带您快速了解创建仪表板的流程。

1. 数据准备

新增数据源并添加到数据集。

（1）数据源配置

数据源属性	属性值
Web API地址	https://result.eolink.com/jLwe6LL471d5112ef61d6b2ebe579a5190be3ee81164537?uri=/pivot-table-example
请求方法	GET
JSON路径	$.data[*]

JSON数据：

{
    "success": true,
    "code": 200,
    "message": "successful",
    "data": [{
        "id": "1",
        "customerprovince": "河北省",
        "customerarea": "华北",
        "classificationname": "调味品",
        "purchasequantity": 1957,
        "orderamount": 4.5
    }, {
        "id": "2",
        "customerprovince": "天津市",
        "customerarea": "华北",
        "classificationname": "调味品",
        "purchasequantity": 2545,
        "orderamount": 5.8
    }, {
        "id": "3",
        "customerprovince": "北京市",
        "customerarea": "华北",
        "classificationname": "调味品",
        "purchasequantity": 2076,
        "orderamount": 4.7
    }, {
        "id": "4",
        "customerprovince": "河北省",
        "customerarea": "华北",
        "classificationname": "点心",
        "purchasequantity": 2047,
        "orderamount": 4.5
    }, {
        "id": "5",
        "customerprovince": "天津市",
        "customerarea": "华北",
        "classificationname": "点心",
        "purchasequantity": 2347,
        "orderamount": 6.5
    }, {
        "id": "6",
        "customerprovince": "北京市",
        "customerarea": "华北",
        "classificationname": "点心",
        "purchasequantity": 2447,
        "orderamount": 5.5
    }, {
        "id": "7",
        "customerprovince": "江苏省",
        "customerarea": "华东",
        "classificationname": "调味品",
        "purchasequantity": 1611,
        "orderamount": 3.5
    }, {
        "id": "8",
        "customerprovince": "上海市",
        "customerarea": "华东",
        "classificationname": "调味品",
        "purchasequantity": 2787,
        "orderamount": 6.3
    }, {
        "id": "9",
        "customerprovince": "浙江省",
        "customerarea": "华东",
        "classificationname": "调味品",
        "purchasequantity": 2447,
        "orderamount": 5.9
    }, {
        "id": "10",
        "customerprovince": "江苏省",
        "customerarea": "华东",
        "classificationname": "点心",
        "purchasequantity": 2067,
        "orderamount": 5.7
    }, {
        "id": "11",
        "customerprovince": "上海市",
        "customerarea": "华东",
        "classificationname": "点心",
        "purchasequantity": 2347,
        "orderamount": 7.7
    }, {
        "id": "12",
        "customerprovince": "浙江省",
        "customerarea": "华东",
        "classificationname": "点心",
        "purchasequantity": 1547,
        "orderamount": 6.4
    }],
    "count": 12
}