案例陈述逻辑 [英] Case statement Logic
问题描述
我有一个ETL逻辑,其案例声明如下:
i have an ETL logic with a case statement like This :
CASE
WHEN ( AVG ( mydata 。 percentScore ))
< span style ="color:grey">< 0.98 那么
'Audit'跨度> <跨度>&NBSP;
CASE WHEN (AVG(mydata.percentScore)) < 0.98 THEN 'Audit'
WHEN
( CAST ( SUM ( CASE
WHEN mydata 。 questionAnswer
= '审核'
那么 1 ELSE 0 END )
AS float )/ 计数 (*))
< 0.08 那么
'Audit'
WHEN (CAST(SUM(CASE WHEN mydata.questionAnswer = 'Audit' THEN 1 ELSE 0 END) AS float)/Count(*)) < 0.08 THEN 'Audit'
<跨度>&NBSP; WHEN
( CAST ( SUM ( CASE
WHEN mydata 。 questionAnswer
= 'QC'
THEN 1 ELSE 0 END )
AS float ) / 计数 (*))
> 0.40 那么
'QC Lite' ELSE "QC"
END AS AssignReviewType
WHEN (CAST(SUM(CASE WHEN mydata.questionAnswer = 'QC' THEN 1 ELSE 0 END) AS float)/Count(*)) > 0.40 THEN 'QC Lite' ELSE 'QC' END AS AssignReviewType
FROM data mydata
FROM data mydata
现在我想更新这个逻辑 ''CASE WHEN(AVG(mydata.percentScore))< 0.98然后'审核''' 要成为 百分数低于98%,然后8%去审计,其余去QC
now i want to update this logic ''CASE WHEN (AVG(mydata.percentScore)) < 0.98 THEN 'Audit' '' to be percentscore is below 98%, then 8% go to Audit and the remaining go to QC
请问我怎么能重写这个。
please how can i rewrite this.
谢谢
推荐答案
不确定我们是否理解您的问题。
Not sure we understand your question.
这篇关于案例陈述逻辑的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!