Dates metrics

The following metrics are used primarily in the Attrition analysis area. Most of these metrics are filtered. See the object definition for details.

Metric/KPI	Description	Formula
Current Month	Uses a function returning the current month.	Max(Month(CurrentDate())) {~}
Current Tenure	Uses a function returning the current tenure of an employee, calculated by comparing the hire date to the current date.	Max((CurrentDate() - [Hire Date])) {~}
Contract Duration (days)	Uses a function returning the total duration of a contract.	Avg(([Contract End Date] - [Contract Start Date])) {~}
Annualized Contract Duration	Contract duration divided by 365.	(Avg(([Contract End Date] - [Contract Start Date])) {~+} / 365)
Employee's Birthday Date	Uses a function returning the date of birth of the employee.	Max(DayOfMonth([Birth Date])) {~}
Employee's Birthday Month	Uses a function returning the month of birth of the employee.	Max(Month([Birth Date])) {~}
Employee's Hire Month	Uses a function returning the month of hire of the employee.	Max(Month([Hire Date])) {~}
Days Open	Number of days during which a position has been vacant (for closed jobs).	Max(([Job Close Date] - [Job Open Date])) {~}
Days Open to Current Date	Number of days during which a position has been vacant (for open jobs).	Max((CurrentDate() - [Job Open Date])) {~}