KPI Expression help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

In the attached image KPI I have used the below expression

=if(len(GetFieldSelections(EmpTYPE))=0,
Count({<Flag={'Completed'}>}distinct EmpID),

if(GetFieldSelections(EmpTYPE)='New','N/A',

if(GetFieldSelections(EmpTYPE)='Permanents',
Count({<Flag={'Completed'}>}distinct EmpID)
)))

as per this expression when user selects EmpType = New then in the KPI instead of 0 I am passing N/A

Same like when user selects New EmpType related any employee Id then also this KPI has to show N/A instead of 0 value.

Please help me on this. Please find the below attached app.

Note: I am looking for the solution only in Front end.

Thank in advance

[agigliotti]

your KPI expression looks good, what's your expected result?

[andrey_krylov]

Hi Mahitha. Try this

=if(EmpTYPE='New','N/A',

if(len(GetFieldSelections(EmpTYPE))=0,

Count({<Flag={'Completed'}>}distinct EmpID),

if(GetFieldSelections(EmpTYPE)='Permanents',
Count({<Flag={'Completed'}>}distinct EmpID)
)))

[mahitham]

Hi agigliotti

I have mainly two filters Emp Type and Emp Id.

User either selects Emp Type or Emp Id.

Requirement is when user select EmpType = New then need to show N/A in the KPI

if user selects any EmpID related to EmpType = New then also need to show N/A in the KPI

by default need to show actual count.

[agigliotti · Accepted solution]

maybe this:

=if(len(GetFieldSelections(EmpTYPE))=0 and EmpTYPE<>'New',

Count({<Flag={'Completed'}>}distinct EmpID),

if(GetFieldSelections(EmpTYPE)='New' or EmpTYPE='New','N/A',

if(GetFieldSelections(EmpTYPE)='Permanents',

Count({<Flag={'Completed'}>}distinct EmpID) )

        )

)

I hope it helps.

[mahitham]

Thank for your help. Its working