Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Need to calculate FTE for a Physician how many patients assigned to him in a day.

Hi All,

I am trying to calculate FTE  ( Full time employee) for a Physician how many patients assigned to him in a day.

Need to calculate FTE: Over capacity or Under capacity Nation wide.


For Example:

Actual is 10 and assigned is 8 then we are under capacity

Actual is 10 and assigned is 12 then we are over capacity -2.

Under count and Over count.

Load vs capacity report.

It checks if there is physician can handle in week is 10, capacity is 10 of doing visitings.

Assigning of 15 patients to a physician is Load.

If physician can handle 12 in a week, capacity is 12 of doing visitings.

Assigning of 10 or 12 patients to a physician in a week is  Capacity.


Kindly suggest an Exact formula of FTE for comparing Load vs Capacity.


Thanks.

1 Reply
Specialist II
Specialist II

Do you have an example of what your table structure looks like?