I’m trying to solve a problem and I’m not sure how to best approach it.
I have a few KPIs based on timesheet data such as a billable/non-billable ratio, which can be sliced down by departments, teams, individual people, etc. and by different time frames.
The challenge is this: executives are interested in knowing company-wide KPIs taking into consideration hours worked by employees that do NOT log their time in timesheets, by assuming a fixed number of hours by week. These employees can be identified at a high-level based on their department.
Having them starting to fill timesheets is not an option
I assume it might be a mix of liquid logic, derived tables and creative joins between my employees list table and the timesheet data table. But I’m not sure where to start.
Any creative ideas?