Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

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