“KP工作台数据漏斗(二期)”的版本间的差异

来自qingwei personal wiki
跳转至: 导航搜索
投入
第6行: 第6行:
 
<source lang="sql">
 
<source lang="sql">
 
select
 
select
     SUM(adm_amt_1d) as sum
+
     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 &amp;gt;= #{startDate}
       and stat_date &amp;lt;= #{endDate} )
    and admin_mbr_seq = #{adminMemberSeq}