data

[sagarrahul]

hiiiii

want a help in this .

this is my table .

CLM_XGEN_CLAIM_NUM           Black List Code

RC-HS15-10334760                              H26.9

RC-HS15-10335711                              H26.9

RC-HS15-10341139                              H26.9

RC-HS15-10343361                              H26.9

RC-HS15-10336529                              H25.9

RC-HS15-10336520                              H26.9

RC-HS15-10337526                              H26.9

  -

RR-HS15-10336940                              R57.2

RR-HS15-10341978 -

  -

RC-HS15-10333637                              N18.4

RR-HS15-10341246                              N18.9

  -

RC-HS15-10331178                              R50.9

RR-HS15-10336696                              N85.2

RC-HS15-10343151                              S52.9

RC-HS15-10333670                              G40.6

RR-HS15-10341978                              G40.6

RR-HS15-10339968                              S52.9

RC-HS15-10330851                              A01.0

RC-HS15-10344631                              S83.5

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

1) in this i want total count of CLM_XGEN_CLAIM_NUM  and  total count individual Black List Code

2) after geting "point 1" it should divide "CLM_XGEN_CLAIM_NUM / total count individual Black List Code"

3) after diving then if the values goes >=0.7 then is should show as "OUTLIER" othervise "NOT OUTLIER".

"help me in Expression "

hope u got what i want .

so please help me in this as soon as possible .

for example :

  CLM_XGEN_CLAIM_NUM                     Black List Code                     value                     status

  RC-HS15-10334760                                         H26.9

  RC-HS15-10335711                                         H26.9

  RC-HS15-10341139                                         H26.9

  RC-HS15-10343361                                         H26.9

  RC-HS15-10336529                                         H25.9

  RC-HS15-10336520                                         H26.9

  RC-HS15-10337526                                         H26.9

total                    7                                                   7                                   1                     OUTLIER

[PrashantSangle]

Hi,

Try below expression in straight table

For Total Claim No

     >Count(TOTAL CLAIM_NO)

For Black List Code

     >Sum(aggr(Count(CLAIM_NO),BLACK_CODE))

For Status

     >

IF(Sum(aggr(Count(CLAIM_NO),BLACK_CODE))

/

Count(TOTAL CLAIM_NO)>=0.7,'OUTLIER',' NOT OUTLIER')

Regards

[sagarrahul]

bro its not working

[PrashantSangle]

What issue you are getting??

It is working in my machine.

Script

Table:

LOAD * INLINE [

   CLAIM_NO, BLACK_CODE

    RC-HS15-10334760,H26.9

RC-HS15-10335711,H26.9

RC-HS15-10341139,H26.9

RC-HS15-10343361,H26.9

RC-HS15-10336529,H26.9

RC-HS15-10336520,H26.9

RC-HS15-10337526,H26.9

RC-HS15-10333637,N18.4

RR-HS15-10341246,N18.9

];

Designer:

Straight Table

Dimension:

Claim No

Black Code

Expression

For Total Claim No

     >Count(TOTAL CLAIM_NO)

For Black List Code

     >Sum(Total<BLACK_CODE> aggr(Count(CLAIM_NO),BLACK_CODE))

For Status

     >

IF(Sum(Total<BLACK_CODE> aggr(Count(CLAIM_NO),BLACK_CODE))

/

Count(TOTAL CLAIM_NO)>=0.7,'OUTLIER',' NOT OUTLIER')

Regards

[PrashantSangle]

Hi,

Is this not satisfied your requirement???

Regards,

[sagarrahul]

no bro

but thanks for ur help an time

y .

[susovan]

Check this,

[sagarrahul]

yes i want this

[susovan]

Hi,

Its better than before.

[sagarrahul]

yes it is better but how to do it susovan ghosh

can u help me in this

[susovan]

Hi Sagar,

First of all active the design grid option from view,

than right click of chart -> select "Custom format cell" than choose the column and change the text colour.