We've had a request to see if there is any easy way of listing incidents by breach order.
Similar posts have been raised (I have searched and viewed) - and am reasonably au faix with how the queries etc work.
I am half anticipating 2 answers in relation to this!
1. Order by colour value
- This is OK, but doesn't specifically list the incidents by the time order of which they will breach i.e. it will list all breached, then ones at the next expiry point etc. so strictly speaking in terms of time value, it doesn't list by chronological order in which ones will breach next
2. Order by expiry point on query based on escalation point
- Pretty much same as above
If there is no easy answer to this other than the above, that's fine - just would like to know if there are any other options.
One other thing I'm trying to find out is what 'Priority Rank' actually means? If ordered by this, would this achieve what I'm trying to do?
Thanks in advance,