We have a dashboard that currently sorts as follows:
Project = entpops AND resolution is EMPTY AND status not in ("Requester Review", Remediation, "Need More Info", "In Progress") ORDER BY priority DESC, created ASC
I would like to be able to insert a specific custom field just after the priority Desc so the priority "P1" comes first, tickets with cf[27251] = "Change Request Type" are listed second, and all other priority "P2" follow and each section is order by created ASC.
Or at least have the dashboard sort by Priority 1, cf[27251], and then all P2 tickets ordered by created ASC.