Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try count({<ID={"= [SystemDate]>=[StartDate] AND [SystemDate]<=[EndDate]"}>}distinct ID)
Try count({<ID={"= [SystemDate]>=[StartDate] AND [SystemDate]<=[EndDate]"}>}distinct ID)
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!