Help > Views > V_ThroughputOverallCurrHour

View: V_ThroughputOverallCurrHour

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

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

SQL Script

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

Uses

V_SumDurationCurrentHour

The available tables

The available views