4 Replies Latest reply: Jul 27, 2017 10:16 AM by Cassandra Baqir RSS

    Set Analysis with Aggr/Rank or Min?

    Cassandra Baqir

      I am trying to get a count of distinct defects created within the last 6 months.

       

      I have a requirement to only account for the earliest DEFECT_STATUS_START_DATE since the defect could go through the New DEFECT_STATUS more than once. How do I account for this? Do I use min or Aggr/Rank somehow?

       

      Count({$<DEFECT_STATUS_START_DATE={">=$(=Date(addmonths(monthend(today()),-6),'MM/DD/YYYY'))<=$(=Date(addmonths(monthend(today()),0),'MM/DD/YYYY'))"},DEFECT_STATUS={'New'}>} distinct DEFECT_ID)

      TIA!

       

      stalwar1