二月初新内容速递丨磁盘清理、图表进阶与AI探索

新春二月,学习正酣!二月上旬更新聚焦磁盘清理、图表进阶、场景深化与AI探索,助你在数据智能的道路上驰骋前行!

一、场景应用精选

酱油的数字化呼吸:当千年技艺遇上数据分析》→探索传统工艺与数据分析结合,领略数字化赋能案例。
【联合图】你的业务“双视角侦察机”使用指南》→学习联合图实战应用,提升业务分析效率。

二、二次开发视频更新

(5-2)扩展包开发知识点——知识库升级以及查询对象》→深入学习扩展包开发,掌握知识库升级与查询对象技术。

三、技术经验分享

Smartbi磁盘空间告急?这篇清理指南让你轻松腾出几十GB!》→学习磁盘空间清理方法,释放存储资源,优化系统性能。

四、AI每日一学

【AI每日一学】讲一下MCP的三个场景及优势与局限性》→每日一学AI知识,快速掌握MCP的核心要点。

五、新年活动进行中

新年第③弹 | 新春祝福驰骋:马上送祝福,立马领麦豆!》→参与新春祝福活动,赢取麦豆奖励,开启新年好运。

六、任务持续上线

【BI知识闯关】Smartbi磁盘空间告急?这篇清理指南让你轻松腾出几十GB!》→通过知识闯关巩固磁盘清理技巧,提升运维能力。
【行业场景】制曲环节合格率诊断实战》→深入制曲生产场景,学习合格率诊断分析方法,助力质量提升。
【图表应用】驾驭“联合图”,成为业务的双视角指挥官》→掌握联合图使用技巧,实现业务数据的多维度洞察。
【AI知识巩固】讲一下MCP的三个场景及优势与局限性》→巩固AI知识,了解MCP的典型场景及其优缺点。


磁盘清理释放空间,联合图表洞察双维,AI探索拓展认知——二月上旬,与数据共赴新春新征程!

麦粉社区
>
帖子详情

双Y轴zlevel属性不生效 一直被覆盖

电子表格软件 发表于 2022-11-19 12:18
发表于 2022-11-19 12:18:12


 


 



 


 


