Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ashaikh
Helper III
Helper III

Count of Agents Login

Hello All,

 

I have a table which says when we get a call and a table with Agent Login Time and Logout Time

CallTable :

    CallId | CallTime            |
    1      | 2019-04-01 09:00 AM |
    2      | 2019-04-01 09:30 AM |

AgentLoginLogout :

    Date       | AgentId | LoginTime          | LogoutTime          | AgentTeam |
    2019-04-01 | 1       | 2019-04-03 3:00 AM | 2019-04-03 10:00 AM | TeamA     |
2019-04-01 | 2 | 2019-04-03 9:15 AM | 2019-04-03 5:15 PM | TeamA |
2019-04-01 | 3 | 2019-04-03 9:15 AM | 2019-04-03 5:15 PM | TeamB |

So what I want to calculate is how many agents are logged in when each call came in. Final result will look like below

FinalResult :

    CallId | CallTime            | AgentsOnline
    1      | 2019-04-01 09:00 AM | 1
    2      | 2019-04-01 09:30 AM | 2

Thanks in Advance

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@ashaikh 

 

Try this calculated column

 

AgentsOnline =
COUNTROWS (
    FILTER (
        AgentLoginLogout,
        CallTable[CallTime] >= AgentLoginLogout[LoginTime]
            && CallTable[CallTime] <= AgentLoginLogout[LogoutTime]
    )
)

Regards
Zubair

Please try my custom visuals

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

@ashaikh 

 

Try this calculated column

 

AgentsOnline =
COUNTROWS (
    FILTER (
        AgentLoginLogout,
        CallTable[CallTime] >= AgentLoginLogout[LoginTime]
            && CallTable[CallTime] <= AgentLoginLogout[LogoutTime]
    )
)

Regards
Zubair

Please try my custom visuals

@Zubair_Muhammad I am trying  to use this query and I am just getting working on it...

 

And its taking long time to execute I guess. Is there any other way to do it.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.