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

    FX help for KPI



      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?