Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
@cbaqir sorry for the late reply. see the attached. Hope this is what you are looking for
@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.
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.
@Kushal_Chawda Any other ideas?
@cbaqir sorry for the late reply. see the attached. Hope this is what you are looking for
Awesome! You are amazing. Thanks!