davinci仪表盘输入框配置

布满荆棘的人生 2023-07-07 03:41 35阅读 0赞

输入框设置的前提式sql中有变量但是没关系----配置好后可以删除变量  
配置控制器的时候自动让你选择再sql中的那维度一个字段过滤

选择字段:

SELECT  
 "日期"  
,  
 sum("月活账号数量") AS "sum(月活账号数量)",sum("周活账号数量") AS "sum(周活账号数量)"  
FROM (SELECT T.day as "日期",  COUNT((   CASE     WHEN (fun\_code='1011010012') THEN   fun\_code   ELSE    NULL   end )) as "总安装量", COUNT((   CASE     WHEN (fun\_code='1011010001') THEN   fun\_code   ELSE    NULL   end )) as "总注册量", COUNT((   CASE     WHEN (is\_month='1') THEN   is\_month   ELSE    NULL   end )) as "月活账号数量", COUNT((   CASE     WHEN (is\_week='1') THEN   is\_week   ELSE    NULL   end )) as "周活账号数量" FROM   (SELECT m.\*, s.event\_property\_code,s.event\_property\_value FROM cms.daily\_new\_clientrpt\_master m LEFT JOIN cms.daily\_new\_clientrpt\_slave s on m.event\_id= s.event\_id ) T  
where DATE\_SUB(now(), INTERVAL 30 DAY) <= server\_time GROUP BY "日期") T-------sql中的变量可以用表达式设置默认值

WHERE "日期" >= '2020-02-18' AND "日期" <= '2020-02-20'---输入框中条件用再套一层的方式结果基础上过滤，钻取也是如此  
GROUP BY "日期"

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3k2NjY2NjZ5_size_16_color_FFFFFF_t_70][]

选择变量:

如果选择变量，那么页面选择的值会替换变量的默认值

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3k2NjY2NjZ5_size_16_color_FFFFFF_t_70 1][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3k2NjY2NjZ5_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200220155331324.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3k2NjY2NjZ5,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3k2NjY2NjZ5_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200220155711989.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3k2NjY2NjZ5,size_16,color_FFFFFF,t_70