Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
What would the expected number you are looking to get?
~419 give or take a few
Can you provide a single Defect_ID which you know meet the criteria?
3468
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)
Thanks, let me check it out
Sure thing