nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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 &gt;= -7d AND resolution is EMPTY ORDER BY "Campaigns &amp; Features" desc

Anything (plugins, advice, JQL) will help!

Thanks!

Accepted answers

Mehmet Kazgan_qriny9

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.

All comments

Mehmet Kazgan_qriny9

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jql

filter

due-date

gadget