7 Replies Latest reply: Jan 11, 2017 5:20 AM by Dean Vincent RSS

    FX help for KPI

    Dean Vincent

      Hi,

       

      Please could i ask for your help with this FX

       

      I am trying to create a KPI that counts the Discover only over the last seven days ignoring blank fields

       

      I would like one for seven days, twenty-eight days and ninety days

       

      The FX created doesn't return the correct count???

       

      Count({$<[Discovery Assignee]={"Gordon"},[Discovery Sign Off Date]={*}>*(<DaysAgoImport={0,1,2,3,4,5,6}>)}[Discovery Sign Off Date])

       

      it seems to be only counting the the "Discovery Assignee" field?