I am building a chart and the expression needs to be the average days (aggr at the DEFECT_ID level) between the min ADJ_GOVERNANCE_PHASE_START_DATE where ADJ_GOVERNANCE_PHASE = '4.3 - Non-Prod Build & Testing' and min ADJ_GOVERNANCE_PHASE_START_DATE where ADJ_GOVERNANCE_PHASE = '4.8 - Prod Build & Validation' AND TICKET_STATUS = 'Ready for Validation Prod'
Can someone please help me?
aggr(min( {$<ADJ_GOVERNANCE_PHASE={'4.8*'},TICKET_STATUS={'Ready for Prod Validation'} >} ADJ_GOVERNANCE_PHASE_START_DATE)-min( {$<ADJ_GOVERNANCE_PHASE={'4.3*'} >} ADJ_GOVERNANCE_PHASE_START_DATE),DEFECT_ID)
