Agent State Duration
This measure category contains measures built from FACT_AGENT_STATE_DURATION and existing measures of this category.
info
Main Focus is on measuring the duration for the different agent states and activities during their login sessions.
Measure name = DAX formulas and expressions
Active Time (hh:mm:ss) = Format [Active Time (s)] in (hh:mm:ss)
Active Time (mm:ss) = Format [Active Time (s)] in (mm:ss)
Active Time (s) = SUM(FACT_AGENT_STATE_DURATION[ActiveTime])
Available for Media Time (hh:mm:ss) = Format [Available for Media Time (s)] in (hh:mm:ss)
Available for Media Time (mm:ss) = Format [Available for Media Time (s)] in (mm:ss)
Available for Media Time (s) = SUM(FACT_AGENT_STATE_DURATION[AvailableInMRDTime])
Available Time (hh:mm:ss) = Format [Available Time (s)] in (hh:mm:ss)
Available Time (mm:ss) = Format [Available Time (s)] in (mm:ss)
Available Time (s) = SUM(FACT_AGENT_STATE_DURATION[AvailTime])
Avg Available for Media Heads = DIVIDE([Available for Media Time (s)] , 900 * COUNT('TIME'[Interval Start Time]))
Avg Available Heads = DIVIDE([Available Time (s)] , 900 * COUNT('TIME'[Interval Start Time]))
Avg Productive Heads = DIVIDE([Productive Time (s)] , 900 * COUNT('TIME'[Interval Start Time]))
Avg Ready Heads = DIVIDE([Ready Time (s)] , 900 * COUNT('TIME'[Interval Start Time]))
First Login stamp = MIN(FACT_AGENT_STATE_DURATION[FirstLoginDateTime])
Last Logout stamp = MAX(FACT_AGENT_STATE_DURATION[LastLogoutDateTime])
Logged Agent Count = DISTINCTCOUNTNOBLANK(FACT_AGENT_STATE_DURATION[AgentID])
Login Time (hh:mm:ss) = Format [Login Time (s)] in (hh:mm:ss)
Login Time (mm:ss) = Format [Login Time (s)] in (mm:ss)
Login Time (s) = SUM(FACT_AGENT_STATE_DURATION[LoginTime])
Not Ready (%) = [Not Ready Time (s)] / [Login Time (s)]
Not Ready Time (hh:mm:ss) = Format [Not Ready Time (s)] in (hh:mm:ss)
Not Ready Time (mm:ss) = Format [Not Ready Time (s)] in (mm:ss)
Not Ready Time (s) = SUM(FACT_AGENT_STATE_DURATION[NotReadyTime])
NRT Non-Productive (hh:mm:ss) = Format [NRT Non-Productive (s)] in (hh:mm:ss)
NRT Non-Productive (mm:ss) = Format [NRT Non-Productive (s)] in (mm:ss)
NRT Non-Productive (s) = [Not Ready Time (s)] - [NRT Productive (s)]
NRT Productive (hh:mm:ss) = Format [NRT Productive (s)] in (hh:mm:ss)
NRT Productive (mm:ss) = Format [NRT Productive (s)] in (mm:ss)
NRT Productive (s) = SUM(FACT_AGENT_STATE_DURATION[NotReadyProductiveTime])
Occupancy (%) = [Active Time (s)] / [Ready Time (s)]
Productive Time (hh:mm:ss) = Format [Productive Time (s)] in (hh:mm:ss)
Productive Time (mm:ss) = Format [Productive Time (s)] in (mm:ss)
Productive Time (s) = [Ready Time (s)] + [NRT Productive (s)]
Productivity (%) = [Productive Time (s)] / [Login Time (s)]
Ready (%) = [Ready Time (s)] / [Login Time (s)]
Ready Time (h) = [Ready Time (s)] / 3600
Ready Time (hh:mm:ss) = Format [Ready Time (s)] in (hh:mm:ss)
Ready Time (mm:ss) = Format [Ready Time (s)] in (mm:ss)
Ready Time (s) = SUM(FACT_AGENT_STATE_DURATION[ReadyTime])
Total Logged FTE (8 h per day) = [Login Time (s)] / (3600 * 8)
Total Logged FTE (8,4 h per day) = [Login Time (s)] / (3600 * 8.4)
Total Logged FTE (8,5 h per day) = [Login Time (s)] / (3600 * 8.5)