Discussions

Ask a Question
Back to All

calculate overtime balance

Hi Forum,

i have a question regarding factorial, especially the overtime calculation.

in the system itself, employees have daily working times.
For example: 02.04.2025 - 7 worked hours / 8 planned hours / +1 hours overtime

Im trying to recreate these data in Power BI.

The Overtime itself, I can query from the overtime table: https://api.factorialhr.com/api/2025-04-01/resources/attendance/overtime_requests

But from where can I get the negative overtime?
I dont mean "overtime compensation" absences but just regularly shorter work time.
I should be able to somehow calcualte it by myself, using contract data to get the target working times and compare them with actuals.

But when I query
https://api.factorialhr.com/api/2025-04-01/resources/attendance/worked_times, the whole table is empty.
same for: https://api.factorialhr.com/api/2025-04-01/resources/attendance/estimated_times

Source:
https://apidoc.factorialhr.com/reference/


Thanks for any help
Kind regards,
Dominik