intersection set analysis

[cbaqir]

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.

[Brett_Bleess · Accepted solution]

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