Close Period

The ClosePeriod compass extract query limits records to close years greater than 2020. To expand the time frame, update the “WHERE” clause of the query.

Measure	Source and/or calculation
Close Period Actual Days To Close	Days between period open date and period close date
Close Period Count	ClosePeriod record count
Close Period Expected Days To Close Variance	Days between actual days to close and scheduled days to close
Close Period Scheduled Days To Close	Days between scheduled begin date and scheduled close date