总体思路,获取图表最大数据值,自定义设置图表Y轴的最大值,最大值乘以1.2,即可保证数据标签显示完全。
1.先看下问题现象:
数据标签显示一半
修改后
2.修改方法:
2.1.新建数据集,获取图表中最大数据值
eg:
select
-- ,ProjCode
-- ,ProjName
DataMonth
,concat(right(DataYear,2),'-',DataMonth) Classify
-- ,(sum(actu_mny_org)/10000)/(sum(Receivable)/10000) proportion
,sum(Receivable)/10000 Receivable
,sum(actu_mny_org)/10000 actu_mny_org
-- ,UpdateTime
from APP_SYKB_FINANCIAL_COLLECTION_FACT
WHERE DataYear=year('${dt_date}')
and OrgCode='${cb_proj}'
group by concat(right(DataYear,2),'-',DataMonth),DataMonth
UNION all
select
DataMonth
,concat(right(DataYear,2),'-',DataMonth) Classify
-- ,(sum(actu_mny_org)/10000)/(sum(Receivable)/10000) proportion
,sum(Receivable)/10000 Receivable
,sum(actu_mny_org)/10000 actu_mny_org
-- ,UpdateTime
from APP_SYKB_FINANCIAL_COLLECTION_FACT
WHERE DataYear=year('${dt_date}')
and '${cb_proj}'='JT001'
group by concat(right(DataYear,2),'-',DataMonth),DataMonth
order by DataMonth
2.2设置图表属性
最大值:max(ds3.select(Receivable))*1.2