Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to write an expressions that gives me the average days per DEFECT_ID between a combination of ADJ_GOVERNANCE_PHASE = 3.2* (which has ADJ_GOVERNANCE_PHASE_END_DATE or ADJ_GOVERNANCE_PHASE_START_DATE) and TICKET_STATUS = Complete (which uses STATUS_START_DATE) through ADJ_GOVERNANCE_PHASE = 4.1* (which has ADJ_GOVERNANCE_PHASE_START_DATE).
I am struggling to see if this is even possible using intersection.
I've attached a QVW. DEFECT_ID = 312 is an example. ADJ_GOVERNANCE_PHASE = 3.2* AND TICKET_STATUS = Complete should be 3/9/2020 and ADJ_GOVERNANCE_PHASE = 4.1* has ADJ_GOVERNANCE_PHASE_START_DATE = 3/10/20. For this DEFECT_ID, I expect it to show 1 .x days and then I need to have the aggr avg for DEFECT_ID
Intersection Set Anaysis: =sum({<DEFECT_ID=P({<ADJ_GOVERNANCE_PHASE={'3.2*'}>}ADJ_GOVERNANCE_PHASE_END_DATE)>*<DEFECT_ID=P({<TICKET_STATUS={'Complete'}>}STATUS_START_DATE)>*<DEFECT_ID=P({<ADJ_GOVERNANCE_PHASE={'4.1*'}>}ADJ_GOVERNANCE_PHASE_START_DATE)>} distinct DEFECT_ID)
Thank you.
Just bumping this to put it back in the top of the queue to see if one of the Set Analysis gurus can have a look and provide some feedback, I am afraid I am not much help to you directly, but hopefully one of the other guys will be able to have a look and leave some ideas.
Regards,
Brett
Just bumping this to put it back in the top of the queue to see if one of the Set Analysis gurus can have a look and provide some feedback, I am afraid I am not much help to you directly, but hopefully one of the other guys will be able to have a look and leave some ideas.
Regards,
Brett