Creating a dashboard to display tickets in specific priority

[Deleted user]

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.

[Florian Bonniec]

Hi @[deleted] 

I do not see how you can do it in one gadget. Is there any reason to not create 3 gadgets in your dashboard ?

P1 then cf[27251] = "Change Request Type" then everything else ?

Regards

[Deleted user]

We were trying to consolidate everything into 1 list so the team can continue their focus working tickets from the top down.  

Creating 3 may be where we land.  I was hoping someone might know how to write something like this up.