JQL - setting set of field values to summarize output for Dashboard

unknown

The query does a select on Team with one team = DBDev and the other teams with three discrete values for Team:

...  AND "Team" in (DBDev,  Backoffice-1, Backoffice-2, Backoffice-3)

I want to set the values for Backoffice-1, Backoffice-2 and Backoffice-3 to the value "Backoffice" such that output aggregates these discrete values under one heading

Nic Brough -Adaptavist-

There is no way to do that - you've got separate values in the field, so JIRA reports on them separately.

If you were to find/write a custom report to look at your JQL, you could do that sort of thing.