KPI Calculation help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have a Straight table like below image.

 Here Flag is calculated in UI like below

if(Sytemdate>=startdate      and  Sytemdate<=Enddate  ,'1' ,'0'  )

When Systemdate present in between Start and End dates then it has to show 1 else 0.

Requirement:

In a KPI how to calculate the  Number of Distinct IDs where Flag = '1'. Here flag is calculated in UI with above expression.

Can't apply the flag in backend.

I have tried like below in the below scenario but getting 0 instead of 2

Please help me on this.

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

Try count({<ID={"= [SystemDate]>=[StartDate] AND [SystemDate]<=[EndDate]"}>}distinct ID)

[ahmed_hassan]

Hi,  

I would recommend that you add the "if" statement in the script and create a field out of it e.g. 

if(Sytemdate>=startdate      and  Sytemdate<=Enddate  ,'1' ,'0'  ) as  Sytemdate_count 

and then try to count it e.g.  =Count({$<[Sytemdate_count]={1}>}Sytemdate_count)

Good luck!