If statement and set Analysis Dimension

[cbaqir]

TECHNICAL SPECS
  ART Volume by Week Submitted to ART = aggr(max( {$<COM_CAT={'ART - AMB Refinement Team'}>}WeekStart(COM_CAT_START_DATE)),DEFECT_ID)
Only show tickets that hit COM_CAT={'ART - AMB Refinement Team'} 2+ times and where the min(COM_CAT_START_DATE) to COM_CAT={'ART - AMB Refinement Team' was after 11/2/18
Distinct count of DEFECT_ID

This doesn't seem to work:

=if(COM_CAT_START_DATE>'11/02/2018'
and aggr(count({$<COM_CAT={'ART - AMB Refinement Team'}>}COM_CAT),DEFECT_ID)>=2,
aggr(max( {$<COM_CAT={'ART - AMB Refinement Team'}>}WeekStart(COM_CAT_START_DATE)),DEFECT_ID))

[jyothish8807]

Hi Cbaqirdhds,

Please try like this.

=if(count(total <DEFECT_ID>{<COM_CAT={'ART - AMB Refinement Team'},COM_CAT_START_DATE=  {'>11/02/2018'}>} COM_CAT)>=2,
weekstart(max( total <DEFECT_ID>COM_CAT_START_DATE))))

[cbaqir]

Thanks but that doesn't seem to work. I get an error and then repeating DEFECT_IDs.