Set Analysis

[cbaqir]

This works: ='Closed/Created w/i 6 months (Correct): ' & Count({$<CUR_STATUS = {'Closed'},DEFECT_ID *= {"=Min({1<DEFECT_STATUS={'New'}>}DEFECT_STATUS_START_DATE) >= AddMonths(Today(),-6) and Min({1<DEFECT_STATUS={'New'}>} DEFECT_STATUS_START_DATE)
< Today()"}*e( {1< PRIMARY_DECISION_BODY ={'SMG Committee'}>})>} DISTINCT DEFECT_ID)

Requirement:

CUR_STATUS  = Closed during last 6 months when opened(min DEFECT_START_DATE of DEFECT_STATUS = New) before 6 months; Exclude Primary Decision Body = 'SMG Committee'

How do I take the expression 'Closed/Created w/i 6 months' and modify it to show when opened(min DEFECT_START_DATE of DEFECT_STATUS = New) before 6 months?

TIA!

[sunny_talwar]

What would the expected number you are looking to get?

[cbaqir]

~419 give or take a few

[sunny_talwar]

Can you provide a single Defect_ID which you know meet the criteria?

[cbaqir]

3468

[sunny_talwar]

This got me to 390

='Closed w/i 6 months; Created >6 months: (Expected: ~419): ' &  Count({$<PRIMARY_DECISION_BODY-={'SMG Committee'},DEFECT_ID =

{"=Min({<DEFECT_STATUS={'New'}>}DEFECT_STATUS_START_DATE) < AddMonths(Today(),-6) and Max({<CUR_STATUS={'Closed'}>}DEFECT_STATUS_START_DATE) >= AddMonths(Today(),-6)"}>} DISTINCT DEFECT_ID)

[cbaqir]

Thanks, let me check it out

[sunny_talwar]

Sure thing