sql中的统计完全按照group by 的粒度统计

sql中的统计完全按照group by 的粒度统计，前面的字段多粒度就细，想要更粗的粒度可以再外面包一层字段少的，粗粒度的聚合

davinci中只选一个粗粒的维度相当于外包一层见粗粒度示例---维度就是聚合的粒度，维度越多，结果集基础上聚合越细

细粒度：

SELECT 
T.fun_name as "模块名",
T.event_code as "事件编码",
SUM(click_records) as "点击数量",
round(SUM(stay_time)/60000,0) as "使用时长(单位：分钟)"
FROM  
(SELECT m.* FROM default.daily_new_clientrpt_master m ) T   where  day  = today() GROUP BY "模块名" ,"事件编码";

粗粒度：

SELECT
"模块名",
sum("点击数量"),
sum("使用时长(单位：分钟)")
FROM
(
SELECT 
T.fun_name as "模块名",
T.event_code as "事件编码",
SUM(click_records) as "点击数量",
round(SUM(stay_time)/60000,0) as "使用时长(单位：分钟)"
FROM  
(SELECT m.* FROM default.daily_new_clientrpt_master m ) T   where  day  = today() GROUP BY "模块名" ,"事件编码") GROUP BY "模块名";
 

等价于细粒度sql+一个维度的图表统计：