FX help for KPI

[#1]

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?

[sunny_talwar]

What is the expected output here?

[sunny_talwar · Accepted solution]

Is the last 7 day number of Gordon  = 6? May be try this:

Count({$<[Discovery Assignee]={"Gordon"},[Discovery Sign Off Date]={"$(='>=' & Date(Max([Discovery Sign Off Date])-7) & '<=' & Date(Max([Discovery Sign Off Date])))"}>}[Discovery Sign Off Date])

[#4]

Hi,

I would like to count how many Discoveries were completed (Discovery sign off date) by Gordon / Victor / Bryan over the last 7 days or 28 or 90 days

but ignoring the blank cells

[sunny_talwar]

Have you checked the attached qvf above?

[#6]

Hi Sunny,

sorry I've been off line, their is no qvf attached?

i will try the FX now

[sunny_talwar]

Open this link to check the qvf

Re: FX help for KPI

[#8]

Thank you So much