Dashboard/JQL Question - Resolution is not provided on tasks but status is.

[Matt Browne]

Hello,

I am new to the company I am working for and it appears that resolution is never used for any tasks, stories, etc. I am trying to build a dashboard and the Created vs. Resolved widget wont work since there are no "resolutions" provided only status of "done" or "resolved". Is there a way I can bring back or alias the Resolution column based on status of done or resolved?

I understand the workflow can be changed, however there are a lot of reasons why they will not want to do this at this time.

project in (PROJECT)
AND issuetype in standardIssueTypes()
AND status in (Resolved, CLOSED)
AND resolution in (Unresolved, Done, "Won't Do", Duplicate, "Cannot Reproduce", Cancelled) 
AND statusCategory in (2, 4, 3)
AND "IT Project[Dropdown]" = "PROJECT" AND created >= -30w order by created DESC

Thanks in advance!

-MB

[Trudy Claspill · Accepted solution]

Hello @Matt Browne 

Welcome to the Atlassian community!

Jira will consider an issue as "Resolved" for purposes of the Created vs. Resolved report if the Resolution field for the issue contains any value at all. It doesn't matter what the value is. The issue is considered Unresolved if the Resolution field is Empty.

There is no way to change the behavior of the Created vs. Resolved report to make it look at a different field.

One way you can "backfill" the Resolution field is to create an Automation Rule that will set that field. However, be advised that will also change both the Last Updated date and the Resolved date for each issue.

Only a Project Administrator (or Jira Administrator) can create Automation Rules.

If the team wants to be able to use that report, the workflow needs to be changed to automatically set the field on transitions to a "done" status or use a Transition Screen on those transitions to make the user select a Resolution value. The workflow would also need to be change to automatically clear the Resolution field on any transition to a "not done" status. That doesn't address the need to backfill old issues.

[Matt Browne]

Thanks Trudy! I was hoping there was another way but I suppose I will have to get creative.