Intersection

[cbaqir]

My requirement: For a DEFECT_ID that has gone through BOTH COM_CAT = 'ART - AMB Refinement Team' and COM_CAT = 'ERC - Routing', what is the current disposition? I tried p() and *= but I can't get seem to figure it out.

Expression: Count( {< DEFECT_ID = p({}) >} DISTINCT DEFECT_ID)

Dimension: =if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Approved'),'Approved', if(Match(COM_CAT,'APT - AMB Prioritization Team') and Match(CUR_STATUS,'Ready for Agenda'),'Waiting for Agenda', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Closed'),'Closed', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Dismissed'),'Dismissed', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Ready for Release'),'Ready for Release', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Building Non-Prod'),'Building/Testing Non-Prod', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Ready for Testing Non-Prod'),'Building/Testing Non-Prod', )))))))

[Anil_Babu_Samineni]

Perhaps this
Count( {< DEFECT_ID = p(DEFECT_ID) >} DISTINCT DEFECT_ID)

[marcus_sommer]

I assume the cause is quite similar like here: If-match-and-match.

I think I would create the needed categories within the script instead of using such large nested if-loops. Further I could imagine that one or maybe several flags could simplify the task especially if your category-values contain a kind of hierarchy.

- Marcus