How to show work items where the actual completion date was <= target completion date?

[Monika]

I have two custom fields, Actual Completion Date and Target Completion Date.

When a work item is created, I fill in the Target Completion Date.

When the work item is transitioned to Done, the Actual Completion Date gets auto-populated with the current date.

I want to show, on a dashboard, all work items that were completed on or before the Target Completion Date (so Actual Completion Date <= Target Completion Date)

Preferably as a chart and not just a list.

Any suggestions on how to do this in Jira? 

[Dwight Holman · Accepted solution]

This is a variation of a previous question: Using comparison JQL between two fields 

No this is not supported. The workaround suggested is to use automation to do the comparison and store the result in another (custom) field.

[Dwight Holman]

Forgot to say - when you have the 'comparison data' in an issue field, you could use a dashboard widget to visualise the result. We use the Custom Charts App since this provides better features than the built-in widgets.

[Dilip]

Jira JQL does not natively support direct comparison between two custom fields (e.g., "Actual Completion Date" <= "Target Completion Date").

Workarounds:

• If you have a custom field for "Actual Completion Date" and "Target Completion Date," you can filter by a specific value, but not compare them directly in JQL.

• You can use marketplace apps like ScriptRunner to enable scripted JQL functions that allow field-to-field comparisons.

• Alternatively, export your issues and perform the comparison in Excel or another tool.