113371
以上数据集查询预览都没问题,但是area_tj点击+号可以加载出数据列,为什么其他不行呢?以gzbranch_tj脚本为例,其他加载不出的脚本雷同,只是group by 统计维度不同而已
--area_tj数据集脚本
select t.area_name,
sum(t.change_num) change_num,
sum(t.val_change) val_change,
round(sum(t.val_change)/sum(t.change_num),2) avg_chngval,
sum(t.highchange_num) highchng_num,
round(sum(t.highchange_num)/sum(t.change_num)*100,2)||'%' highchng_pp,
sum(t.lowchange_num) lowchng_num,
round(sum(t.lowchange_num)/sum(t.change_num)*100,2)||'%' lowchng_pp
from zsyw.sp_rpt_stkcust_tjvalue t
where t.date_id>='${FORMAT(s_date,'yyyyMMdd')}' and t.date_id<='${FORMAT(e_date,'yyyyMMdd')}'
group by t.area_name
--gzbranch_tj数据集脚本
select t.area_name,t.branch_name_lz,
sum(t.change_num) change_num,
sum(t.val_change) val_change,
sum(t.val_change)/sum(t.change_num) avg_chngval,
sum(t.highchange_num) highchng_num,
round(sum(t.highchange_num)/sum(t.change_num)*100,2)||'%' highchng_pp,
sum(t.lowchange_num) lowchng_num,
round(sum(t.lowchange_num)/sum(t.change_num)*100,2)||'%' lowchng_pp
from zsyw.sp_rpt_stkcust_tjvalue t
where t.date_id>='${FORMAT(s_date,'yyyyMMdd')}' and t.date_id<='${FORMAT(e_date,'yyyyMMdd')}'
and t.branch_type='公众'
group by t.area_name,t.branch_name_lz