Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There
How to use following set analysis at script level?
=count({<ClaimStatus= {"Closed"} >} ID)
Thanks .
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))
@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.
@ashishp Could you please attach the sample data so that I can work on it and let u know.
@sidhiq91 Data added.