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!

Thanks!

2 answers

1 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 (http://www.tempoplugin.com/)

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 https://jira.atlassian.com/browse/JSW-13785 as well as the ability to search instead of drop down when you are selecting fields https://jira.atlassian.com/browse/JSW-13786 for the gadget statistical parameters.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,760 views 11 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot