四月上旬新内容速递丨技术深潜、图表进阶与AI热词

春意正浓,学习升温!四月上旬更新聚焦技术拓展、图表新解、AI热点与实战任务,助你在数据探索之路上步步为营,智取未来!

一、场景应用精选

【热力图】数据的“温度计”与分布探测器》→热力图在业务分布与浓度识别中的实战应用。
【数析课堂】排序法:业务人员的“数据理线器”》→排序法助力业务数据梳理,提升分析效率。
【关系图】解锁数据背后的“隐形网络”与关联密码》→关系图在复杂关联分析中的深度应用。
【数析课堂】让数据开口说话:职场人的“图形法”生存指南》→图形法职场实战指南,轻松驾驭数据表达。

二、技术经验分享

降维打击!Smartbi仪表盘隐藏ECharts玩法大揭秘》→解锁仪表盘高阶玩法,用ECharts实现可视化降维创新。
“数”转乾坤:数据转换规则变形记》→深入数据转换规则,掌握数据变形与流转的核心技巧。

三、AI知识更新

【AI每日一学】简要介绍一下最近AI圈很火的“养龙虾”话题》→每日一学,快速理解AI圈热门话题“养龙虾”。
【AI每日一学】讲一下最近AI圈很火的“养龙虾”话题中一直被提及的skill》→深度解析“养龙虾”中的关键技能概念,紧跟AI前沿。

四、全新素材上线

指标元素动态图(二)》→新增指标动态图素材,丰富仪表盘视觉表现力。

五、官方通知更新

2026年「月更日志」社区更新合集 3.1 - 3.31》→回顾三月社区更新动态,掌握平台最新进展。
春日如约而至:2026年第一季度任务通关排行榜请查收!》→揭晓Q1任务通关榜单,激励持续学习与挑战。

六、任务持续上线

【AI知识巩固】简要介绍一下最近AI圈很火的“养龙虾”话题》→追踪AI圈最新热词,轻松入门“养龙虾”现象。
【图表应用】热力图:数据的“温度计”与分布探测器》→学习热力图制作,让数据热度一目了然。
【BI知识闯关】降维打击!Smartbi仪表盘隐藏ECharts玩法大揭秘》→实战闯关,巩固仪表盘隐藏技能。
【数析课堂】排序法知识巩固》→掌握排序分析法,梳理数据层级关系。
【图表应用】关系图:挖掘数据背后的“隐形关系网”》→学习关系图绘制,发现数据间的隐秘关联。
【BI知识闯关】重生之如何找SQL看数据不对问题(上)》→SQL排错实战,提升数据校验能力。
【BI知识闯关】“数”转乾坤:数据转换规则变形记》→闯关巩固数据转换规则应用。
【AI知识巩固】讲一下最近AI圈很火的“养龙虾”话题中一直被提及的skill》→深入“养龙虾”背后的技能概念,拓展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关注人数 2293浏览人数
最后回复于:2022-11-19 12:35

社区

指南

AI

搜索

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