
1. Re: Removing Duplicates for Productivity Calculations
Deepak Rai Aug 13, 2018 9:47 AM (in response to Kaitlyn Burns)
wRVU Dashboard.twbx 613.8 KB


2. Re: Removing Duplicates for Productivity Calculations
Kaitlyn Burns Aug 13, 2018 10:27 AM (in response to Deepak Rai)Hi, Deepak –
I tried this, but it doesn’t provide the correct numbers.
Example: For FY2018 Q1 Podiatric Surgery, the total RVUs = 5,319.50 and the total cFTE = 3.8; therefore, I should be showing RVU/cFTE = 1,399.87
The formulas you’ve provided are giving me a total for FY2018 Q1 Podiatric Surgery of 4.0
Kaitlyn

3. Re: Removing Duplicates for Productivity Calculations
Deepak Rai Aug 13, 2018 10:38 AM (in response to Kaitlyn Burns)Can you explain the logic about the ratio?

4. Re: Removing Duplicates for Productivity Calculations
Kaitlyn Burns Aug 13, 2018 1:06 PM (in response to Deepak Rai)RVUs per FTE is used by our team in order to review provider productivity. We can use this ratio along with others including RVUs per encounter and procedures per FTE. We look at these numbers further when we look at service line issues such as costs and staffing.

5. Re: Removing Duplicates for Productivity Calculations
Deepak Rai Aug 13, 2018 1:14 PM (in response to Kaitlyn Burns)That's Fine, But since your dataset is big, I am asking you How are you getting 1399.87. I Need to understand logic.

6. Re: Removing Duplicates for Productivity Calculations
Kaitlyn Burns Aug 14, 2018 7:48 AM (in response to Deepak Rai)I’ll use FY2018 Q1 Podiatric Surgery for an example.
Below, you can see that each provider has 3 rows of data (July, Aug, Sept). In Excel, I would total the wRVUs for the months (5,319.50) and then divide this total by the total cFTEs for the providers (3.75). This would give me the RVU/cFTE of 1,418.53 for this service line during this time period.
However, in Tableau, it’s dividing each wRVU row by each cFTE in that row. So, it’s counting each cFTE three times rather than once, giving inflated numbers.
What I am hoping to see if there’s a calculation that can take the total wRVUs for the time period (quarter) and divide it just by the total of the 1st cFTE per provider (below).
I’ve been reading/trying out different calculations but haven’t seemed to find anything that works.
Thanks again for your help!

image002.png 30.2 KB

image001.png 28.8 KB


7. Re: Removing Duplicates for Productivity Calculations
Deepak Rai Aug 14, 2018 8:54 PM (in response to Kaitlyn Burns)Hello Kaitlyn,
Here It Is:
You Need to Use This Calc To Get It and Since I used LOD, I added Filters to CONTEXT for LOD to Operate.
Thanks
Deepak
If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

wRVU Dashboard_v10.2.twbx 622.7 KB
