Formula as dimension

[arpitkharkia]

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!

[arpitkharkia]

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.

[tresesco]

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

[arpitkharkia]

Hey Tresesco

Can i use this calculated dimension for some actions to be assigned to text boxes?

[tresesco]

Check my reply here: Selection of calculated dimension