We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
11
Views
1
Comments
edited Mar 28, 2018 2:24PM in Reporting & Analytics for B2C Service 1 comment

Content

Hi,

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.

Register

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