“KP工作台数据漏斗(二期)”的版本间的差异
来自qingwei personal wiki
(→投入) |
(→投入) |
||
第6行: | 第6行: | ||
<source lang="sql"> | <source lang="sql"> | ||
select | select | ||
− | + | stat_date as statDate, | |
− | + | adm_amt_1d as admAmt | |
from | from | ||
− | dwp_en_dm_comp_maincatelv2_eff_d | + | dwp_en_dm_comp_maincatelv2_eff_d |
where | where | ||
− | (stat_date >= | + | ( |
− | + | stat_date >= '2018-10-01' | |
− | and admin_mbr_seq = 14 | + | and stat_date <= '2018-11-23' |
+ | ) | ||
+ | and admin_mbr_seq = '14' | ||
+ | order by | ||
+ | stat_date ASC | ||
</source> | </source> | ||
2018年11月28日 (三) 02:08的版本
描述
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-10-01'
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}