Message-ID: <1757284775.75661.1711672323124.JavaMail.root@iZbp18oy7vkjyb4wkosfi9Z> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_75660_1717417664.1711672323124" ------=_Part_75660_1717417664.1711672323124 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html =E8=A1=A8=E8=BE=BE=E5=BC=8F=E8=AE=A1=E7=AE=97=E5=87=BD=E6=95=B0= =E4=B8=8E=E5=85=AC=E5=BC=8F

=E8=A1=A8=E8=BE=BE=E5=BC=8F=E8=AE=A1=E7=AE=97=E5=87=BD=E6=95=B0=E4= =B8=8E=E5=85=AC=E5=BC=8F

=E4=B8=8B=E8=BD=BDDemo=E6=8A=A5=E8=A1=A8=E5=92=8CExcel

=E4=B8=8B=E8=BD=BDDemo=E6=8A=A5=E8=A1=A8=EF=BC=9A  =E8=AE=A1=E7=AE=97=E5=87=BD=E6=95=B0= =E4=B8=8E=E5=85=AC=E5=BC=8Fdemo.zip =E8=AE=A1=E7=AE=97=E5=87=BD=E6=95=B0=E4= =B8=8E=E5=85=AC=E5=BC=8Fdemo.xlsx 
-----------------------------------------------------------------= ------------------------------------------------------
=E4=B8=8B=E8=BD=BD =E3=80=90=E8=A1=8C=E8=BD=AC= =E5=88=97=E4=B8=8E=E5=88=97=E8=BD=AC=E8=A1=8CDemo=E3=80=91: =E8=A1=8C=E8=BD=AC=E5=88=97=E4=B8=8E= =E5=88=97=E8=BD=AC=E8=A1=8CDemo.zip
=E4=B8=8B=E8=BD=BDExcel: =E8=A1=8C=E8=BD=AC=E5=88=97=E4=B8=8E=E5=88=97= =E8=BD=AC=E8=A1=8CDemo.xlsx 

