It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Can I get a two dimensional filter that includes due date?

I use a lot of two dimensional filters to view my team's task count and monitor completion of projects.

I need to start tracking the due date on some of my people's tasks. I would like to break down the tasks by due date (by day ideally) and then by campaign/feature.

the JQL that I am trying to work with is this:

assignee = currentUser() AND duedate >= -7d AND resolution is EMPTY ORDER BY "Campaigns & Features" desc

Anything (plugins, advice, JQL) will help!


2 answers

1 accepted

2 votes
Answer accepted

I don't think date time type fields can be used for two dimensional filter. And JQL cannot use group by attribute to get you to the objective you are trying to.

I think you can do that by using JIRA Agile boards or querying to the database directly.

Correct - the 2d filter gadget can only handle "stattable" fields - that is, fields that are effectively fixed length lists. You need to be able to look at the list of possible values and say "there's X of them"

It's arguable that a date is a fixed length list as there's about 365 dates a year, but text fields, numbers and date/times certainly aren't.

Thanks for the input! I am able to get the kind of metrics that I need (for the time-being) from Tempo (

Hello folks. I know this is an older post. However I just wanted to make you aware that I opened a feature request for the documentation to be updated as well as the ability to search instead of drop down when you are selecting fields for the gadget statistical parameters.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted yesterday in Jira

Upcoming Enterprise releases targeting Q3 2019: Jira Software 8.5 & Jira Service Desk 4.5

Since launching the Jira Software 8.0 and Jira Service Desk 4.0 platform releases in February, many of you have been asking when the next Enterprise release will be so you can take advantage of the m...

253 views 2 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you