Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Check attached
Check attached
Thank you!
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))