from query to graph - running sum of tasks outstanding

[galantis]

Hi,

I am still confuse after reading threads on producing running sum on queries. help!

This query is to produce a time line graph of Progress Tasks with 3 main categories - New, Completed and Outstanding. So I got months on the x-axis and count on the Y-axis.

sample data.
say we look back for jobs in the month in feburary
Date Added; Date Completed ; category
11/1 ; NIL ; Outstanding
11/1 ; 1/3 ; Outstanding
11/1 ; 14/2 ; Completed
1/2 ; NIL ; Outstanding
1/2 ; 1/3 ; New and Outstanding
1/2 ; 14/2 ; New and Completed

so the total count of the categories for Feburary
New = 2 ,Completed= 2, Outstanding=4

can anyone help?

thanks
galantis

 

[galantis]

help anyone?