Hard coded Syntax not working

[cbaqir]

The top left chart should not need to have the PROCESS_STEPs of Submitted to Routing and Routed selected to show the correct numbers. I tried to hardcode it in the expression but I guess I didn't do it correctly.

I will export this to NPrinting so I don't want it to be dependent on list box selections.

[sunny_talwar · Accepted solution]

Check attached

[cbaqir]

Thank you!

[cbaqir]

Sunny,

I am trying to make this chart be a rolling 3 months and I am having trouble with the syntax.

Do you see the issue?

sum({$<
PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'},
//IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), -3), 'MM-YY')) & '<' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), 0), 'MM-YY')))"}>}
Aggr(Max({$<
PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'},
//IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), -3), 'MM-YY')) & '<' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), 0), 'MM-YY')))"}>}
PROCESS_STEP_START_DATE) -
Min({$<
PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'},
//IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), -3), 'MM-YY')) & '<' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), 0), 'MM-YY')))"}>}
PROCESS_STEP_START_DATE)
, DEFECT_ID))/
(Count({$<
PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'},
//IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), -3), 'MM-YY')) & '<' & Date(addmonths(MonthStart(Max({<PROCESS_STEP = {'Routed','Fully Approved (Moved to resourcing)'}>}MONTH_1), 0), 'MM-YY')))"}>} DISTINCT
DEFECT_ID))