Average daily active employees calculation
Howdy y'all. We use Quickbase for an HRIS. Within the HRIS, there's an employees table that contains fields for the hire date, termination date, and status. An example employee could have a hire da...
A question for you. How often do they want to see this report?
If it is infrequent, once a year.... I would not build this in Quickbase. I would export the HR data to Excel and massage it there to produce your answer.
If the answer is that it has to be in Quickbase.
- Create a Table [Daily Active Employees].
- Create a scheduled Pipeline that runs every night creating one new record in the table with the date, # of Active Employees and the # of Employees that left that day.
You can now Create a Summary Report on that table where you specify the date range. Use report variables to calculate your averages.