{"chart":{"width":889.5238095238095,"height":926.5873015873017,"theme":"DW_day_tend_cyan"},"xAxis":{"name":"月份","axisLabel":{"interval":0},"type":"category","filedName":"月份","fieldFormat":{"dateFormat":"","prefix":"","timeFormat":"","viewType":"TNUMBER","scale":1,"source":"SpreadSheet","decimal":0,"suffix":"","type":"INTEGER","forceDecimal":true},"data":["11","12","1","2","3","4","5","6","7","8","9","10"]},"yAxis":[{"name":"无效清洗率","axisLabel":{"show":true,"margin":8,"rotate":0,"textStyle":{"fontFamily":"sans-serif","fontSize":"12","fontWeight":"normal","color":"#c0c0c0"}},"fkLabelFormat":{"date":"","prefix":"","name":"乘百加百分号","viewType":"NONE","scale":100,"time":"","decimal":-1,"suffix":"%","type":"INTEGER"},"isApplyFormatSeries":false,"min":"0.2","max":"0.5","fieldFormat":{"dateFormat":"","prefix":"","timeFormat":"","viewType":"NONE","scale":100,"source":"","decimal":-1,"suffix":"%","type":"INTEGER","forceDecimal":true},"type":"value","minInterval":0.1},{"name":"故障次数","axisLabel":{"textStyle":{"fontFamily":"sans-serif","fontSize":"12","fontWeight":"normal","color":"#c0c0c0"}},"type":"value","fieldFormat":{"dateFormat":"","prefix":"","timeFormat":"","viewType":"TNUMBER","scale":1,"source":"SpreadSheet","decimal":0,"suffix":"","type":"INTEGER","forceDecimal":true},"minInterval":1}],"legend":{"show":false,"data":[],"zlevel":2},"chartex":{"theme":"DW_day_tend_cyan"},"sendDataSetting":{"selectParams":false,"selectCell":false},"chartTemplate":{"id":"echarts_combination","type":"echarts_combination"},"series":[{"name":"1111111","fieldFormat":{"dateFormat":"","prefix":"","timeFormat":"","viewType":"NONE","scale":1,"source":"SpreadSheet","decimal":2,"suffix":"","type":"DOUBLE","forceDecimal":true},"data":[{"rowIndex":0,"value":[0,0.39],"displayValue":"0.39","rawRowIndex":0},{"rowIndex":1,"value":[1,0.35],"displayValue":"0.35","rawRowIndex":1},{"rowIndex":2,"value":[2,0.39],"displayValue":"0.39","rawRowIndex":2},{"rowIndex":3,"value":[3,0.35],"displayValue":"0.35","rawRowIndex":3},{"rowIndex":4,"value":[4,0.33],"displayValue":"0.33","rawRowIndex":4},{"rowIndex":5,"value":[5,0.33],"displayValue":"0.33","rawRowIndex":5},{"rowIndex":6,"value":[6,0.32],"displayValue":"0.32","rawRowIndex":6},{"rowIndex":7,"value":[7,0.31],"displayValue":"0.31","rawRowIndex":7},{"rowIndex":8,"value":[8,0.3],"displayValue":"0.30","rawRowIndex":8},{"rowIndex":9,"value":[9,0.3],"displayValue":"0.30","rawRowIndex":9},{"rowIndex":10,"value":[10,0.3],"displayValue":"0.30","rawRowIndex":10},{"rowIndex":11,"value":[11,0.3],"displayValue":"0.30","rawRowIndex":11}],"type":"line","zlevel":2,"markPoint":{"data":[{"name":"Max","type":"max"},{"name":"Min","type":"min"}],"label":{"normal":{}}}},{"name":"jhgjhgjhg","fieldFormat":{"dateFormat":"","prefix":"","timeFormat":"","viewType":"TNUMBER","scale":1,"source":"SpreadSheet","decimal":0,"suffix":"","type":"INTEGER","forceDecimal":true},"data":[{"rowIndex":0,"value":[0,590],"displayValue":"590","rawRowIndex":0},{"rowIndex":1,"value":[1,580],"displayValue":"580","rawRowIndex":1},{"rowIndex":2,"value":[2,570],"displayValue":"570","rawRowIndex":2},{"rowIndex":3,"value":[3,560],"displayValue":"560","rawRowIndex":3},{"rowIndex":4,"value":[4,550],"displayValue":"550","rawRowIndex":4},{"rowIndex":5,"value":[5,540],"displayValue":"540","rawRowIndex":5},{"rowIndex":6,"value":[6,530],"displayValue":"530","rawRowIndex":6},{"rowIndex":7,"value":[7,520],"displayValue":"520","rawRowIndex":7},{"rowIndex":8,"value":[8,510],"displayValue":"510","rawRowIndex":8},{"rowIndex":9,"value":[9,500],"displayValue":"500","rawRowIndex":9},{"rowIndex":10,"value":[10,458],"displayValue":"458","rawRowIndex":10},{"rowIndex":11,"value":[11,250],"displayValue":"250","rawRowIndex":11}],"type":"bar","barWidth":10,"yAxisIndex":1,"zlevel":1}],"resId":"I8a5260490183c1d3c1d3544f01843dca34b74304","id":"I8a5260490183c1d3c1d3544f01843dcfa2994985","chartdata":{"data":[[{"displayValue":"0.39","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.39},{"displayValue":"590","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":590},{"displayValue":"11","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":11}],[{"displayValue":"0.35","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.35},{"displayValue":"580","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":580},{"displayValue":"12","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":12}],[{"displayValue":"0.39","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.39},{"displayValue":"570","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":570},{"displayValue":"1","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":1}],[{"displayValue":"0.35","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.35},{"displayValue":"560","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":560},{"displayValue":"2","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":2}],[{"displayValue":"0.33","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.33},{"displayValue":"550","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":550},{"displayValue":"3","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":3}],[{"displayValue":"0.33","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.33},{"displayValue":"540","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":540},{"displayValue":"4","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":4}],[{"displayValue":"0.32","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.32},{"displayValue":"530","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":530},{"displayValue":"5","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":5}],[{"displayValue":"0.31","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.31},{"displayValue":"520","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":520},{"displayValue":"6","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":6}],[{"displayValue":"0.30","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.3},{"displayValue":"510","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":510},{"displayValue":"7","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":7}],[{"displayValue":"0.30","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.3},{"displayValue":"500","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":500},{"displayValue":"8","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":8}],[{"displayValue":"0.30","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.3},{"displayValue":"458","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":458},{"displayValue":"9","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":9}],[{"displayValue":"0.30","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":0.3},{"displayValue":"250","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":250},{"displayValue":"10","col":0,"df":null,"realValue":"","sheetName":"","row":0,"value":10}]],"bigDataHelper":null,"bigData":false,"mergeData":[],"rowsCount":12,"paramsData":[{"value":"7","key":"OutputParameter.低温工厂ID"},{"value":"2022","key":"OutputParameter.查询年"},{"value":"10","key":"OutputParameter.查询月"},{"value":"2021","key":"OutputParameter.趋势开始年"},{"value":"10","key":"OutputParameter.趋势开始月"}],"columnsCount":3,"fields":[{"changedFiled":null,"realName":"","dataFormat":{"dateFormat":"","prefix":"","timeFormat":"","viewType":"NONE","scale":1,"source":"SpreadSheet","decimal":2,"suffix":"","type":"DOUBLE","forceDecimal":true},"name":"","alias":"无效清洗率","id":"BizViewOutField.I8a5260490183c1d3c1d3544f0184280fe1d10975.I8a5260490183c1d3c1d3544f01840a0739776d7e"},{"changedFiled":null,"realName":"","dataFormat":{"dateFormat":"","prefix":"","timeFormat":"","viewType":"TNUMBER","scale":1,"source":"SpreadSheet","decimal":0,"suffix":"","type":"INTEGER","forceDecimal":true},"name":"","alias":"故障次数","id":"BizViewOutField.I8a5260490183c1d3c1d3544f0184280fe1d10975.I8a5260490183c1d3c1d3544f01840a0739776d7f"},{"changedFiled":null,"realName":"","dataFormat":{"dateFormat":"","prefix":"","timeFormat":"","viewType":"TNUMBER","scale":1,"source":"SpreadSheet","decimal":0,"suffix":"","type":"INTEGER","forceDecimal":true},"name":"","alias":"月份","id":"BizViewOutField.I8a5260490183c1d3c1d3544f0184280fe1d10975.I8a5260490183c1d3c1d3544f01840a0589fe6b3e"}],"echartsParentMapIds":{"OutputParameter.趋势开始年":"","OutputParameter.查询月":"","OutputParameter.查询年":"","OutputParameter.低温工厂ID":"","OutputParameter.趋势开始月":""},"mergerOtherObj":null},"chartRenderer":"canvas","chartDefine":"{\"chartDatas\":{\"fieldList\":[{\"id\":\"BizViewOutField.I8a5260490183c1d3c1d3544f0184280fe1d10975.I8a5260490183c1d3c1d3544f01840a0739776d7e\",\"name\":\"无效清洗率\",\"alias\":\"无效清洗率\",\"axisType\":\"yAxis\",\"chartType\":\"line\"},{\"id\":\"BizViewOutField.I8a5260490183c1d3c1d3544f0184280fe1d10975.I8a5260490183c1d3c1d3544f01840a0739776d7f\",\"name\":\"故障次数\",\"alias\":\"故障次数\",\"axisType\":\"syAxis\",\"chartType\":\"bar\",\"seriesOptions\":{\"barWidth\":10}},{\"id\":\"BizViewOutField.I8a5260490183c1d3c1d3544f0184280fe1d10975.I8a5260490183c1d3c1d3544f01840a0589fe6b3e\",\"name\":\"月份\",\"alias\":\"月份\",\"axisType\":\"categories\"}],\"insertMode\":\"SmartbiOfficeAddIn2007.InsertChart2\",\"datasetMode\":true}}","tooltip":{"axisPointer":{"lineStyle":{"color":"#cccccc","width":1},"crossStyle":{"color":"#cccccc","width":1}}},"grid":{}}

发表于 2022-11-19 12:19:51
492806378596504bd0.png
回复

使用道具 举报

发表于 2022-11-19 12:20:24
675776378597bbc26b.png
回复

使用道具 举报

发表于 2022-11-19 12:35:53
1988963785d2617dfa.png
function main(chartView) {
    var echarts = chartView.getChartObject();
    var option = echarts.getOptions("ECharts1"); //获取图形信息,此option已由smartbi系统封装。
    try {
        var serie = option.series[1]; //获取"销售量"的信息
serie.zlevel=0;

    } catch (e) {
        e.printStackTrace();
    }
}

回复

使用道具 举报

高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

4回帖数 0关注人数 1986浏览人数
最后回复于:2022-11-19 12:35

社区

指南

快速回复 返回顶部 返回列表