Help > Views > V_ThroughputOverall

View: V_ThroughputOverall

This view summarizes the processing time (from check-out to check-in) and calculates total performance.

Column	Description
SumDurationHours	How many hours the documents were checked out. (The sum of SumDurationHours in V_SumDuration.)
DocumentCount	The number of documents for all service types (the sum of DocumentCount in V_SumDuration).
ThroughputHours	The number of documents for all service types, divided by the total number of hours during which the documents were checked out. (The sum of DocumentCount divided by the sum of SumDurationHours in V_SumDuration).

SQL Script

CREATE VIEW [dbo].[V_ThroughputOverall]
AS
SELECT   SUM(SumDurationHours) AS SumDurationHours, SUM(DocumentCount) AS DocumentCount, SUM(DocumentCount)
	           / SUM(SumDurationHours) AS ThroughputHours
FROM     dbo.V_SumDuration

Uses

V_SumDuration

The available tables

The available views