Script to set analysis

Alarkis — Sat, 16 Nov 2024 04:14:52 GMT

hello how can i create something like this with set analysis

select count(1), avg(Total_Time) avergae,
    sum( case when Total_Time <= :T Then 1 Else 0 End ) Achieved,
    sum( case when Total_Time <= :T Then 1 Else 0 End ) / Count(1) * 100 Perc_Acheived
From
(
SELECT application_no, SUM (work_time) total_time
    FROM FN_WFLOG_MV
   WHERE
   (application_no, applicant_no) IN
                 (SELECT application_no, applicant_no
                    FROM FN_WFLOG_MV
                   WHERE     WF_TASK_NAME = 'Approval'
                         AND TO_CHAR (ACTION_DATE, 'YYYYQ') = :Q
                         AND USERID IS NOT NULL
                         AND TO_WF_TASK_NAME = 'Task'
                         AND ACTION_NAME = 'ppp')
        AND TO_CHAR (ACTION_DATE, 'YYYYQ') = :Q
        AND DEPT_NAME = 'ttt'
        AND WF_TASK_NAME = 'Approval'
GROUP BY application_no
)

Re: Script to set analysis

Anil_Babu_Samineni — Fri, 25 Dec 2020 18:45:50 GMT

@Alarkis Hello, This page is so calm from long time. Would you like to come back and check this. Please access your answer after you palced the resolution or workaround on this?

topic Re: Script to set analysis in App Development

Script to set analysis

Re: Script to set analysis