Ticket Path Date Format and Calculation

[cbaqir]

I am trying to mimic a similar but not the same chart I did previously that shows the chronological process path of a ticket:

The first question I have is why my dates aren't displaying correctly in the new version. QVW also attached.

The new version below is a little different in that it's showing phases and one of the phases is 5.2 - Ticket Completion. The secnd question is how can I exclude the date from this phase so it doesn't show on the timeline?

num(if(isnull(ADJ_GOVERNANCE_PHASE_END_DATE and CUR_STATUS_GRP='Closed'),date(today()-ADJ_GOVERNANCE_PHASE_START_DATE),aggr(sum({$<ADJ_GOVERNANCE_PHASE-={'5.2 - Ticket Completion'} >}ADJ_GOVERNANCE_PHASE_TAT),DEFECT_ID,ADJ_GOVERNANCE_PHASE)), '#,##0')

[Kushal_Chawda]

@cbaqir  not sure I understood completely but Your expression returns number values which you have formatted as Date which is wrong. I have changed what I could think of .see the attached.

[cbaqir]

The intent is that the x-axis shows the ADJ_GOVERNANCE_PHASE_START_DATE. The idea is a timeline for a particular ticket like below. This one ticket started in X phase on Y date and lasted Z days. Then it went to the next phase on the next date and lasted AA days. The other complication is that the last phase of 5.2 - Ticket Completion should NOT be in the view.

[cbaqir]

@Kushal_Chawda Any other ideas?

[Kushal_Chawda · Accepted solution]

@cbaqir  sorry for the late reply. see the attached. Hope this is what you are looking for

[cbaqir]

Awesome! You are amazing. Thanks!