如图,我想只获得'2023-01'这个值,请问在数据集里如何处理
FORMAT(TODATE(MAX(UNIQUEARRAY(MAPARRAY(SPLIT($comboCheckBox0,","),DATETONUMBER(CONCATENATE(ITEM,"-01")))))),"yyyy-MM")
where 字段='${max(SPLIT(参数,","))}'
where 字段='${max(参数)}'
其中字符传,替换成你的下拉复选框控件名就可以
CONCATENATE(left(max(MAPARRAY(split("2023-01,2022-12,2022-11",","),replace(item,"-",""))),4),"-",right(max(MAPARRAY(split("2023-01,2022-12,2022-11",","),replace(item,"-",""))),2))