Let's say you want to create a new custom attribute that's a combination of ticket urgency and ticket priority. Perform the following steps to create this custom attribute.
- Navigate to Settings.
- Select Custom Attributes.
- Click Create Attribute.
- Enter a name for your custom attribute. Let's call it 'Urgency and Priority'.
- Optionally, enter a description for the attribute.
- Select the module. You can select 'Tickets' for this example.
- Select the data type. You can select 'String' for this example.
- Click Functions in the Insert section and scroll down to the string functions.
- Click CONCAT so that it appears in the Formula section.
- Click Columns in the Insert section and search for Urgency.
- Click Urgency so that it appears as a parameter for CONCAT in the Formula section.
- Enter a comma and then type " : ", followed by another comma.
- Click Columns in the Insert section and search for Priority.
- Click Priority so that it appears as the last parameter for CONCAT in the Formula section.
- Click Check Syntax and ensure that a message appears confirming the formula as valid.
- View the sample value of the attribute in the Preview section.
- Click Save Attribute.
You can now use this custom attribute in your reports. It will appear as 'Urgency and Priority'.