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.
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', )))))))
Perhaps this Count( {< DEFECT_ID = p(DEFECT_ID) >} DISTINCT DEFECT_ID)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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.
