8 Replies Latest reply: Jul 25, 2017 1:48 PM by Antonio Mancini RSS

    Count Rolling 6 Months

    Cassandra Baqir

      I need to show a variety of metrics based on volume of DEFECT_ID within the last 6 months.

       

      I started with: =Count({$<PROCESS_STEP={'Ticket Created (Detected)'}>}DEFECT_ID)

       

      but when I add the addmonths function, it doesn't work.

       

      =Count({$<PROCESS_STEP_START_DATE={">=$(=Date(addmonths(monthend(today()),-6),'MM-DD-YYYY'))<=$(=Date(addmonths(monthend(today()),0),'MM-DD-YYYY'))"},PROCESS_STEP={'Ticket Created (Detected)'}>} distinct DEFECT_ID)

       

      I would expect to see 146.

       

      Any ideas?

      TIA!