Custom dimension consolidating values

Hello,

I’m trying to consolidate some data in a custom dimension where 

I have values like A1 A2 A3 A4 A5, B4, B6, B12, B13, C12, C2, C5, C6

I want to consolidate values under A, B, C only

So far i’ve been using this 

if(contains(${delivery_modes.display_name}, "delivery"),"Delivery", 
if(contains(${delivery_modes.display_name}, "signature"),"Delivery",
if(contains(${delivery_modes.display_name}, "royal Mail"),"Delivery",
if(contains(${delivery_modes.display_name}, "Standardversand"),"Delivery",
if(contains(${delivery_modes.display_name}, "post office"),"Delivery",
if(contains(${delivery_modes.display_name}, "Next day"),"Delivery",
if(contains(${delivery_modes.display_name}, "Collect"), "Collection",
if(contains(${delivery_modes.display_name}, "No"),"No delivery",concat("FIX--", ${delivery_modes.display_name})))))))))

 but it is really painful, is there another way to do this efficiently? 

I’m a newbie

Thanks

0 0 71
0 REPLIES 0