Summary of working time for each user for all workingstations

[fitcrates]

Hello.

What I want to achieve with the check in time app is to have total working time on each facility for each user during given day or just today.

I want a new view where I will see total time spend on each facility for each user. For example user checked in few times for some stations in a given facility, so I want to see total time for this user in this facility. 

Then I want it to generate file or other form of report at particular time. 

Below is the data being updated by the app in terms of ID, time, etc. as well as layout of the app to give you better idead how it works. 

How do I go about this?

[yasarcan]

hi

New column (type duration) (or virtual column)

Formula: 

SUM(
SELECT(
Workstation Activity[Checkout] - Workstation Activity[Checkin],
[User] = USEREMAIL()
)
)

Would you try?

[fitcrates]

Hi, 

I actually tried before I red your message. What worked for me was: 

SUM(
SELECT(
Workstation Activity[TimeDuration],
AND(
[User] = [_THISROW].[User],
[Workstation].[Facility] = [_THISROW].[Workstation].[Facility],
[Date] = [_THISROW].[Date]
)
)
)

Summarises correctly. Now I need to put it into a table for each user. Row: user. Column: facility working time

And then generate a report or a file. Not sure how to do either yet. 

[yasarcan]

New column (type duration) (or virtual column)

[fitcrates]

Since I got summary time correctly, now I need to create a view where I can present it like on the attached screenshot. FIrst choose date, then it opens detailed veiw of data colletcted that day: 

How can I do it?

[fitcrates]

I did it like this actually: 

Now need o generate reports 🙂 

[fitcrates]

Actually I would like to filter the output, because it shows all workstations and displaying just facility name. I would like to display only unique facility. THe time is a summary. So I am experimenting with something like: 

ISBLANK(
FILTER(
"Workstation Activity",
AND(
[Workstation] = [_THISROW].[Workstation Name],
[Workstation Name] <> [_THISROW].[Workstation Name]
)
)
)

But it does not work. Can't figure it out.