4 Replies Latest reply on Jun 20, 2018 1:56 PM by Binod Baniya

# How to Calculate Rate using two excel spreadsheets in Tableau 10

Dear tableau community,

I have an excel spreadsheet that has the information about the employees who were nominated for an award. The spreadsheet also has information about their location, gender, department, tenure, etc. I also have a second spreadsheet that has the information about  the headcount for the company. The 2nd spreadsheet includes location, gender, department, etc. for all the employees (who got the award and who did not) in the company.

I wanted to find the rate of nomination using Tableau where I can show the total no of employees nominated from a department "X" per the total number of employees in the department "X". I used the following formula in a calculated field, but does not seem to be accurate meaning the rate is right for some department and wrong for others.

SUM([Number of Records])/SUM([2015 (Blended 2015 P-A)].[No  of  EEs])

Any suggestion would be greatly appreciated.

Thank you.

Binod

• ###### 1. Re: How to Calculate Rate using two excel spreadsheets in Tableau 10

Looks Like You have Discrepancy in Employee names in both of your Sheets.

• ###### 2. Re: How to Calculate Rate using two excel spreadsheets in Tableau 10

I am working the data from 2015-2017. So, the employee IDs and names are sometimes repeated. Do you think the discrepancy could be because of that?

Anything else I can do to calculate the rate?

• ###### 3. Re: How to Calculate Rate using two excel spreadsheets in Tableau 10

Did you tried Joining Data?

• ###### 4. Re: How to Calculate Rate using two excel spreadsheets in Tableau 10

I tried blending the data but could not make it work. I will give one more shot.

After I blend, can I just divide the nominated employees by the total employees and use department, location as filters? Because we cannot divide location from nominated employees and total employees because they are string values, right?

Thanks.