What's new in Customer Journeys?

Connect and learn more!
Formatting based on two columns — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formatting based on two columns

Accepted answer
edited Mar 28, 2018 2:24PM in Reporting & Analytics for B2C Service 1 comment



any advisce how I should go about combining values from two columns?

Basically, I have one column based on a custom field called member value which outputs either Norm (normal customer) and HV (high value customer) like: if((incidents.c$membervaluepriority >= 80),'HV','Norm')

Then I have a column that outputs the group the incident is assigned to (accounts.group_id).

What I would like to achieve is a column that combines these two in the following way: output 1st column, but if the group equals selected groups (3 out of many) change the output from Norm of HV to VIP.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!