I have a calendar for employees that assigns them to a "work period". Each work period is 12 hours long, and employees are typically assigned to 3 straight days of work periods.
The events on the calendar are created as all day events, lasting for the duration of their consecutive work periods (i.e. Employee A has an event assigned to them from 1-3 Jan, they have worked 3 work periods).
The current list view I have created using a calculated field shows all of of the employee's work periods in individual rows and without the ability to filter by date.
Example:
Employee | Start Date | End Date | Work Prds |
---|---|---|---|
A | 1 Jan | 3 Jan | 3 |
B | 4 Jan | 5 Jan | 2 |
A | 6 Jan | 8 Jan | 3 |
C | 9 Jan | 11 Jan | 3 |
I want to create a "summary" list view of this calendar that my manager can quickly see the total number of work periods that an employee is assigned during a month in order to fairly distribute work periods. I want to only see one row of Employee A with the total number of work periods assigned based on a date input from my manager so he can quickly filter between months.
Example:
Start Date Filter: 1 Jan
End Date Filter: 31 Jan
Employee | Work Prds |
---|---|
A | 6 |
B | 2 |
C | 3 |
And to make this difficult, I'm not terribly familiar with Designer, so if there is an out of the box web based solution, that would be amazing.
Sorry for the noob question!