Is it possible to combine multiple columns into one column for a list report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2020 03:30 AM
Hi all,
I'm making a dashboard that holds multiple list reports in it, to work more efficiently and have a lot of info within 1 field.
One of the reports I'm using is based on the Task Table and shows incidents, changes and tasks that are assigned to my team. So far, I've been using the "created by" column as a field to show who requested the incident, change or task.
However, that's not accurate enough, as incidents are often requested by some who's not the "caller" and is thus not experiencing the issue. So showing that person's name isn't accurate.
Is it possible to combine multiple columns in the results list and show it as 1?
For example, instead of displaying 3 columns:
- Requested for (Request task)
- Requested by (Change Request task)
- Caller (Incident task)
Can I combine this into one? Because three columns takes up a fair bit of my screen's "real estate".
Thanks!
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-27-2020 11:30 PM
You can try to create New field on task table.
After that using business rule copy values from different tickets from requested by, requested for or caller fields into this one unified field so you can display it on report.