Set Analysis at script level

[ashishp]

Hi There 

How to use following set analysis at script level? 

=count({<ClaimStatus= {"Closed"} >} ID) 

Thanks . 

[ashishp]

Want to move all following at script level. 

$OpenedClaims= Count({<claimCreatedDt ={">=$(=Min(DateRange))"}*{"<=$(=Max(DateRange))"}>} distinct claimID)
$ClosedClaims= Count({<claimCloseDt ={">=$(=Min(DateRange))"}*{"<=$(=Max(DateRange))"}>} distinct claimID)

between days=Interval((claimCloseDt-claimCreatedDt),'DD') as betweendays
Total calims= Count(distinct(claimID))
End to End Life cycle= betweendays/count(claimID)

CLAIM_STATUS_OPEN=Count({<ClaimStatus={'CLAIM_STATUS_OPEN'}>} distinct claimID)
CLAIM_STATUS_CLOSED=Count({<claimStatusCd={'CLAIM_STATUS_CLOSED'}>}DISTINCT claimID)

Close ratio = Count({<ClaimStatus={'CLAIM_STATUS_CLOSED'}>}DISTINCT claimID)/COUNT(DISTINCT(claimID))
Open ratio = Count({<ClaimStatus={'CLAIM_STATUS_OPEN'}>}DISTINCT claimID)/COUNT(DISTINCT(claimID))

[sidhiq91]

@ashishp  It will be as below.

Load

Count(ID)

from table_name 

where  ClaimStatus= 'Closed';

Please like and accept as solution if it has resolved your issue.

[sidhiq91]

@ashishp  Could you please attach the sample data so that I can work on it and let u know.

[ashishp]

@sidhiq91  Data added.