This is a 365 solution:
=LET(
multiplier, SEQUENCE(7, , 1, 0),
out, MMULT(N(Attendance = "Absent"), multiplier),
scheduled, MMULT((Attendance <> "OFF") * (Attendance <> "PTO"), multiplier),
Analyze, LAMBDA(row,
LET(
absent, SUM(FILTER(out, LOB = row, 0)),
total, SUM(FILTER(scheduled, LOB = row, 0)),
absent / total
)
),
BYROW(UniqueLOB, Analyze)
)