用 union ALL拼接

前三年 SQL

union ALL

本年度各月的MTD sql

union all

本年度YTD

你这个，要么直接处理好你现在的数据，三年的数据，当年每月数据，累计数据

然后直接一个柱形图展示

不能标准没有一个图形可以展示。。。

年度和年度比较才有意义，本年度月的在一起比较才有意义，关键是你想要展示什么？年度累计值变化？本年度月度值变化？

用自定义图表。参考文档：https://help.fanruan.com/finebi/doc-view-1665.html?source=4

随意摘取一个以前的案例SQL（oracle数据库）：

WITH AA AS (

SELECT * FROM (

SELECT "班次日期",sum("工序原始出勤工时") AS "工序原始出勤工时",

SUM("工序实际出勤工时") AS "工序实际出勤工时",

sum("工序援入工时") AS "工序援入工时",

sum("工序援出工时") AS "工序援出工时",

sum("工序额定") AS "工序额定",

  (SUM("工序实际出勤工时")+sum("工序援入工时")-sum("工序援出工时")) AS "投入工时"

--(sum("工序额定"))/(SUM("工序实际出勤工时")+sum("工序援入工时")-sum("工序援出工时")) AS "工序效率" 

FROM (

SELECT 

SHIFTDATE AS "班次日期",

--WIPWORKSHOP AS "班次WIP车间 ",

ZWORKSHOPDESC AS "工序效率车间",

--FUNCTION_TEAM AS "职能组",

--SHIFT AS "班次 ",

OPERATION AS  "WIP工序",

--SECOND_ORDER AS "二阶管理维度",

--THRID_ORDER AS "三阶管理维度",

ATTENDANCEHOURS AS "工序原始出勤工时",

ACUTAL_ATTENDANCEHOURS AS "工序实际出勤工时",

SUPPORTIN_HOURS AS "工序援入工时",

SUPPORTOUT_HOURS AS "工序援出工时",

RATEDHOURS AS "工序额定",

ETL_DATE

FROM HZUSER.Atl_DataSummery_ProcessEfficiency_Detail

WHERE 

--ZWORKSHOPDESC IN ('W2_阴极前工序','W2_阳极前工序')

ZWORKSHOPDESC IN ('W2_铜箔印刷','W2_阳极前工序','W2_阴极凹版','W2_阴极前工序')

  AND ISCHECK='考核'

--AND TO_CHAR(SHIFTDATE,'YYYY-MM-DD')='2022-10-27'

)AA

GROUP BY "班次日期" ORDER BY "班次日期" DESC)AAA 

LEFT JOIN 

(SELECT DATA_DT,YEARMONTH AS "年月",ATL_YEARWK AS "年周" FROM HZUSER.ATL_DATE )BBB

ON AAA."班次日期"=BBB.DATA_DT

),

--四周

QQ AS ( SELECT * FROM (SELECT DISTINCT atl_yearwk FROM HZUSER.ATL_DATE 

WHERE data_dt<TRUNC(SYSDATE - 0)

ORDER BY atl_yearwk DESC)AA WHERE ROWNUM<=4

),

--2月

KK AS ( SELECT * FROM (SELECT DISTINCT YEARMONTH FROM HZUSER.ATL_DATE 

WHERE data_dt<TRUNC(SYSDATE - 0)

ORDER BY YEARMONTH DESC)AA WHERE ROWNUM<=2

),

--5天

BB AS (

SELECT CAST(TO_CHAR(班次日期,'yyyy-mm-dd') AS  nvarchar2(10)) AS 班次日期,工序实际出勤工时,工序援入工时,工序援出工时,投入工时,工序额定,ROUND(工序额定,4)/(投入工时) AS 效率 FROM AA

  WHERE 班次日期>=TRUNC(SYSDATE - 6)

AND  班次日期<=TRUNC(SYSDATE - 1)

),

--4周

CC AS (

SELECT 年周,SUM(工序实际出勤工时) AS 工序实际出勤工时,SUM(工序援入工时) AS 工序援入工时,SUM(工序援出工时) AS 工序援出工时,SUM(投入工时) AS 投入工时,SUM(工序额定) AS 工序额定,ROUND(SUM(工序额定),4)/SUM(投入工时) AS 效率 FROM AA

WHERE 年周  IN (SELECT atl_yearwk FROM QQ)

GROUP BY 年周

),

--2月

DD AS (

SELECT 年月,SUM(工序实际出勤工时) AS 工序实际出勤工时,SUM(工序援入工时) AS 工序援入工时,SUM(工序援出工时) AS 工序援出工时,SUM(投入工时) AS 投入工时,SUM(工序额定) AS 工序额定,ROUND(SUM(工序额定),4)/SUM(投入工时) AS 效率 FROM AA

WHERE 年月 IN (SELECT * FROM KK)

GROUP BY 年月

)

SELECT * FROM BB

UNION 

SELECT * FROM CC

UNION 

SELECT * FROM DD