MicroStrategy ONE
Benefit and Time Off metrics
The following metrics are used primarily in the Benefits analysis area. See the object definition for details.
Metric/KPI | Description | Formula |
Company Cost |
Cost to the company of a benefit per employee, by quarter. |
Sum([Company Cost]) {~} |
Employee Cost |
Cost to the employee of a benefit per employee, by quarter. |
Sum([Employee Cost]) {~} |
Participants |
Number of people participating in a benefit. This can be different from the number of enrolled employees since employees can enroll their family members. |
Sum([Number of Participants]) {~} |
Enrolled Employees |
Number of employees enrolled in a certain benefit. |
Count(Employee) {~, Time} |
Participation Rate |
See formula to the right. |
((1.0001 * [Enrolled Employees]) / (1.0001 * Employees)) |
Avg. Company Cost per Enrolled Employee |
See formula to the right. |
(Sum([Company Cost]) {~} / [Enrolled Employees]) |
Avg. Company Cost per Participant |
See formula to the right. |
(Sum([Company Cost]) {~} / Participants) |
Accrued Days |
Number of days accrued per employee, per time off type. |
NullToZero(Sum([Number of Accrued Days])) {~} |
Available Days |
See formula to the right. |
([Accrued Days] - [Used Days]) |
Used Days |
Number of days used per employee per year. |
Sum([Number of Used Days]) {~} |