In JIRA timeline - I want to see start date, due date and actual completion date on bar

[rohit_ambekar]

In JIRA timeline - It is normally Start date and due date is seen if you hover over any bar of task, I want to know if I add one field "actual completion date" then can I see also in the bar actual completion date ? so that the bar shows in same bar - Target completion and actual completion. so that with this view - we can able easily see in that single bar - both dates and delay portion can it be with different colour ?

Is this possible ? and if Yes then how we can set it in configuration ? 

[Sharad Dadarao Chate · Accepted solution]

Hi @rohit_ambekar 

Jira Timeline can show Start Date + Due Date only.

A custom field like “Actual Completion Date” cannot be shown on the same bar.

Jira does not support dual-color bars (target vs actual) in Timeline.

[rohit_ambekar]

Thanks a lot for this answer. I thought of adding actual completion date in plan column and I did this with Automation query. However I also need add one more Column Delay (Exceeded) in that plan so that we can atleast see delay in column. I took a help from Copilot to set the rule for this Delay (It should be in Numbers, like no of days). So i did multiple trials with normal as well JSON code. But I am not getting the result. 

Could you please support here how to set the rule to calculate and show delay in that column  "Exceeded"?

[Trudy Claspill · Accepted solution]

Hello @rohit_ambekar 

Welcome to the Atlassian community.

No, that is not possible.

In a Plan in the Timeline view you can add the Actual date field to the Custom fields that are displayed, but you cannot show three dates on the bar.

[Trudy Claspill]

Hello @rohit_ambekar 

When asking for help with an automation rule we need to see the rule you have created in order to help you debug it. Please provide screen images showing the entire rule and the details of each step.

The simple rule statement might be

"When the Actual Completion Date is set, then calculate the difference in days between that value and the Target End Date, and put that value in the Exceeded field".

However you also need to consider the case where the Target End Date is empty. Also, what would you want to happen if either the Target End Date or the Actual Completion Date was changed or cleared after the calculation had been done?

To calculate the difference in days between two date fields you would need to use a smart value. Information on that smart values for date/time field difference calculations can be found here:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-difference---

[rohit_ambekar]

Thanks a lot for this answer. I thought of adding actual completion date in plan column and I did this with Automation query. However I also need add one more Column Delay (Exceeded) in that plan so that we can atleast see delay in column. I took a help from Copilot to set the rule for this Delay (It should be in Numbers, like no of days). So i did multiple trials with normal as well JSON code. But I am not getting the result. 

Could you please support here how to set the rule to calculate and show delay in that column  "Exceeded"?