Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 c...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

     

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hii Anonymous 

    Do you have any idea how to do the same in excel I want to calculate the idel time in excel

    Plz help 

    Thanks