Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following expression in the front end:
count({<STATUS_CD=13>}OP)/count(CLAIM_NO)
I need the output of the above expression to be bucketized into 5 buckets of 20% each. Then i have to use that dimension in a chart. I tried using a variable but not able to apply.
Help appreciated!
0 <= x <0.2 |
0.2 <= x <0.4 |
0.4 <= x <0.6 |
0.6 <= x <0.8 |
0.8 <= x <1 |
1 <= x <1.2 |
I got above from the class definition.
i want the following:
0-20% |
20-40% |
40-60% |
60-80% |
80%-100% |
I want the last 2 to be clubbed to 80-100%. Is it possible? I tried using if while creating dimension.
Since this class number is limited, you could try like:
vExpression=Aggr(count({<STATUS_CD={13}>}OP)/count(CLAIM_NO), YourDimension) // '=' symbol might not be required before variable definition
If( (vExpression)>0.8, '>80% and above' ,
If( (vExpression)>0.6, '>60-80%' ,
If ( (vExpression)>0.4, '>40-20%',
if( (vExpression)>0.2, '>20-40%', '<=20%' ))))
Hey Tresesco
Can i use this calculated dimension for some actions to be assigned to text boxes?
Check my reply here: Selection of calculated dimension