Issue with developing analyses for requisition to purchase order cycle time

Summary:

We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identify which all requisitions have been fully converted into purchase orders

Content (required):

We have created a new analyses and tried to calculate the PR to PO cycle time. However for some particular requisitions which had multiple lines but not all lines were converted into purchase orders, we need to remove such requisitions from the calculation. We couldn't find any attribute to achieve the same. The purchase requisition status shows as "approved" even if some lines in the requisition is still not converted to purchase orders. We need find a way in which we can filter out only those particular requisitions for which all the lines have been fully converted into purchase