mergeing two dimension

[#1]

I have a requirement where I need to display the no.

of created tkts and no.of resolved tkst by each month.

here is the input table,

Ticket_number	created_on	Resoved_date
INC3522866	2014/02/28 23:51:21	2014/03/04 15:34:30
INC3522836	2014/02/28 23:46:22	2014/03/03 14:48:11
INC3522821	2014/02/28 23:44:48	2014/03/03 14:29:12
INC3522804	2014/02/28 23:43:00	2014/03/07 18:07:31
INC3522781	2014/02/28 23:40:52	2014/03/04 16:16:06
INC3522766	2014/02/28 23:38:43	2014/03/04 15:50:04
INC3522752	2014/02/28 23:37:19	2014/03/04 15:33:15
INC3522737	2014/02/28 23:35:32	2014/03/11 15:10:46
INC3522715	2014/02/28 23:33:05	2014/03/04 15:27:51
INC3522696	2014/02/28 23:31:09	2014/03/04 15:50:42
INC3522682	2014/02/28 23:29:09	2014/03/04 15:37:41
INC3522625	2014/02/28 23:26:18	2014/03/04 15:45:14
INC3522587	2014/02/28 23:20:06	2014/03/04 15:59:26
INC3522560	2014/02/28 23:17:02	2014/03/04 15:53:35
INC3500608	2014/02/26 20:00:52	2014/03/05 21:06:22
INC3490435	2014/02/25 21:04:53	2014/03/15 07:31:25
INC3486790	2014/02/25 15:42:27	2014/03/07 21:53:58
INC3450140	2014/02/20 01:50:49	2014/02/27 15:18:33
INC3376969	2014/02/10 23:09:27	2014/02/12 15:36:59
INC3374649	2014/02/10 20:23:54	2014/02/14 00:45:58
INC3309028	2014/01/31 15:47:10	2014/02/06 19:34:13
INC3241280	2014/01/23 03:45:29	2014/01/29 22:21:30
INC3165238	2014/01/13 17:15:26	2014/01/13 17:21:06
INC3107435	2014/01/03 22:11:59	2014/01/09 14:36:37

My output look like this:

Month	expr1(count.of created tickets)	expr2(count.of reolved tickets)
jan	4	3
feb	20	4
mar	0	17

I am attached sample qvw,I am able to get the expr1 values but..expr2 getting wrong values.

Thanks

[ashfaq_haseeb]

Hi,

Can you close this thread by selecting appropriate answer.

Regards

ASHFAQ

[Anonymous]

You can change your model little bit:

T1:

Load

  Month1 as Month,

  Ticket_number,

  'Created' as Source

Resident Sheet1$;

Concatenate(T1)

Load

  Month2 as Month,

  Ticket_number,

  'Resolved' as Source

Resident Sheet1$;

Drop table Sheet1$;