“KP工作台数据漏斗(二期)”的版本间的差异
来自qingwei personal wiki
(→投入) |
|||
第6行: | 第6行: | ||
<source lang="sql"> | <source lang="sql"> | ||
select | select | ||
− | + | adm_amt_1d, | |
+ | stat_date | ||
from | from | ||
dwp_en_dm_comp_maincatelv2_eff_d | dwp_en_dm_comp_maincatelv2_eff_d | ||
第14行: | 第15行: | ||
and admin_mbr_seq = 14 | and admin_mbr_seq = 14 | ||
</source> | </source> | ||
+ | |||
== oneness == | == oneness == | ||
=== external.kpwork.amtDays === | === external.kpwork.amtDays === |
2018年11月27日 (二) 12:38的版本
描述
https://aone.alibaba-inc.com/req/17899072
二级页面SQL
大盘漏斗
投入
select
adm_amt_1d,
stat_date
from
dwp_en_dm_comp_maincatelv2_eff_d
where
(stat_date >= "2018-11-01"
and stat_date <= "2018-11-23")
and admin_mbr_seq = 14
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}