Should I use Set analysis or ... ?

[waszcma1]

Could anyone help me with this?

I have row data ~ 500 000 transactions (opened in 2014)

I want to display the number of not closed cases at the particular month/week (backlog)

How can I do graph/pivot on the scale month/week?

I tried this but it works only if I use it only as a snap shot

But if I use dimensions:  month(inc_opened_at)

and expression #1 :

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

it shows 0 for all months

I know I am doing something wrong but could you help me to find solution to find the right direction?

When I use only dimensions: month(inc_opened_at)

and expression #2:

max(inc_opened_at)

Month expression #1 expression #2

Jan         0         31/01/2014

Feb        0         28/02/2014

Mar        0         31/03/2014

Apr         0         30/04/2014

May        0         31/05/2014

Jun         0         30/06/2014

Jul          0         31/07/2014

Aug        0         31/08/2014