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!
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.
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.
I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...
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!
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