1 Reply Latest reply: Oct 14, 2016 3:00 AM by Lakshmikandh Karthikeyan RSS

    on a selected date range , how to find the following ?

    gaurav gopale

      hi

       

      i have the following table

      IDDateTicket TypeStatus





      00101-Jan-2016Aopen
      00202-Jan-2016Bopen
      00306-Jan-2016Aopen
      00105-Jan-2016Aclosed
      00601-Feb-2016Dopen
      00702-Mar-2016Bopen

       

      on the selected date range in what

       

      Number of "open" tickets ,

      Number of "closed" ,

      Number of tickets closed within month (ie ticket raised in a month is closed in the same month)

       

      For example

      form the above table , if i select 1-Jan-2016 to 30-Jan-2016

      Number of open tickets:- 2

      Number of closed tickets :- 1

      Number of tickets closed within that month :- 1

       

       

      i want to show in table and also in KPI

       

      can anyone help me?