Rename Class and Specify Buckets

[cbaqir]

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:

1. Hardcode the PROCESS_STEP selections so the user does not need to select them from the list box. I will have several versions of this graph with different selections to be used in an Nprinting export.
2. I would think 0-1, 2-3, 4-5, 6 or more or whatever a frequency distribution suggests. Or, maybe 0, and 1 should be broken out separately. . . . and then the other categories.
3. If possible, rename the 0-1 bucket to Low Complexity, rename 2-3 to Medium etc

Any suggestions?

Thanks in advance!

stalwar1

[sunny_talwar]

Not sure but all three charts show the same numbers... can you check if it works for you?

[cbaqir]

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?

[sunny_talwar]

They don't have to.... the above charts are showing without selections... but my question is why they all show the same exact value?

[cbaqir]

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.

????

[sunny_talwar]

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.

[cbaqir]

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)

[cbaqir]

Did you see I responded to your last question?

[sunny_talwar · Accepted solution]

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

[cbaqir]

Thanks again

[cbaqir]

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))