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!

[Anil_Babu_Samineni]

Your expression this?

count({<STATUS_CD={13}>} OP)/count(CLAIM_NO)

Note - How you want to show bucket. Can you explain little more

[tresesco · Accepted solution]

May be like:

Class(Aggr(count({<STATUS_CD={13}>}OP)/count(CLAIM_NO), YourDimension), 0.2)

[arpitkharkia]

so this is formula to calculate HR. The result will be in percentage so i want to have buckets of percent and show how many case falls in each of the bucket. so how many cases are there for my HR in 0-20% and so on.

[arpitkharkia]

You want me to this in the front end as calculated dimension or through resident load in the script?

[tresesco]

Front-end?

[arpitkharkia]

Sorry if there is any confusion. So i have to use it in the script right?

[tresesco]

You CAN do it in front-end itself.

[arpitkharkia]

its working just fine. Thanks a lot. One more thing i want to label the different classes accordingly. How can i do that?

[tresesco]

You can probably do so using string manipulation functions. Try to share a sample explaining your expected output, may be I could help better.