我能够使用vba获得计数,通过循环遍历每个类别,然后循环遍历每个测试编号,然后计算完成的每个测试编号,但是对于每个主管来说几乎需要30秒(超过500个主管的时间太长了)。需要创建的示例报告01/20 Category 2:SPARTN_Livefeed1
Sheet ID Date Test Number Supervisor</e
(SELECT SUM(SYSDATE-supervisor_time_data.time_attending)*86400 FROM dual)/(SELECT supervisor.clients_attendingdual)/(SELECT supervisor.clients_waiting FROM dual) AS "TME",
supervisor.tme_accumulatedLEFT JOIN CORE.supervisor