“KP工作台数据漏斗(二期)”的版本间的差异
来自qingwei personal wiki
(→external.kpwork.amtDays) |
(→投入) |
||
第12行: | 第12行: | ||
where | where | ||
( | ( | ||
− | stat_date >= '2018- | + | stat_date >= '2018-11-20' |
and stat_date <= '2018-11-23' | and stat_date <= '2018-11-23' | ||
) | ) |
2018年11月28日 (三) 07:59的版本
描述
https://aone.alibaba-inc.com/req/17899072
二级页面SQL
大盘漏斗
投入
select
stat_date as statDate,
adm_amt_1d as admAmt
from
dwp_en_dm_comp_maincatelv2_eff_d
where
(
stat_date >= '2018-11-20'
and stat_date <= '2018-11-23'
)
and admin_mbr_seq = '14'
order by
stat_date ASC
oneness
external.kpwork.amtDays
select
${returnFields}
from
dwp_en_dm_comp_maincatelv2_eff_d
where
( stat_date &gt;= #{startDate}
and stat_date &lt;= #{endDate} )
and admin_mbr_seq = #{adminMemberSeq}
order by
stat_date ASC