=E5=BA=A6=E9=87=8F=E5=87=BD=E6=95=B0 =E8=A1=A8=E8=BE=BE=E5=BC=8F =E6=8F=8F=E8=BF=B0
=E4=B8=8A=E5=91=A8 lastWeek(=E5=BA=A6=E9=87=8F=E5=AD=97=E6=AE=B5,= =E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E6= =97=A5=E6=9C=9F=E4=B8=8A=E5=91=A8=E7=9A=84=E5=80=BC
=E4=B8=8A=E6=9C=88 lastMonth(=E5=BA=A6=E9=87=8F=E5=AD= =97=E6=AE=B5,=E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D= =AE=E8=A1=8C=E6=97=A5=E6=9C=9F=E4=B8=8A=E6=9C=88=E7=9A=84=E5=80=BC
=E5=90=8C=E6=9C=9F lastYear(=E5=BA=A6=E9=87=8F=E5=AD=97=E6=AE=B5,= =E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E6= =97=A5=E6=9C=9F=E5=8E=BB=E5=B9=B4=E7=9A=84=E5=80=BC
=E5=91=A8=E7=B4=AF=E8=AE=A1 wtd(=E5=BA=A6=E9=87=8F=E5=AD=97=E6= =AE=B5,=E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D= =AE=E8=A1=8C=E6=97=A5=E6=9C=9F=E5=91=A8=E7=B4=AF=E8=AE=A1=E5=80=BC
=E6=9C=88=E7=B4=AF=E8=AE=A1 mtd(=E5=BA=A6=E9=87=8F=E5=AD=97=E6=AE=B5,=E6=97= =A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E6= =97=A5=E6=9C=9F=E6=9C=88=E7=B4=AF=E8=AE=A1=E5=80=BC
=E4=B8=8A=E5=91=A8=E7=B4=AF=E8=AE= =A1 lastWtd(=E5=BA=A6=E9=87=8F=E5=AD= =97=E6=AE=B5,=E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D= =AE=E8=A1=8C=E6=97=A5=E6=9C=9F=E4=B8=8A=E5=91=A8=E7=B4=AF=E8=AE=A1=E5=80=BC=
=E4=B8=8A=E6=9C=88=E7=B4=AF=E8=AE=A1 lastMtd(=E5=BA=A6=E9=87=8F=E5=AD=97=E6=AE=B5,=E6= =97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E6= =97=A5=E6=9C=9F=E4=B8=8A=E6=9C=88=E7=B4=AF=E8=AE=A1=E5=80=BC
=E5=90=8C=E6=9C=9F=E6=9C=88=E7=B4=AF=E8=AE=A1 lastYearMtd(=E5=BA=A6=E9=87=8F=E5=AD=97=E6=AE=B5= ,=E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E6= =97=A5=E6=9C=9F=E5=8E=BB=E5=B9=B4=E7=9A=84=E6=9C=88=E7=B4=AF=E8=AE=A1=E5=80= =BC
=E5=B9=B4=E7=B4=AF=E8=AE=A1 ytd(=E5=BA=A6=E9=87=8F=E5=AD=97=E6=AE=B5,=E6=97= =A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E6= =97=A5=E6=9C=9F=E7=9A=84=E5=B9=B4=E7=B4=AF=E8=AE=A1=E5=80=BC
=E5=90=8C=E6=9C=9F=E5=B9=B4=E7=B4=AF=E8=AE=A1 lastYearYtd(=E5=BA=A6=E9=87=8F=E5=AD=97=E6=AE=B5= ,=E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E6= =97=A5=E6=9C=9F=E5=8E=BB=E5=B9=B4=E7=9A=84=E5=B9=B4=E7=B4=AF=E8=AE=A1=E5=80= =BC

=E4=BB=A5=E4=B8=8A=E5=BA=A6=E9=87=8F=E5=87=BD=E6=95=B0=E8=A1=A8=E8=BE=BE= =E5=BC=8F=E4=B8=AD=E5=9D=87=E6=94=AF=E6=8C=81=E7=AC=AC=E4=B8=89=E4=B8=AA=E5= =8F=AF=E9=80=89=E5=8F=82=E6=95=B0=EF=BC=9A=E6=9D=A1=E4=BB=B6=E5=88=97=EF=BC= =9B =E4=B8=8D=E8=AE=BE=E7=BD=AE=E7=AC=AC=E4=B8=89=E4=B8=AA=E5=8F=82=E6=95= =B0=EF=BC=8C=E8=87=AA=E5=8A=A8=E5=B0=86=E6=89=80=E6=9C=89=E7=BB=B4=E5=BA=A6= =E4=BD=9C=E4=B8=BA=E6=9D=A1=E4=BB=B6=E5=88=97

=E7=AC=AC=E4=B8=89=E4=B8=AA=E5=8F=82=E6=95=B0=E6=A0=BC=E5=BC=8F=EF=BC=9A= columnA|columnB|columnC

 

 

=E5=BA=A6=E9=87=8F=E5=87=BD=E6=95=B0 =E8=A1=A8=E8=BE=BE=E5=BC=8F =E6=8F=8F=E8=BF=B0
=E6=9C=88=E6=97=B6=E9=97=B4=E8=BF= =9B=E5=BA=A6 monthPassed(=E6=97=A5=E6=9C=9F=E5= =AD=97=E6=AE=B5) =E6=9C=AC=E6=9C=88=E5=B7=B2=E7=BB= =8F=E8=BF=87=E5=8E=BB=E4=BA=86=E7=99=BE=E5=88=86=E4=B9=8B=E5=A4=9A=E5=B0=91= =EF=BC=88=E8=87=AA=E7=84=B6=E6=97=A5=EF=BC=89
=E5=B9=B4=E6=97=B6=E9=97=B4=E8=BF= =9B=E5=BA=A6 yearPassed(=E6=97=A5=E6=9C=9F=E5= =AD=97=E6=AE=B5) =E6=9C=AC=E5=B9=B4=E5=B7=B2=E7=BB= =8F=E8=BF=87=E5=8E=BB=E4=BA=86=E7=99=BE=E5=88=86=E4=B9=8B=E5=A4=9A=E5=B0=91= =EF=BC=88=E8=87=AA=E7=84=B6=E6=97=A5=EF=BC=89

 

 

=E7=BB=B4=E5=BA=A6=E5=87=BD=E6=95=B0 =E8=A1=A8=E8=BE=BE=E5=BC=8F =E6=8F=8F=E8=BF=B0
=E5=BA=8F=E5=8F=B7  _id =E5=A2=9E=E5=8A=A0=E4=B8=80=E4=B8= =AA=E8=87=AA=E5=A2=9EID
=E6=97=B6=E9=97=B4=E6=9C=88 month(=E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E8=8E=B7=E5=BE=97=E6=9C=88=E4=BB=BD
=E6=97=B6=E9=97=B4=E5=B9=B4 year(=E6=97=A5=E6=9C=9F=E5=AD=97=E6=AE=B5) =E8=8E=B7=E5=BE=97=E5=B9=B4=E4=BB=BD
=E6=97=B6=E9=97=B4=E6=97=A5=E5=91= =A8 week(=E6=97=A5=E6=9C=9F=E5=AD=97= =E6=AE=B5) =E8=8E=B7=E5=BE=97=E6=98=9F=E6=9C= =9F=EF=BC=8C=E4=BE=8B=E5=A6=82=EF=BC=9A=E5=91=A8=E4=B8=80=EF=BC=8C=E5=91=A8= =E4=BA=8C
=E6=97=B6=E9=97=B4=E5=B9=B4=E5=91= =A8 weekOfYear(=E6=97=A5=E6=9C=9F=E5= =AD=97=E6=AE=B5,=E6=A0=BC=E5=BC=8F,=E5=81=8F=E7=A7=BB=E5=A4=A9=E6=95=B0)

=E8=8E=B7=E5=BE=97=E5=91=A8=E6= =95=B0=EF=BC=8C=E4=BE=8B=E5=A6=82=EF=BC=9A=E7=AC=AC10=E5=91=A8
=E6=97=A5= =E6=9C=9F=E6=A0=BC=E5=BC=8F=EF=BC=8C=E4=BE=8B=E5=A6=82=EF=BC=9A
%d=E5=91= =A8=EF=BC=9A35=E5=91=A8
=E7=AC=AC%d=E5=91=A8=EF=BC=9A =E7=AC=AC35=E5=91= =A8 
W%d=EF=BC=9A W35 

=E5=81=8F=E7=A7=BB=E5=A4=A9=E6=95= =B0=EF=BC=9A=E5=91=A8=E7=9A=84=E5=85=B6=E5=AE=9E=E6=98=9F=E6=9C=9F=EF=BC=8C= =E6=AF=94=E5=A6=82=E4=BB=8E=E5=91=A8=E5=85=AD=E5=BC=80=E5=A7=8B=E8=AE=A1=E7= =AE=97=EF=BC=8C=E5=81=8F=E7=A7=BB=E4=B8=BA=EF=BC=9A+3 day

=E8=BD=AC=E6=88=90=E6=97=A5=E6=9C= =9F parseDate(=E5=AD=97=E6=AE=B5=E5=90= =8D,yyyyMMdd)

=E5=B0=86=E5=AD=97=E7=AC=A6=E4= =B8=B2=E6=88=96=E6=95=B0=E5=AD=97=E6=A0=B9=E6=8D=AE=E6=8C=87=E5=AE=9A=E7=9A= =84=E6=A0=BC=E5=BC=8F=E8=BD=AC=E6=88=90=E6=97=A5=E6=9C=9F
yyyy: 4=E4=BD= =8D=E6=95=B0=E5=AD=97=E5=B9=B4
MM: 2=E4=BD=8D=E6=95=B0=E5=AD=97=E6=9C=88=
mm: 1=E4=BD=8D=E6=95=B0=E5=AD=97=E6=9C=88
dd: 2=E4=BD=8D=E6=95=B0=E5= =AD=97=E6=97=A5
d: 1=E4=BD=8D=E6=95=B0=E5=AD=97=E6=97=A5 
=E4=BE= =8B=E5=A6=82=EF=BC=9A
20160516 : yyyyMMdd  
2016/05/16: yyy= y/MM/16 

=E8=A1=8C=E8=BD=AC=E5=88=97 rowToColumn(=E8=A1=8C=E5=AD=97=E6= =AE=B5=E5=90=8D, =E8=A1=8C=E5=80=BC, =E5=88=97=E5=AD=97=E6=AE=B5=E5=90=8D)<= /td> =E4=BE=8B=E5=A6=82=EF=BC=8C=E4=BB= =A5=E4=B8=8B2=E4=B8=AA=E8=A1=A8=E8=BE=BE=E5=BC=8F=E5=8F=AF=E4=BB=A5=E5=B0= =86=E3=80=90=E6=9C=AC=E6=9C=9F=E5=90=8C=E6=9C=9F=E3=80=91=E4=B8=AD=E7=9A=84= 2=E4=B8=AA=E5=80=BC=E8=BD=AC=E6=88=90=E5=88=97
1.=E5=B0=86=E5=AD=97=E6= =AE=B5=E3=80=90=E6=9C=AC=E6=9C=9F=E5=90=8C=E6=9C=9F=E3=80=91=E4=B8=AD=E7=9A= =84=E8=A1=8C=E5=80=BC=E2=80=9C=E6=9C=AC=E6=9C=9F=E2=80=9D=E4=B8=8E=E9=9B=B6= =E5=94=AE=E9=87=91=E9=A2=9D=E8=BD=AC=E6=88=90=E5=BD=93=E5=89=8D=E5=AD=97=E6= =AE=B5=E7=9A=84=E5=80=BC
rowToColumn(=E6=9C=AC=E6=9C=9F=E5=90=8C=E6=9C= =9F, "=E6=9C=AC=E6=9C=9F", =E9=9B=B6=E5=94=AE=E9=87=91=E9=A2=9D) 
<= span>2.=E5=B0=86=E5=AD=97=E6=AE=B5=E3=80=90=E6=9C=AC=E6=9C=9F=E5=90=8C=E6= =9C=9F=E3=80=91=E4=B8=AD=E7=9A=84=E8=A1=8C=E5=80=BC=E2=80=9C=E5=90=8C=E6=9C= =9F=E2=80=9D=E4=B8=8E=E9=9B=B6=E5=94=AE=E9=87=91=E9=A2=9D=E8=BD=AC=E6=88=90= =E5=BD=93=E5=89=8D=E5=AD=97=E6=AE=B5=E7=9A=84=E5=80=BC
rowT= oColumn(=E6=9C=AC=E6=9C=9F=E5=90=8C=E6=9C=9F, "=E5=90=8C=E6=9C=9F", =E9=9B= =B6=E5=94=AE=E9=87=91=E9=A2=9D)  
=E5=88=97=E8=BD=AC=E8=A1=8C columnToRow(=E8=A1=8C=E5=80=BCA:= =E6=BA=90=E5=AD=97=E6=AE=B5A1#=E7=9B=AE=E6=A0=87=E5=AD=97=E6=AE=B5A1|=E6=BA= =90=E5=AD=97=E6=AE=B5B1#=E7=9B=AE=E6=A0=87=E5=AD=97=E6=AE=B5B1) =E4=BE=8B=E5=A6=82=EF=BC=9A<= /span>

1. =E5=B0=86=E5=A4=9A=E4=B8=AA=E6=8C=87=E6=A0=87=E5=88=97= =E8=BD=AC=E6=88=90=E3=80=90KPI=E9=A1=B9=E3=80=91=E4=B8=AD=E7=9A=84=E8=A1=8C=
columnToRow(
=E9=9B=B6=E5=94=AE=E9=87=91=E9=A2=9D:=E6=9C=AC=E6=9C= =9F=E9=87=91=E9=A2=9D#=E6=9C=AC=E6=9C=9F=E5=80=BC|=E5=90=8C=E6=9C=9F=E9=87= =91=E9=A2=9D#=E5=90=8C=E6=9C=9F=E5=80=BC,
=E9=9B=B6=E5=94=AE=E6=80=BB= =E6=95=B0=E9=87=8F:=E6=9C=AC=E6=9C=9F=E6=95=B0=E9=87=8F#=E6=9C=AC=E6=9C=9F= =E5=80=BC|=E5=90=8C=E6=9C=9F=E6=95=B0=E9=87=8F#=E5=90=8C=E6=9C=9F=E5=80=BC<= br>)

=E5=88=86=E7=BB=84=E5=90=88=E8=AE= =A1 groupSum(=E6=8C=87=E6=A0=87=E5=AD= =97=E6=AE=B5, =E5=88=86=E7=BB=84=E5=AD=97=E6=AE=B5A|=E5=88=86=E7=BB=84=E5= =AD=97=E6=AE=B5B)

=E4=BE=8B=E5=A6=82=EF=BC=9A

=

1.=E7=BB=9F=E8=AE=A1=E5=90=84=E9=83=A8=E9=97=A8=E4=BA=BA=E6=95=B0
gro= upSum(=E5=9C=A8=E8=81=8C=E7=8A=B6=E6=80=81=E5=BA=A6=E9=87=8F,=E9=83=A8=E9= =97=A8=E7=BB=B4=E5=BA=A6)

2. =E6=8C=89=E5=A4=A7=E5=8C=BA=E5=92= =8C=E6=9C=AC=E6=9C=9F=E6=9D=A5=E5=90=88=E8=AE=A1
groupSum(=E9=9B=B6=E5= =94=AE=E9=87=91=E9=A2=9D,=E5=A4=A7=E5=8C=BA|=E6=9C=AC=E6=9C=9F=E5=90=8C=E6= =9C=9F) where =E6=9C=AC=E6=9C=9F=E5=90=8C=E6=9C=9F=3D'=E6=9C=AC=E6=9C=9F'&n= bsp;

=E8=87=AA=E5=AE=9A=E4=B9=89 =E5=9C=A8=E8=BF=9B=E8=A1=8C=E5=91= =A8=E6=88=96=E6=9C=88=E7=9A=84=E6=B1=87=E6=80=BB=E6=97=B6=EF=BC=8C
=E6=80=BB=E5=B7=A5=E4=BD=8D=E6=95=B0=E6=88=96=E6=9C=88=E5=BA=A6=E7=9B=AE= =E6=A0=87=E8=BF=99=E6=A0=B7=E7=9A=84=E6=8C=87=E6=A0=87=E4=B8=8D=E5=BA=94=E8= =AF=A5=E8=A2=AB=E6=B1=87=E6=80=BB=EF=BC=8C
=E8=80=8C=E6=98=AF=E6=9C=80= =E5=90=8E=E4=B8=80=E5=A4=A9=E7=9A=84=E5=80=BC
=20
(=20
select =E6=80=BB=E5=B7=A5=E4=BD=8D=E6=95=B0 from (
SELECT *=20
FROM =E5=B7=A5=E4=BD=8D=E5=87=BA=E7=A7=9F=20
GROUP BY =E5=91=A8,=E6=97=A5=E6=9C=9F=E7=B1=BB=E5=88=AB,=E7=9C=81=E4=BB=BD,=
=E5=9C=BA=E5=8C=BA
HAVING MAX(=E6=97=A5=E6=9C=9F)
) t2 where=20
t2.=E6=97=A5=E6=9C=9F=3D=E5=B7=A5=E4=BD=8D=E5=87=BA=E7=A7=9F.=E6=97=A5=E6=
=9C=9F=20
and t2.=E7=9C=81=E4=BB=BD=3D=E5=B7=A5=E4=BD=8D=E5=87=BA=E7=A7=9F.=E7=9C=81=
=E4=BB=BD=20
and t2.=E6=97=A5=E6=9C=9F=E7=B1=BB=E5=88=AB=3D=E5=B7=A5=E4=BD=8D=E5=87=BA=
=E7=A7=9F.=E6=97=A5=E6=9C=9F=E7=B1=BB=E5=88=AB=20
and t2.=E5=91=A8=3D=E5=B7=A5=E4=BD=8D=E5=87=BA=E7=A7=9F.=E5=91=A8 and t2.=
=E5=9C=BA=E5=8C=BA=3D=E5=B7=A5=E4=BD=8D=E5=87=BA=E7=A7=9F.=E5=9C=BA=E5=8C=
=BA
)
=20
=E8=BF=90=E7=AE=97=E5=87=BD=E6=95=B0 =E5=85=AC=E5= =BC=8F =E6=8F=8F=E8= =BF=B0
=E8=AE=A1=E7=AE=97=E5=8D=A0=E6=AF=94 {=E5=BA=A6=E9=87=8FA}/total({=E5=BA=A6=E9=87=8FA= }) =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E5= =BA=A6=E9=87=8FA=E5=8D=A0=E5=90=88=E8=AE=A1=E7=9A=84=E7=99=BE=E5=88=86=E6= =AF=94
=E8=AE=A1=E7=AE=97=E5=AE=8C=E6=88=90=E7=8E=87 {=E5=BA=A6=E9=87=8FA}/{=E5=BA=A6=E9=87=8FB} =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E5= =BA=A6=E9=87=8FA=E5=8D=A0=E5=BA=A6=E9=87=8FB=E7=9A=84=E6=AF=94=E4=BE=8B
=E8=AE=A1=E7=AE=97=E5=90=8C=E6=AF=94=E6=88=96=E7= =8E=AF=E6=AF=94 ({=E5=BA=A6=E9=87=8FA}-{=E5=8E=BB=E5=B9=B4=E5=BA= =A6=E9=87=8FA})/{=E5=8E=BB=E5=B9=B4=E5=BA=A6=E9=87=8FA} =E5=AF=B9=E5=BA=94=E6=95=B0=E6=8D=AE=E8=A1=8C=E5= =BA=A6=E9=87=8FA=E8=BE=83=E4=B8=8A=E6=9C=9F=E5=80=BC=E7=9A=84=E5=A2=9E=E9= =95=BF=E6=AF=94=E7=8E=87
=E5=8E=BB=E9=87=8D=E8=AE=A1=E6=95= =B0

countDistinct({=E7=BB=B4= =E5=BA=A6A=E5=8E=BB=E9=87=8D},=E5=BA=A6=E9=87=8FB=E8=AE= =A1=E6=95=B0=3D1)

=E4=BE=8B=E5=A6=82=EF=BC=9A
= countDistinct({=E5=BA=97=E9=93=BA=E6=A1=A3=E6=A1=88=E7=BC=96=E5=8F=B7= },=E9=94=80=E5=94=AE=E7=BD=91=E7=82=B9=3D1)

 =E5=AF=B9=E7=BB=B4=E5=BA=A6=E3=80=8C=E5=BA=97=E9=93=BA=E6=A1=A3=E6= =A1=88=E7=BC=96=E3=80=8D=E8=BF=9B=E8=A1=8C=E5=8E=BB=E9=87=8D=E8=AE=A1=E6=95= =B0=EF=BC=8C=E4=BD=86=E6=98=AF=E5=8F=AA=E6=9C=89=E3=80=8C=E9=94=80=E5= =94=AE=E7=BD=91=E7=82=B9=3D1=E3=80=8D=E7=9A=84=E8=AE=B0=E5=BD=95=E6=89=8D= =E5=8F=82=E4=B8=8E=E8=AE=A1=E6=95=B0

=E7=A4=BA=E4=BE=8B=EF=BC=9A=E8=AE=A1=E7=AE=97=E4=B8=8A= =E6=9C=88=E6=B1=87=E6=80=BB=E6=95=B0=E9=87=8F

select =E6=9C=88=E4=BB=BD,sum(=E6=95=B0=E9=87=8F) as =E6=95=B0=E9=87=8F = ,
( select sum(=E6=95=B0=E9=87=8F) from workbook1 t2 where t2.=E6=9C=88= =E4=BB=BD||'-01'=3Ddate(t1.=E6=9C=88=E4=BB=BD||'-01','-1 month') ) as =E4= =B8=8A=E6=9C=88=E6=95=B0=E9=87=8F
from workbook1 t1 group by =E6=9C=88= =E4=BB=BD

=E7=A4=BA=E4=BE=8B=EF=BC=9A=E8=AE=A1=E7=AE=97=E8=BF=87= =E5=8E=BB=E7=AC=AC1=E5=91=A8=E6=94=B6=E5=85=A5

(select sum(=E7=BA=AF=E6=94=B6=E5=85=A5) from =E6=B5=8B=E8=AF=95=E6=95= =B0=E6=8D=AE A where A.=E7=9C=81=E4=BB=BD=3D=E6=B5=8B=E8=AF=95=E6=95=B0=E6= =8D=AE.=E7=9C=81=E4=BB=BD and A.=E5=91=A8=3Dprintf('%d=E5=91=A8', case when= cast(strftime('%j', =E6=B5=8B=E8=AF=95=E6=95=B0=E6=8D=AE.=E6=97=A5=E6=9C= =9F) as int) > 300 and cast(strftime('%W', date(=E6=B5=8B=E8=AF=95=E6=95= =B0=E6=8D=AE.=E6=97=A5=E6=9C=9F,'+2 day', 'localtime')) as int) < 2 then= '53' else strftime('%W', date(=E6=B5=8B=E8=AF=95=E6=95=B0=E6=8D=AE.=E6=97= =A5=E6=9C=9F,'+2 day', 'localtime')) end -1 ) )

=EF=BC=88=E6=B3=A8=EF=BC=9A=E6=9C=AC=E4=BE=8B=E4=B8=AD=E7=9A=84=E5=91=A8= =E8=AE=A1=E7=AE=97=E6=98=AF=E6=8C=89=E6=9C=AC=E5=91=A8=E5=85=AD=E8=87=B3=E4= =B8=8B=E5=91=A8=E4=BA=94=E7=AE=97=E4=B8=80=E5=91=A8=EF=BC=89

 

------=_Part_75660_1717417664.1711672323124--