cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jacmanda Frequent Visitor
Frequent Visitor

idle time call log

Good day!

 

I have a problem I hope the community could help me with.

 

We have a sales organization which uses a call platform. From this platform we get an table of alle the calls made.

With call_start, call_end and salesperson_id.

 

I want to calculate idletime between two calls, for each call. 

 

So if:

call A  started at 15/03/2019 08:15AM, and lasted 5 minutes --> call end 15/03/2019 08:20AM

call B started at 15/03/2019 08:25AM - then the idle time is 5 minutes. idletime test.jpg

 

In the call table there are over 50 sales reps, so it has to evaluete idle time for the sales rep in question. And not just for all calls. 

Furthermore it would be ideal to do this evaluation per day - so that we dont get 16H idletime from one day to another.

 

Thanks in advance to anyone who can point me in the right direction

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: idle time call log

Hi @jacmanda ,

 

You can use below calculated column formula to achieve your requirement:

Idle Time =
VAR prevEnd =
    CALCULATE (
        MAX ( Table[Call_end_date] ),
        FILTER (
            ALL ( Table ),
            [User_id] = EARLIER ( Table[User_id] )
                && [Call_time_date] < EARLIER ( Table[Call_time_date] )
        )
    )
RETURN
    DATEDIFF ( [Call_time_date], prevEnd, SECOND )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: idle time call log

Hi @jacmanda ,

 

You can use below calculated column formula to achieve your requirement:

Idle Time =
VAR prevEnd =
    CALCULATE (
        MAX ( Table[Call_end_date] ),
        FILTER (
            ALL ( Table ),
            [User_id] = EARLIER ( Table[User_id] )
                && [Call_time_date] < EARLIER ( Table[Call_time_date] )
        )
    )
RETURN
    DATEDIFF ( [Call_time_date], prevEnd, SECOND )

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

jacmanda Frequent Visitor
Frequent Visitor

Re: idle time call log

Thank you! Looks like it works like a charm 🙂

 

Only had to ad a (*-1) at the end, in order to get a positive value. 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 388 members 3,202 guests
Please welcome our newest community members: