Hello
I am trying to create a KPI called PO Touch Indicator that will allow me to have a Value of touchless, manual intervention, or unknown based on the activites and User Type per PO.
When AT LEAST one UserType = - then unknown
When ALL UserType = B then Touchless
When AT LEAST one UserType = A and rest are B or all are A then Manual intervention
Ex 1:
PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: A // KPI "PO Touch Indicator: unknown
PO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: - // KPI "PO Touch Indicator: unknown
PO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KPI "PO Touch Indicator: unknown
Ex 2:
PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: B // KPI "PO Touch Indicator: touchless
PO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: B // KPI "PO Touch Indicator: touchless
PO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KPI "PO Touch Indicator: touchless
Ex 3:
PO: 12344232 // PO ITEM: 01 // Activity: 1 // UserType: A // KPI "PO Touch Indicator: manual intervention
PO: 12344232 // PO ITEM: 01 // Activity: 2 // UserType: A // KPI "PO Touch Indicator: manual intervention
PO: 12344232 // PO ITEM: 01 // Activity: 3 // UserType: B // KPI "PO Touch Indicator: 'manual intervention