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!
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
You can try using Valuelist for the replacement of the dimension values.
Never used that before. Syntax example?
I understand the 1st requirement, but 2 and 3 looks similar, but I am not sure what is really needed... do you need names for those groupings (Point 3) or do you need some very specific grouping (Point 2)
ValueList() – For those tricky situations
The above post will explain that.
It's used to create synthetic dimensions. Basically, dimensions that don't exist in the data model.
2 is stratify the buckets not by every 2, but by 0,1,2-3,4-5,6+
3 is to rename those buckets 0 = Very Low, 1 = Low, 2-3 = Medium etc
Do you need two different views? 1 for 2 and 1 for 3 or 2 is a step in process to get to 3?
one view. 2 is a step to get to 3 and 3 is not required - but would be a nice to have if possible. 1 and 2 are more important.
Check attached
So you would need 8 charts, one for each PROCESS_STEP?