Interval functions enable you to calculate point in time reports. For example:
In all of these examples, the data typically has a start date, an end date, an identifier and one or more measures. The goal is to sum that measure for each date and identifier going from start date to end date.
To accomplish this goal, you can use the fill and fillinterval functions. They work in the same way, but fill clears out the identifier and date fields so that they won't get in the way of any calculations or aggregation you may have. Both functions have the same syntax:
fill([Task ID], [Task Start Date], [Task Due Date])
fillinterval([Task ID], [Task Start Date], [Task Due Date])