Hi All,
Help me!
I want to count the ticket numbers with following conditions.
1)Count should be according to the month and the ticket type
2)If the ticket is opened ex: March and Closed in June then the ticket is carried forward to April, May and ultimately closed in June. So the count for April is +1, May is +1 and so on.
Please let me know if there are any questions.
Below is the data and requirement on right side.
<colgroup><col><col span="2"><col><col><col span="2"><col><col span="7"></colgroup><tbody>
</tbody>
<colgroup><col><col span="2"><col><col><col span="2"><col><col span="5"></colgroup><tbody>
</tbody>
Help me!
I want to count the ticket numbers with following conditions.
1)Count should be according to the month and the ticket type
2)If the ticket is opened ex: March and Closed in June then the ticket is carried forward to April, May and ultimately closed in June. So the count for April is +1, May is +1 and so on.
Please let me know if there are any questions.
Below is the data and requirement on right side.
Numbers | Opened | Closed | Yes/no | Open month | Close month | Type | This the presentation of count of tickets | |||||||
INC102122 | 11-03-2018 11:00 | 11-04-2018 00:00 | FALSE | March | April | INC | Months | INC | RIT | TAS | ARC | |||
INC102123 | 12-03-2018 11:00 | 12-04-2018 00:00 | FALSE | March | April | INC | May | |||||||
INC102124 | 02-01-2018 00:00 | 02-02-2018 00:00 | FALSE | January | February | INC | June | |||||||
INC102125 | 02-01-2018 00:00 | 02-02-2018 00:00 | FALSE | January | February | INC | July | |||||||
INC102126 | 17-10-2017 00:00 | 17-12-2017 00:00 | FALSE | October | December | INC | August | |||||||
INC102127 | 07-05-2017 00:00 | 07-07-2017 00:00 | FALSE | May | July | INC | September | |||||||
INC102128 | 17-11-2017 00:00 | 17-01-2018 00:00 | FALSE | November | January | INC | October | |||||||
INC102129 | 16-05-2017 00:00 | 16-07-2017 00:00 | FALSE | May | July | INC | November | |||||||
INC102130 | 02-01-2018 00:00 | 02-03-2018 00:00 | FALSE | January | March | INC | December | |||||||
INC102131 | 12-01-2018 00:00 | 12-03-2018 00:00 | FALSE | January | March | INC | January | |||||||
INC102132 | 16-05-2017 00:00 | 16-07-2017 00:00 | FALSE | May | July | INC | February | |||||||
RITM1458 | 22-09-2017 00:00 | 22-11-2017 00:00 | FALSE | September | November | RIT | March | |||||||
RITM1459 | 23-07-2017 00:00 | 23-09-2017 00:00 | FALSE | July | September | RIT | April | |||||||
RITM1460 | 25-06-2017 00:00 | 25-08-2017 00:00 | FALSE | June | August | RIT | ||||||||
RITM1461 | 14-12-2017 00:00 | 14-02-2018 00:00 | FALSE | December | February | RIT | ||||||||
RITM1462 | 02-07-2017 00:00 | 02-08-2017 00:00 | FALSE | July | August | RIT | ||||||||
RITM1463 | 08-01-2018 00:00 | 08-01-2018 00:00 | TRUE | January | January | RIT | ||||||||
RITM1464 | 11-06-2017 00:00 | 11-06-2017 00:00 | TRUE | June | June | RIT | ||||||||
TASK5468 | 01-01-2018 00:00 | 01-02-2018 00:00 | FALSE | January | February | TAS | ||||||||
TASK5469 | 07-01-2018 00:00 | 07-02-2018 00:00 | FALSE | January | February | TAS | ||||||||
TASK5470 | 16-07-2017 00:00 | 16-08-2017 00:00 | FALSE | July | August | TAS | ||||||||
TASK5471 | 13-12-2017 00:00 | 13-01-2018 00:00 | FALSE | December | January | TAS | ||||||||
TASK5472 | 21-11-2017 00:00 | 21-12-2017 00:00 | FALSE | November | December | TAS | ||||||||
TASK5473 | 29-07-2017 00:00 | 29-08-2017 00:00 | FALSE | July | August | TAS | ||||||||
ARCT4658 | 19-05-2017 00:00 | 19-06-2017 00:00 | FALSE | May | June | ARC | ||||||||
ARCT4659 | 26-10-2017 00:00 | 26-11-2017 00:00 | FALSE | October | November | ARC | ||||||||
ARCT4660 | 11-11-2017 00:00 | 11-12-2017 00:00 | FALSE | November | December | ARC | ||||||||
ARCT4661 | 12-08-2017 00:00 | 12-09-2017 00:00 | FALSE | August | September | ARC | ||||||||
ARCT4662 | 07-08-2017 00:00 | 07-09-2017 00:00 | FALSE | August | September | ARC | ||||||||
ARCT4663 | 02-11-2017 00:00 | 02-12-2017 00:00 | FALSE | November | December | ARC | ||||||||
ARCT4664 | 14-09-2017 00:00 | 14-10-2017 00:00 | FALSE | September | October | ARC | ||||||||
ARCT4665 | 03-06-2017 00:00 | 03-07-2017 00:00 | FALSE | June | July | ARC | ||||||||
ARCT4666 | 31-07-2017 00:00 | 31-07-2017 00:00 | TRUE | July | July | ARC |
<colgroup><col><col span="2"><col><col><col span="2"><col><col span="7"></colgroup><tbody>
</tbody>
<colgroup><col><col span="2"><col><col><col span="2"><col><col span="5"></colgroup><tbody>
</tbody>