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

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.