Skip to main content

Insight report concatenating fields

If you would like to group fields to show on the same column ie 'home address' field has address lines 1,2,3 &4 grouped together but you want to include the post code.

J
Written by Joshua Shooter
Updated over a month ago

To group fields on a report in Insight, follow the below steps:

  1. Go to Settings then go to All Reports and find relevant the report.

  2. Click the three dots then click Manage then click Add.

  3. Click Calculation.

  4. Select the data field you would like to add, such as Home Full Address - this will then get added to the Calculation Text Section.

  5. Enter || ', ' || (if you would like a comma to separate the fields) if not || ' ' ||

  6. Click on the next data field, such as Post Code.

  7. Click Save.

Did this answer your question?