KP工作枱數據漏斗（二期）

描述

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 >= #{startDate}
       and stat_date <= #{endDate} )
    and admin_mbr_seq = #{adminMemberSeq}