Re: Question Regarding Calendar Setup for Caseworker Dash
I think I have an idea on how to proceed. I will create a single master calendar in the data model and handle the working vs. non-working in one or more fact tables that link to the master calendar.
However, I'm still trying to reconcile different granularity of time and I'm curious how I should proceed.
My working/non-working time is set on an 8hour workday. However, our case management system keeps a 24 hour rolling clock.
In the past when I would calculate these stats in excel I would take the days off away from the total. For example if an employee was absent for 3 full days (8 hours each day) and 1 half day. I would subtract 3.5 full days from the schedule.
Any idea what the best way is to work around the eight hour work day versus the 24 hour case clock? Thank you.