As a temporary measure you might like to try using a swimlane query based on the due date. Something like
duedate < +7d
duedate < +14d
which whilst not sorting by duedate will cluster together items with a similar duedate.If there are no items matching a swimlane query then it will not show.
For full disclosure, I represent the company behind the plugin I mention below. The rank field is is used internally by Jira for drag and drop. If you sort by anything else, you will not be able to move issues. We developed a plugin to address Exactly this problem. The way it works is that you can define your own order-by clause which will let you re-rank issues. Take a look if it’s what you need: https://marketplace.atlassian.com/1221621 I hope it helps
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events