Forum Discussion

NCW's avatar
NCW
Frequent Visitor
3 years ago
Solved

Get Duration from Logged In and Logged Out data per User

I am looking to find the total time users are logged into our system. The way the data is exported currently does not show how long they were logged in. I don't know the best way to do this within Po...
  • amitchandak's avatar
    amitchandak
    3 years ago

    NCW ,

    a new column = if([Action] = "RemoteLoggedIn",

    datediff( [Date], Minx(filter(Table, [user Name] = earlier([User Name]) && [Action] ="RemoteLoggedOut" && [Date] > Earlier([Date]) ) ,[Date]), Minute) , Blank())

amitchandak's avatar
amitchandak
Super User
3 years ago

NCW ,

a new column = if([Action] = "RemoteLoggedIn",

datediff( [Date], Minx(filter(Table, [user Name] = earlier([User Name]) && [Action] ="RemoteLoggedOut" && [Date] > Earlier([Date]) ) ,[Date]), Minute) , Blank())

  • NCW's avatar
    NCW
    Frequent Visitor
    3 years ago

    This works great. Thanks!