is it possible to make a breakdown mapping on 2 fields for 1 table?

[andre74]

I am trying to create a breakdown mapping on the task table concerning severall task types.

the problem is that some of the task types are only assigned to a person (assigned to) and others only to the assignment group.

both "assigned to" and "assignment group" are related to a department.

How can i create 1 breakdown mapping on the task table for these 2 fields?

[surajmesinane1]

Any Solution for this. I am working on a similar case where i need breakdown based on (Category and Sub-Category) from the incident table.

[stefaan1]

You aren't telling us where you intend to use it.

In dashboards it's 1 breakdown for 1 field.

https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/dashboards/task/filter-breakd...

Breakdowns as PA widgets:

https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/performance-analytics/concept...

Users are part of a group, therefore the "Assignment Group" field and "Assigned To" field are not of equal importance (there's a hierarchy between the Group and the User who's in it), and it would be incorrect to be able to just throw them together in the same list of values of a single breakdown. Besides, mixing both on 1 list of names might confuse other users of your breakdown.

Lastly, it's not recommended to create a breakdown on a field that can have thousands of unique values, e.g. users.