Backlog Chart for Open Orders

[#1]

I have orders that are open for a given period of period of time and then eventually close when fullfilled.  I need a chart to show the number of open units at any given month.

Example

            Creation Date     Closed Date     Units

Order 1  01/2014              04/2014            5

Order 2  01/2014              Open              10

Order 3  02/2014              05/2014            3

Order 4  02/2014              03/2014            2

The chart should like like this:

01/2014       15 units (5+10)

02/2014       20 units (5+10+3+2)

03/2014       18 units (5+10+3)

04/2014       13 units (10+3)

05/2014       10 units

[#2 · Accepted solution]

You may load island table with possible months. It will be dimension of your chart.

As a expression you may use something like this:

sum(if(open_date<dim_date and close_date>dim_date,Units))

regards

Darek

[#3]

Thank you so very much.  Works exactly as expected!!