Tech productivity analysis

Hi Soparklion ,

" I want to identify which of my technicians are working at what time"

First, I created two columns:

date = FORMAT([Working time], "mm/dd/yyyy")
period = 
VAR x= FORMAT([Working time],"HH:mm:ss")
VAR y= FORMAT([Off time], "HH:mm:ss")
RETURN
COMBINEVALUES("-", x, y)

Then, I created a measure:

Measure 2 = 
IF(
    HASONEFILTER(Sheet2[ Technician ID]),
    VAR x = COUNT(Sheet2[ Technician ID])
    RETURN
    IF(
        x <> 0,
        "T"
    ),
    CALCULATE(
        COUNT(Sheet2[ Technician ID]),
        ALLEXCEPT(
            Sheet2,
            Sheet2[date], Sheet2[period]
        )
    )
)

Then, I got this Matrix:

(used table: sheet2)

"the largest number of machines that they operated over each hour during the day"

First, I created one column:

date = FORMAT([Working time], "mm/dd/yyyy")

Then, I created one measure:

Largest number = 
VAR x =
DATEDIFF(
    MAX(Sheet1[Machine start time]),
    MAX(Sheet1[machine finish time]),
    HOUR
)
RETURN
CALCULATE(
    COUNT(Sheet1[Job number]),
    FILTER(
        Sheet1,
        x >= 1
    )
)
    

(used table: sheet1)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.