4 Replies Latest reply on Jul 31, 2018 10:09 AM by Susan Hildebrant

# LOD vs. table calc to produce department utilization

Hello,

I am trying to use an LOD calc in place of a table calc, so that it can be nested into other calculations. Here is the background. In the attached workbook using Tableau 10.5, I have created utilization by individual using the actual worked hours divided by the available hours in a month. It works perfectly. I also calculate headcount by department using a table calc (See worksheet labelled "Headcount Table Calc") which results in the correct result. Now, I need to calculate the department utilization by using the cumulative department actual worked hours divided by (month headcount*available monthly hours). I have tried using a nested table calc, but I could never get the correct answers.

I decided to try calculation the department headcount using an LOD calc ( I am a novice at LOD), but I cannot get the data by month, which varies. This is shown in the Headcount LOD worksheet.

My ultimate goal is to be able to calculate utilization by department and company total. I am completely frustrated an lost. Here's hoping someone can help.

I have attached the packaged workbook and an Excel workbook containing the raw data.

Here's hoping someone can help.

Regards,

Susan

• ###### 2. Re: LOD vs. table calc to produce department utilization

Thank you, Bharat for the links.

Unfortunately, none address my problem. I can already calculate individual utilization. My problem is calculating the department utilization by month when the total headcount for the department varies monthly. This simple formula is billable hours/(department headcount*hours in a month). All three vary month-to month.

Susan Hildebrant

PMO Manager

BRIDGE Energy Group

Improving real-time operations

O: 508.683.3312| M: 508.364.3866

www.BridgeEnergyGroup.com<http://www.bridgeenergygroup.com/>

• ###### 3. Re: LOD vs. table calc to produce department utilization

Hi Susan,

I was rechecking the data in the excel sheet,There are no common fields across the excel tabs.

There is no field like employee id which is common across the excel tabs so not sure how you are joining the data  here to get the   accurate data.

I feel the data should be remodelled to get the accurate results.

BR,

bharat

• ###### 4. Re: LOD vs. table calc to produce department utilization

Hi Bharat,

I am not sure what needs to be done. I have been using this schema for some time now and all the calculated fields work correctly, except for the LOD.

Susan Hildebrant

PMO Manager

BRIDGE Energy Group

Improving real-time operations

O: 508.683.3312| M: 508.364.3866

www.BridgeEnergyGroup.com<http://www.bridgeenergygroup.com/>