“KP工作台数据漏斗（二期）”的版本间的差异
来自qingwei personal wiki
（→大盘漏洞） |
|||
| 第2行： | 第2行： | ||
https://aone.alibaba-inc.com/req/17899072 | https://aone.alibaba-inc.com/req/17899072 | ||
== 二级页面SQL == | == 二级页面SQL == | ||
| − | === 大盘漏 | + | === 大盘漏 斗 === |
| + | ==== 投入 ==== | ||
| + | <source lang="sql"> | ||
| + | select | ||
| + | ${returnFields} | ||
| + | from | ||
| + | dwp_en_dm_comp_maincatelv2_eff_d | ||
| + | where | ||
| + | ( stat_date >= "2018-10-01" | ||
| + | and stat_date <= "2018-10-10" ) | ||
| + | and admin_mbr_seq = 14 | ||
| + | </source> | ||
[[category: 阿里]] | [[category: 阿里]] | ||
[[category: 数据管家]] | [[category: 数据管家]] | ||
2018年11月27日 (二) 09:49的版本
描述
https://aone.alibaba-inc.com/req/17899072
二级页面SQL
大盘漏斗
投入
select
${returnFields}
from
dwp_en_dm_comp_maincatelv2_eff_d
where
( stat_date >= "2018-10-01"
and stat_date <= "2018-10-10" )
and admin_mbr_seq = 14
