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?