https://app.powerbi.com/groups/me/apps/688149d8-19d3-4e2c-8ffa-3eab914eaa50/reports/e1cd6f81-857d-44c8-a5ac-2b60c1d18431/ReportSection?ctid=91347cb6-c2b2-44ed-bc6d-9d72e3337f8b 

The Rolling pass/fail rate report shows the pass/fail rate by Batch ID. One can filter on Batch ID, Created Date, Product ID, and Batch Status. The Released percentage card is calculated by the number of batches released out of total number of unique batches. The Rejected percentage card is calculated by the number of batches Rejected out of total number of   unique Batches. The pie chart shows the count of Batch ID by Batch Status. 

The data is refreshed once daily at 11pm central time. 

The report is connected to “BPW_Datamarts” from BPW server. Three tables are imported: V_LV_SampleTestResult, V_LV_Product, and V_LV_Batch.