Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
May I know hoe to write the below if condition in set analysis:
CODE:
if
(IncidentQualificationPerc='Approved',Count({$<INCIDENT_QUAL_STATUS={'Approved'}>}INCIDENT_NO)/Count(INCIDENT_NO),
if(IncidentQualificationPerc='Auto Qualified',Count({$<INCIDENT_QUAL_STATUS={'Auto Qualified'}>}INCIDENT_NO)/Count(INCIDENT_NO),
if(IncidentQualificationPerc='Disapproved',Count({$<INCIDENT_QUAL_STATUS={'Disapproved'}>}INCIDENT_NO)/Count(INCIDENT_NO
)
)))
You're already using set analysis expressions in that expression. And you can't replace the if statements with a set analysis expression. A set is calculated once for the entire chart, not per row.