數據源配置 · JimuReport 積木報表

### **雷達圖支持3種數據形式：** ### **1. SQL數據** 使用SQL形式，可直接連接數據庫，將SQl種的數據篩選并顯示在圖表上。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“SQL數據集”，按步驟操作即可，下邊講解一下各個參數的意思： * 綁定數據集：是左側綁定過的數據集，可選擇任意一個SQL類型的數據集； * 分類屬性：是X軸綁定數據庫的字段； * 值屬性：是Y軸綁定數據庫的字段； #### **數據庫配置字段如下：** ![](https://img.kancloud.cn/bb/a8/bba841e5695a5dae1a017bbb20d9154e_458x430.png) ![](https://img.kancloud.cn/d7/8b/d78bc2ddfbcd473208b62421972ba2bf_807x34.png) ### **2. 靜態API數據** 報表綁定的數據可以是靜態API的形式。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“Api數據集”，“Api類型”選擇“靜態數據”，點擊“數據值”，輸入靜態類型即可，如： ``` [ {"name":"銷售（sales）","value":4300,"type":"預算分配（Allocated Budget）"}, {"name":"管理（Administration）","value":10000,"type":"預算分配（Allocated Budget）"}, {"name":"信息技術（Information Techology）","value":28000,"type":"預算分配（Allocated Budget）"}, {"name":"客服（Customer Support）","value":35000,"type":"預算分配（Allocated Budget）"}, {"name":"研發（Development）","value":50000,"type":"預算分配（Allocated Budget）"}, {"name":"市場（Marketing）","value":19000,"type":"預算分配（Allocated Budget）"}, {"name":"銷售（sales）","value":5000,"type":"實際開銷（Actual Spending）"}, {"name":"管理（Administration）","value":14000,"type":"實際開銷（Actual Spending）"}, {"name":"信息技術（Information Techology）","value":28000,"type":"實際開銷（Actual Spending）"}, {"name":"客服（Customer Support）","value":31000,"type":"實際開銷（Actual Spending）"}, {"name":"研發（Development）","value":42000,"type":"實際開銷（Actual Spending）"}, {"name":"市場（Marketing）","value":21000,"type":"實際開銷（Actual Spending）"} ] ``` ![](https://img.kancloud.cn/7f/e6/7fe6095600aa0e337f9046c30ddcf0d4_1226x540.png) ![](https://img.kancloud.cn/d7/8b/d78bc2ddfbcd473208b62421972ba2bf_807x34.png) ### **3. 動態API數據** 綁定的數據也可以是動態API的形式。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“Api數據集”，“Api類型”選擇“動態數據”，選擇“綁定數據集”，點擊“運行”，就可以將數據渲染過來，代碼如： ``` { "data": [ { "name": "周一", "value": 1000, "type": "iphone" }, { "name": "周二", "value": 1300, "type": "iphone" }, { "name": "周三", "value": 1400, "type": "iphone" }, { "name": "周四", "value": 1080, "type": "iphone" }, { "name": "周五", "value": 2000, "type": "iphone" }, { "name": "周一", "value": 1300, "type": "huawei" }, { "name": "周二", "value": 1600, "type": "huawei" }, { "name": "周三", "value": 1800, "type": "huawei" }, { "name": "周四", "value": 2000, "type": "huawei" }, { "name": "周五", "value": 3000, "type": "huawei" }, { "name": "周一", "value": 1100, "type": "xiaomi" }, { "name": "周二", "value": 1200, "type": "xiaomi" }, { "name": "周三", "value": 1300, "type": "xiaomi" }, { "name": "周四", "value": 1400, "type": "xiaomi" }, { "name": "周五", "value": 1500, "type": "xiaomi" }, { "name": "周一", "value": 1000, "type": "vivo" }, { "name": "周二", "value": 1000, "type": "vivo" }, { "name": "周三", "value": 1000, "type": "vivo" }, { "name": "周四", "value": 1000, "type": "vivo" }, { "name": "周五", "value": 1000, "type": "vivo" } ] } ```