Question

Custom dimension consolidating values

  • 9 June 2021
  • 0 replies
  • 16 views

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


This topic has been closed for comments