Track Active Employees by Day
I have a table which lists employees and a formula field which determines if they are currently active based on their start and end date. Any suggestions on how I could generate a table or report that...
Forum Discussion
Do you just want a report of the total # of unique employees in a given year? or do you need to see the rate that they built up at?
If you just want a count of the Unique employees, then just make a summary report of that history table and group by employee. There will be a count at the bottom of the report.
if you want to see a cumulative "waterfall" chart, that is possible too.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If you just want a count of the Unique employees, then just make a summary report of that history table and group by employee. There will be a count at the bottom of the report.
if you want to see a cumulative "waterfall" chart, that is possible too.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank you for the quick reply. I'm looking for total # of unique employees in a given year. The history table doesn't have employee names. It just has 1 record per day with the # of active employees.
------------------------------
Mary Gaughan
------------------------------
------------------------------
Mary Gaughan
------------------------------
- Oh, right, you are.
I think we can just make a report off the employees table. We probably will need tow reports, one for the current year and one for the last year. The reason for that is that no doubt on January 1 someone is going to ask the question about how many active employees we had last year.
I think it would be useful to create a field called [first day of the current year] with the formula of FirstDayofYear(Today()) and similarly [last day of the current year] with the formula of LastDayofYear(Today())
The the report filters would be off the employees table for
[start date] < [last day of the current year]
and
indented
ANY
[end date] is equal to blank
[end date] > [first day of the current year]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
