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

Robb Corbett April 15, 2014

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

2 votes
Answer accepted
Mehmet Kazgan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2014

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.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 16, 2014

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.

Robb Corbett April 30, 2014

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/)

1 vote
jose_castro June 9, 2016

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 Sign up to answer