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

[Robb Corbett]

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!

[Mehmet Kazgan · Accepted solution]

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-]

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]

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

[jose_castro]

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.