Interval Functions

Interval functions enable you to calculate point in time reports. For example:

• Looking at deal value in the pipeline over time. Instead of seeing just when deal value was created or when deal value was closed, seeing how much was in the pipeline each month.
• Understanding work load on projects or tasks over time. Instead of seeing just when tasks are created or completed, seeing how many open tasks each assignee each day.
• Visualizing how many tickets have open at a point in time. Instead of seeing just when tickets are created or resolved, seeing how many open tickets have been in progress each day.

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])