How do yearly summary for backlog?

waszcma1 — Mon, 23 Jun 2014 10:56:41 GMT

I am calculating backlog in defined reporting period

mainly I do selection by clsoed cases:

for example:

case closed: 31/03/2014 - 06/04/2014

So I am checking which cases have been opened bifore max(inc_closed_at) == 06/04/2014 and closed after max(inc_closed_at) == 06/04/2014

So I have number of task opened and not closed by the end of the reporting period (backlog)

count({1<

inc_opened_at ={"< $(=max(inc_closed_at))"},

inc_closed_at ={"> $(=max(inc_closed_at))"}

>}inc_number)

How can I do this for a year and group by week/month ?

I have spent many hours on that and still cant find solution

I would like show the number of tasks opened and not closed by the end of each week or each Month

any ideas ?

topic How do yearly summary for backlog? in QlikView