Modeling stock-type indicators: headcount, occupancy, and more!

I recently worked on a project where I had to calculate a maintenance backlog. A maintenance backlog is a count of the number of tasks that are active (or in a specific status) at a specific point in time. These tasks have a duration of one or more days. This type of indicator falls under the category of semi-additive indicators. They are additive on all but the time dimension.

Read more...