topic Question Regarding Calendar Setup for Caseworker Dash in QlikView

Question Regarding Calendar Setup for Caseworker Dash

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I'm beginning the process of outlining a new dashboard for a group of caseworkers and I'm wondering the best way to setup my calendar(s).

I need to have some way to track each of my caseworker's time against their time off or non-working time so that I can measure case handling time and turnaround time more accurately.

Should I set up a separate calendar for each person or is there a simpler way that I'm not thinking of? Thank you in advance for any advice.

Best Regards,
Darren

Re: Question Regarding Calendar Setup for Caseworker Dash

adamdavi3s — Tue, 31 Jan 2017 08:17:41 GMT

Hi Darren,

Have a search on here for "Master Calendar" and "Canonical Dates" which should answer your question for you.

Adam

Re: Question Regarding Calendar Setup for Caseworker Dash

Anonymous — Thu, 02 Feb 2017 15:44:00 GMT

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.

Darren