Hi Caroline

Understand your data is confidential  - that said it would help to see your data, how it is structured and joined

I was tracking with you LOD expressions tied to month or year but

you mentioned the 2 data sources -

the values used in LOD expressions must come from a single data source and depending on how you combined the sources using data from different sources may have other limitations

any chance you can provide some dummy data but include 2 sources?

Jim

If you would Join your data sources on say Dates. Then using LODs it is possible to get you what you need. Please attach some dummy datasets.

Thanks

Deepak

Hi Caroline

Thanks for attaching the file

if the denominator is the issue

2 LOD's

this is monthly

and annually

it will return values like this

did you need added help or can you take it from here

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

I looked at the terminations and have an annual term calc

and a turnover rate of

that added to the chart and removing months to give a summary returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Good morning

My Bad thought you were just looking for the annual

here is the monthly running total of terms

running_sum(sum(

{ FIXED year([Actual Termination Date]),MONTH([Actual Termination Date]):

countd([Employee ID])}))

and the monthly rate formula

[mnth attrition-runningtotal]/

(SUM([Sheet1 (Employee Data Set_Dummy Data_Tableau)].[average annual HC]))

these are each table calculations that need to be set as shown

and it will return this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

ok then divide by the count of months

returns this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

this is the formula

          sum({ FIXED  YEAR([Point in Time]): sum([monthly hc])})/[count of months]

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.