RGN ->区域名称,需要对每个区域进行统计的->事件,用于区域的->过滤器。因此,在NPR新闻中,我有汽车牌照的活动,我需要计算每一个地区的汽车牌照,并将其分成一周的7天。我的解决办法如下:COUNT(CASE WHEN DATEPART(dw,b.TM) = 1 THEN 1 ELSE null END) as MON,COUNT(CASE WHEN DATEPART(dw,b.TM) = 2 THEN 1 ELSE null END) as TUE,
COUNT(C
FROM HSDATA4.DWRECAP (SELECT DW.DWINVNFROM HSDATA4.DWRECAP DW
INNER JOIN HSDATA4.FXVNDCP FX ON DW.DWVNDN = FX.FXVNDNWHERE DW.DWRTPE = 1 AND DW.DWDTEI BETWEEN 20180904 AN