SELECT
	"T0"."C0" "时段",
	"T0"."C1" "IVR呼入量",
	"T0"."C2" "转人工申请量",
	"T0"."C3" "应答量",
	"T0"."C4" "C_20秒内应答量",
	"T0"."C5" "放弃量",
	"T0"."C6" "C_5秒内放弃量",
	"T0"."C7" "呼损率_",
	"T0"."C8" "接通率_",
	"T0"."C9" "服务水平_20秒__",
	"T0"."C10" "最大放弃时间_秒_",
	"T0"."C11" "平均放弃时间_秒_",
	"T0"."C12" "最大应答时间_秒_",
	"T0"."C13" "平均应答时间_秒_",
	"T0"."C14" "排队放弃量",
	"T0"."C15" "振铃放弃量",
	"T0"."C16" "留言量及挂断量",
	sum("T0"."C1") OVER () "总计_IVR呼入量_",
	sum("T0"."C2") OVER () "总计_转人工申请量_",
	sum("T0"."C3") OVER () "总计_应答量_",
	sum("T0"."C4") OVER () "总计_20秒内应答量_",
	sum("T0"."C5") OVER () "总计_放弃量_",
	sum("T0"."C6") OVER () "总计_5秒内放弃量_",
	"T0"."C17" "总计_呼损率__",
	"T0"."C18" "总计_接通率__",
	"T0"."C19" "c26",
	"T0"."C20" "c27",
	"T0"."C21" "c28",
	max("T0"."C12") OVER () "c29",
	"T0"."C22" "c30",
	sum("T0"."C14") OVER () "总计_排队放弃量_",
	sum("T0"."C15") OVER () "总计_振铃放弃量_",
	sum("T0"."C16") OVER () "总计_留言量及挂断量_"
FROM
	(
	SELECT
		"T0"."C0" "C0",
		"T0"."C1" "C1",
		"T0"."C2" "C2",
		"T0"."C3" "C3",
		"T0"."C4" "C4",
		"T0"."C5" "C5",
		"T0"."C6" "C6",
		"T0"."C7" "C7",
		"T0"."C8" "C8",
		"T0"."C9" "C9",
		"T0"."C10" "C10",
		"T0"."C11" "C11",
		"T0"."C12" "C12",
		"T0"."C13" "C13",
		"T0"."C14" "C14",
		"T0"."C15" "C15",
		"T0"."C16" "C16",
		1 - sum("T0"."C3") OVER ()/ NULLIF(sum("T0"."C2") OVER (),
		0) "C17",
		sum("T0"."C3") OVER ()/ NULLIF(sum("T0"."C2") OVER (),
		0) "C18",
		sum("T0"."C4") OVER ()/ NULLIF(sum("T0"."C2") OVER (),
		0) "C19",
		max("T0"."C17") OVER () "C20",
		sum("T0"."C18") OVER ()/ NULLIF(sum("T0"."C5") OVER (),
		0) "C21",
		sum("T0"."C19") OVER ()/ NULLIF(sum("T0"."C3") OVER (),
		0) "C22"
	FROM
		(
		SELECT
			"T_LI_RPT_CALLIN_95500"."TIME_KEY" "C0",
			sum("T_LI_RPT_CALLIN_95500"."IVR_ENTERED") "C1",
			sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM") "C2",
			sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED") "C3",
			sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED_20") "C4",
			sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_NUM") "C5",
			sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_IN_TR") "C6",
			1 - sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM"),
			0) "C7",
			sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM"),
			0) "C8",
			sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED_20")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ENTERED_NUM"),
			0) "C9",
			(max("T_LI_RPT_CALLIN_95500"."MAX_T_ABANDONED")+ decode(sum("T_LI_RPT_CALLIN_95500"."N_ABN_W2"), 0, 0, 30))+ decode(sum("T_LI_RPT_CALLIN_95500"."N_ABN_W3"), 0, 0, 30) "C10",
			sum("T_LI_RPT_CALLIN_95500"."T_ABANDONED_SUM")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_NUM"),
			0) "C11",
			(sum("T_LI_RPT_CALLIN_95500"."MAX_T_ANSWERED")+ decode(sum("T_LI_RPT_CALLIN_95500"."N_ANS_W2"), 0, 0, 30))+ decode(sum("T_LI_RPT_CALLIN_95500"."N_ANS_W3"), 0, 0, 30) "C12",
			sum("T_LI_RPT_CALLIN_95500"."T_ANSWERED_SUM")/ NULLIF(sum("T_LI_RPT_CALLIN_95500"."N_ANSWERED"),
			0) "C13",
			sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_QUEUE") "C14",
			sum("T_LI_RPT_CALLIN_95500"."N_ABANDONED_RING") "C15",
			sum("T_LI_RPT_CALLIN_95500"."ENTERED_ABANDONED_NUM") "C16",
			max("T_LI_RPT_CALLIN_95500"."MAX_T_ABANDONED") "C17",
			sum("T_LI_RPT_CALLIN_95500"."T_ABANDONED_SUM") "C18",
			sum("T_LI_RPT_CALLIN_95500"."T_ANSWERED_SUM") "C19"
		FROM
			"REPORT"."T_LI_RPT_CALLIN_95500" "T_LI_RPT_CALLIN_95500"
		WHERE
			T_LI_RPT_CALLIN_95500."TIME_DATE" =
			to_date('${P_START}','yyyy-MM-dd')
			
			${if(len(P_CS)==0,"","and T_LI_RPT_CALLIN_95500.CS_NAME in ('"+P_CS+"')")}
			${if(len(P_SUBSIDIARY)==0,"","and T_LI_RPT_CALLIN_95500.BRANCH_COMPANY_FLG in ('"+P_SUBSIDIARY+"')")}
		GROUP BY
			"T_LI_RPT_CALLIN_95500"."TIME_KEY") "T0") "T0"
ORDER BY "时段" NULLS LAST