Supervisor - Tagesstatistik

AcdStatisticsPartB

(CACHE)

WHERE ( AcdGroupsID = $ACDGROUPSID )
AND
( dtGroupStart >= DATETIME( DATE( 'now', 'localtime', '+$STATISTICS_FROM_HOUR hour', '+$STATISTICS_FROM_MINUTE minute' ) ) )
AND
( dtGroupEnd IS NOT NULL );

Berechnung:

IFNULL( MAX( CASE
WHEN dtAgentConnect IS NOT NULL THEN STRFTIME( '%s', dtAgentConnect ) - STRFTIME( '%s', dtGroupStart )
WHEN dtGroupActionStart IS NOT NULL THEN STRFTIME( '%s', dtGroupActionStart ) - STRFTIME( '%s', dtGroupStart )
WHEN dtGroupEnd IS NOT NULL THEN STRFTIME( '%s', dtGroupEnd ) - STRFTIME( '%s', dtGroupStart )
ELSE 0
END
), 0 ) AS TodayWaitingTimeMax,

Anzeige:

TodayWaitingTimeMax

Berechnung:

IFNULL( SUM( CASE
WHEN dtAgentConnect IS NOT NULL THEN STRFTIME( '%s', dtAgentConnect ) - STRFTIME( '%s', dtGroupStart )
WHEN dtGroupActionStart IS NOT NULL THEN STRFTIME( '%s', dtGroupActionStart ) - STRFTIME( '%s', dtGroupStart )
WHEN dtGroupEnd IS NOT NULL THEN STRFTIME( '%s', dtGroupEnd ) - STRFTIME( '%s', dtGroupStart )
ELSE 0
END
), 0 ) AS TodayWaitingTime,

Anzeige:

#{item['TodayGroupCalls'] eq 0 ? 0 : item['TodayWaitingTime'] / item['TodayGroupCalls']}