Can we combine Group By Assigned To and Group By Additional Assignee List

[amolpawar]

Hi Experts,

I have a pie chart report that shows all assigned incidents grouped by Assigned To.

We want to show incidents grouped by which are in 'Additional Assignee List' field as well.

See in above image, we need to change Group by every time with Assigned To and Additional Assignee List, but is it possible we can show all incidents grouped by assigned to and additional assignee as well without need to change the Group By?

Thanks in advance,

Amol

[Ankur Bawiskar]

@amolpawar 

group by on List field is not supported as it holds more than 1 value (sysId)

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Dr Atul G- LNG]

In a pie chart, this is not possible. If you need a trend view, you can instead create multiple data series in a report so that both perspectives can be shown together.

https://www.servicenow.com/docs/r/now-intelligence/reporting/c_MultipleDataSets.html

[Tanushree Maiti]

Hi @amolpawar 

It is not possible  "show all incidents grouped by assigned to and additional assignee as well without need to change the Group By"