7 Replies Latest reply on Aug 14, 2018 8:54 PM by Deepak Rai

# Removing Duplicates for Productivity Calculations

Hello! -

I'm hoping there's a possible solutions to my issue. I am working on creating a provider productivity dashboard to show RVUs per clinical FTE broken down by specialty by quarter.

My initial calculation: wRVUs/cFTE - This was giving me an inflated number based on calculations I had conducted previously in Excel.

When looking at the full data, I found that for each quarter, each provider had 3 rows of data (i.e. July, August, September), and the calculation was counting their clinical FTE three times rather than once.

Is there a calculation I can enter that will count all of the RVUs for all of the providers but will only count their clinical FTE once?

Thank you!

• ###### 1. Re: Removing Duplicates for Productivity Calculations

Hi Kaitlyn,

Like This?

Or

Thanks

Deepak

• ###### 2. Re: Removing Duplicates for Productivity Calculations

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

Can you explain the logic about the ratio?

• ###### 4. Re: Removing Duplicates for Productivity Calculations

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

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

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.

• ###### 7. Re: Removing Duplicates for Productivity Calculations

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