4 Replies Latest reply on Mar 25, 2015 11:08 AM by Ramya Anbarasu

    count based on 2 date parameters and one more parameter

    Ramya Anbarasu

      Hi guys,

      I am trying to find out the count of tickets that were open at the end of each month with respect to severity

      This is how I want to view my sheet

      output.JPG

      The data set that I am dealing with is in the below format

      data.JPG

      Here is the tricky part, I want to calculate how many defects were open at the end of each month.

      For example, the ticket number 234109, was opened on 2-JAN-2014 but was closed in 3-MAY-2014. Which means, it was open by the end of Jan, feb, mar and april. So it should show up while calculating counts for those months under "Low" severity.

      Any inputs will be of great help!

       

      Thanks in advance.