Hi,
I'm trying to calculate % right first time to remove exceptions ie where some "discrepancies" are right first time (RFT) and other classed as not RFT. However, I wish to include the data points from those which are deemed RFT in the overall calculation.
This calculation works but doesn't allow me to exclude certain datapoints:
1-
COUNT (DISTINCT CASE
WHEN `HOLD_NAME` IN ('Incomplete Info' ,'PO – INVOICE HOLD', 'PENDING PO OVERRIDE' , 'CREDIT HOLD- INVOICE HOLD','CCCL Info Incomplete')
OR HOLD_NAME
like '%Discrepancy%'
OR `RETURNCODE` is not null
THEN `Study Number` END) / COUNT(DISTINCT `Study Number`)
Examples being Discrepancy 121901 / 121325 and 121275 are all RFT but all other discrepancies are wrong.
Is it possible to do this in the same beastmode?
If I filter them out it reduces the overall number and skews the final %.
I tried the below but it returned a 0% RFT which isn''t right.
1-
COUNT (DISTINCT CASE
WHEN `HOLD_NAME`<>'Discrepancy 121901'
OR `HOLD_NAME`<> 'Discrepancy 121275'
OR `HOLD_NAME`<> 'Discrepancy 121325'
OR `HOLD_NAME`<> 'Discrepancy 121566'
OR `HOLD_NAME` IN ('Incomplete Info' ,'PO – INVOICE HOLD', 'PENDING PO OVERRIDE' , 'CREDIT HOLD- INVOICE HOLD','CCCL Info Incomplete')
OR `HOLD_NAME`like '%Discrepancy%'
OR `RETURNCODE` is not null
THEN `Study Number` END) / COUNT(DISTINCT `Study Number`)