davinci筛选问题

红太狼 2023-07-09 02:04 8阅读 0赞

1，sql中筛选 。0 的不显示

SELECT  
"用户对象",   
"二级部门",  
"总人数",  
"总注册量",  
"当日注册量",  
multiIf(isNull("月活账号数量"),0,"月活账号数量") AS "月活账号数量" ,  
multiIf(isNull("周活账号数量"),0,"周活账号数量") AS "周活账号数量"  
FROM

(SELECT   
T.dept\_one as "用户对象",  
T.dept\_two as "二级部门",  
any((  
  CASE  
     WHEN  (server\_time >=toDate($g$) ) THEN  
   member\_count  
  ELSE  
   NULL  
    end  
 )) as "总人数",  
COUNT((  
  CASE  
    WHEN (event\_code='101101000100016' ) THEN  
  event\_code  
  ELSE      
   NULL  
  end  
)) as "总注册量",  
COUNT((  
  CASE  
    WHEN (event\_code='101101000100016' and server\_time >=toDate($g$)) THEN  
  event\_code  
  ELSE  
   NULL  
  end  
)) as "当日注册量",  
COUNT(  
  DISTINCT(  
  CASE  
    WHEN (is\_month='1' ) THEN  
  name  
  ELSE  
   NULL  
  end  
)) as "月活账号数量",  
COUNT(  
  DISTINCT(  
  CASE  
    WHEN (is\_week='1' ) THEN  
  name  
  ELSE  
   NULL  
  end  
)) as "周活账号数量"

FROM    
(SELECT m.\*, s.event\_property\_code,s.event\_property\_value FROM default.daily\_new\_clientrpt\_master m LEFT JOIN default.daily\_new\_clientrpt\_slave s on m.event\_id= s.event\_id  WHERE auth\_type IN ('2')  ORDER BY collect\_timing DESC ) T   GROUP BY "用户对象" , "二级部门" )  
WHERE "周活账号数量" !=0;

2，davinci页面筛选--纬度，指标筛选

![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]: https://img-blog.csdnimg.cn/20200227094014648.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3k2NjY2NjZ5,size_16,color_FFFFFF,t_70