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