Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Right now I am using the following Dimension for my interval buckets:
=replace(aggr(Class(count(GOV_DECISION_BODY_SUB),2), DEFECT_ID), '<= x <','-')
What I am trying to accomplish is 3 things:
Any suggestions?
Thanks in advance!
Not sure but all three charts show the same numbers... can you check if it works for you?
That's why I'm confused. If the selections are hard-coded, why does the user still need to make the PROCESS_STEP Selections and why would it change the hardcoded values?
They don't have to.... the above charts are showing without selections... but my question is why they all show the same exact value?
They shouldn't. For some reason the Avg # days charts seem to work hardcoded but upon further inspection, they show different results if all selections are cleared vs the selected PROCESS_STEPS.
????
Which object are you looking at? The charts on the attached app neither have the dimension that I proposed, not does it have the expression I proposed.
Are you using the attached qvw?
=Aggr(
If(Count(GOV_DECISION_BODY_SUB) = 0, Dual(0, 0),
If(Count(GOV_DECISION_BODY_SUB) = 1, Dual(1, 1),
If(Count(GOV_DECISION_BODY_SUB) < 4, Dual('2-3', 2),
If(Count(GOV_DECISION_BODY_SUB) < 6, Dual('4-5', 4), Dual('6 or more', 6))))),
DEFECT_ID)
Did you see I responded to your last question?
I updated your dimension to this
=Aggr(
If(Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}GOV_DECISION_BODY_SUB) = 0, Dual(0, 0),
If(Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}GOV_DECISION_BODY_SUB) = 1, Dual(1, 1),
If(Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}GOV_DECISION_BODY_SUB) < 4, Dual('2-3', 2),
If(Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}GOV_DECISION_BODY_SUB) < 6, Dual('4-5', 4), Dual('6 or more', 6))))),
DEFECT_ID)
And expression to this
Count({$<
MONTH_1 = {"$(='>=' & Date(MonthStart(Max({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}MONTH_1), -11), 'MM-YY') & '<' & Date(MonthStart(Max({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}>}MONTH_1), 1), 'MM-YY'))"},
// DEFECT_ID = {"=Count({<PROCESS_STEP = {'Submitted to Routing', 'Routed'}, IS_IN_PROD = {'Y'}>}PROCESS_STEP) = GetSelectedCount(PROCESS_STEP)"},
PROCESS_STEP = {'Submitted to Routing', 'Routed'},
IS_IN_PROD = {'Y'}>} DISTINCT DEFECT_ID)
Did you look at this qvw? Attaching again
Thanks again
The only question I have left would be about the expression for the other graphs for Avg Days. The current expression is:
sum({$<
PROCESS_STEP = {'Submitted to Routing', 'Routed'},
IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(MonthStart(Max(MONTH_1), -11), 'MM-YY') & '<' & Date(MonthStart(Max(MONTH_1), 1), 'MM-YY'))"}>}
Aggr(Max({$<
PROCESS_STEP = {'Submitted to Routing', 'Routed'},
IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(MonthStart(Max(MONTH_1), -11), 'MM-YY') & '<' & Date(MonthStart(Max(MONTH_1), 1), 'MM-YY'))"}>}
PROCESS_STEP_START_DATE) -
Min({$<
PROCESS_STEP = {'Submitted to Routing', 'Routed'},
IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(MonthStart(Max(MONTH_1), -11), 'MM-YY') & '<' & Date(MonthStart(Max(MONTH_1), 1), 'MM-YY'))"}>}
PROCESS_STEP_START_DATE)
, DEFECT_ID))/
(Count({$<
PROCESS_STEP = {'Submitted to Routing', 'Routed'},
IS_IN_PROD = {'Y'},
MONTH_1 = {"$(='>=' & Date(MonthStart(Max(MONTH_1), -11), 'MM-YY') & '<' & Date(MonthStart(Max(MONTH_1), 1), 'MM-YY'))"}>} DISTINCT
DEFECT_ID))