2 Replies Latest reply on Nov 17, 2014 4:53 AM by Aneesh Appukuttanpillai

    Carried details

    Aneesh Appukuttanpillai

      Hi All,

       

      I have a list of ticket numbers open and closed dates.

       

      Is it possible to get a monthly carried over tickets details from this data.

       

      TicketNo.OpenedClosed
      2511-Jan-148-Jan-14
      2522-Jan-1411-Feb-14
      2535-Feb-147-Feb-14
      2605-Feb-1417-Mar-14
      2546-Feb-142-Apr-14
      25511-Feb-1416-Feb-14
      2567-Mar-1415-Jul-14
      24011-Mar-1430-Apr-14
      2578-Mar-1420-Mar-14
      2583-May-1412-Jun-14
      2594-May-1416-May-14
      2609-Sep-1422-Sep-14
      26110-Sep-1420-Oct-14

       

      Output format

        

      MonthCarried Ticket Count
      January-141
      February-142
      March-142
      May-141
      September-141

       

      Thanks,

      Aneesh.