Forum Discussion
Solved
create shifts by agents with interference
Hello guys, i have call center log files i would like to divide agents into two shifts (morning , night ), Morning start from 8:00AM ends 4:00PM Night start from 1:00 PM ends 9:00PM , i understan...
Try something like this, as COLUMNS:
FirstCallTime = MINX(FILTER('Calls Log', 'Calls Log'[Call Date]=EARLIER('Calls Log'[Call Date]) && 'Calls Log'[Agent]=EARLIER('Calls Log'[Agent])),'Calls Log'[Call Time])Shift = IF('Calls Log'[FirstCallTime]<TIMEVALUE ( "1:00 PM" ),"Morning", "Night")
HI baqerbushajea ,
Try this column
Column =
IF (
Table15[Time] >= TIME ( 13, 0, 0 )
&& Table15[Time] <= TIME ( 22, 0, 0 ),
"Night",
IF (
Table15[Time] < TIME ( 13, 0, 0 )
&& Table15[Time] > TIME ( 4, 0, 0 ),
"Morning",
"??"
)
)
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
thank you
but still facing same issue,
the code will result somthing like this
what i need is when every the agent is in morning all his calls shift is morning
please help !!