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