6.2 氣泡散點圖數據源配置 · JimuReport 積木報表

### **氣泡散點圖支持3種數據形式：** ``` 特別注意： * 氣泡散點圖：只支持多數據源配置； * 散點圖的X軸和Y軸必須是數值，其他類型的暫不支持； ``` ### **1. SQL數據** 使用SQL形式，可直接連接數據庫，將SQl種的數據篩選并顯示在圖表上。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“SQL數據集”，按步驟操作即可，下邊講解一下各個參數的意思： * 綁定數據集：是左側綁定過的數據集，可選擇任意一個SQL類型的數據集； * 分類屬性：是X軸綁定數據庫的字段； * 值屬性：是Y軸綁定數據庫的字段； #### **數據庫配置字段如下：** ![](https://img.kancloud.cn/15/54/1554c70188e97e9dfbc5b4a91ee753e0_393x433.png) ### **2. 靜態API數據** 報表綁定的數據可以是靜態API的形式。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“Api數據集”，“Api類型”選擇“靜態數據”，點擊“數據值”，輸入靜態類型即可，如： ``` [ {"name":28604,"value":77,"type":"1990"}, {"name":31163,"value":77.4,"type":"1990"}, {"name":1516,"value":68,"type":"1990"}, {"name":13670,"value":74.7,"type":"1990"}, {"name":28599,"value":75,"type":"1990"}, {"name":29476,"value":77.1,"type":"1990"}, {"name":31476,"value":75.4,"type":"1990"}, {"name":28666,"value":78.1,"type":"1990"}, {"name":1777,"value":57.7,"type":"1990"}, {"name":29550,"value":79.1,"type":"1990"}, {"name":2076,"value":67.9,"type":"1990"}, {"name":12087,"value":72,"type":"1990"}, {"name":24021,"value":75.4,"type":"1990"}, {"name":43296,"value":76.8,"type":"1990"}, {"name":10088,"value":70.8,"type":"1990"}, {"name":19349,"value":69.6,"type":"1990"}, {"name":44056,"value":81.8,"type":"2015"}, {"name":43294,"value":81.7,"type":"2015"}, {"name":13334,"value":76.9,"type":"2015"}, {"name":21291,"value":78.5,"type":"2015"}, {"name":38923,"value":80.8,"type":"2015"}, {"name":37599,"value":81.9,"type":"2015"}, {"name":44053,"value":81.1,"type":"2015"}, {"name":42182,"value":82.8,"type":"2015"}, {"name":5903,"value":66.8,"type":"2015"}, {"name":36162,"value":83.5,"type":"2015"}, {"name":1390,"value":71.4,"type":"2015"}, {"name":34644,"value":80.7,"type":"2015"}, {"name":34186,"value":80.6,"type":"2015"}, {"name":64304,"value":81.6,"type":"2015"}, {"name":24787,"value":77.3,"type":"2015"} ] ``` 備注：代碼格式按上邊格式寫，才可渲染效果； ![](https://img.kancloud.cn/b6/20/b620de2c5dd56d70492cc7318a9265cd_1308x521.png) ### **3. 動態API數據** 綁定的數據也可以是動態API的形式。點擊報表編輯器右側的操作欄，點擊“數據”，選擇"數據類型"為“Api數據集”，“Api類型”選擇“動態數據”，選擇“綁定數據集”，點擊“運行”，就可以將數據渲染過來，代碼如： ``` { "data": [{ "name": 28604, "value": 77, "type": "1990" }, { "name": 31163, "value": 77.4, "type": "1990" }, { "name": 1516, "value": 68, "type": "1990" }, { "name": 13670, "value": 74.7, "type": "1990" }, { "name": 28599, "value": 75, "type": "1990" }, { "name": 29476, "value": 77.1, "type": "1990" }, { "name": 31476, "value": 75.4, "type": "1990" }, { "name": 28666, "value": 78.1, "type": "1990" }, { "name": 1777, "value": 57.7, "type": "1990" }, { "name": 29550, "value": 79.1, "type": "1990" }, { "name": 2076, "value": 67.9, "type": "1990" }, { "name": 12087, "value": 72, "type": "1990" }, { "name": 24021, "value": 75.4, "type": "1990" }, { "name": 43296, "value": 76.8, "type": "1990" }, { "name": 10088, "value": 70.8, "type": "1990" }, { "name": 19349, "value": 69.6, "type": "1990" }, { "name": 44056, "value": 81.8, "type": "2015" }, { "name": 43294, "value": 81.7, "type": "2015" }, { "name": 13334, "value": 76.9, "type": "2015" }, { "name": 21291, "value": 78.5, "type": "2015" }, { "name": 38923, "value": 80.8, "type": "2015" }, { "name": 37599, "value": 81.9, "type": "2015" }, { "name": 44053, "value": 81.1, "type": "2015" }, { "name": 42182, "value": 82.8, "type": "2015" }, { "name": 5903, "value": 66.8, "type": "2015" }, { "name": 36162, "value": 83.5, "type": "2015" }, { "name": 1390, "value": 71.4, "type": "2015" }, { "name": 34644, "value": 80.7, "type": "2015" }, { "name": 34186, "value": 80.6, "type": "2015" }, { "name": 64304, "value": 81.6, "type": "2015" }, { "name": 24787, "value": 77.3, "type": "2015" } ] } ``` 備注：代碼格式按上邊格式寫，才可渲染效果； ![](https://img.kancloud.cn/fc/6e/fc6e0917260fe698da0a179d80f4601b_1132x537.png) ![](https://img.kancloud.cn/3c/dc/3cdc333649d9d3d0d0c0c068d9ef6fd9_804x24.png)