KPIs - Cases Closed By Customer And Category For the period: [STARTDATE1] to [ENDDATE1]
true false SELECT DISTINCT TOP 100 PERCENT dbo.tbl_Calls.CompanyName, COUNT(dbo.tbl_Calls.CallID) AS TheCount FROM dbo.tbl_Calls WHERE (dbo.tbl_Calls.QueueID = [PARAM1]) AND (dbo.tbl_Calls.CallStatusID = 3) AND (dbo.tbl_Calls.Closed BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM') GROUP BY dbo.tbl_Calls.CompanyName ORDER BY dbo.tbl_Calls.CompanyName true Customer # Cases SELECT DISTINCT TOP 100 PERCENT dbo.tbl_Calls.CompanyName, dbo.tbl_Groups.GroupName, COUNT(dbo.tbl_Calls.CallID) AS TheCount FROM dbo.tbl_Calls LEFT OUTER JOIN dbo.tbl_Groups ON dbo.tbl_Calls.GroupID = dbo.tbl_Groups.GroupID WHERE (dbo.tbl_Calls.QueueID = [PARAM1]) AND (dbo.tbl_Calls.CallStatusID = 3) AND (dbo.tbl_Calls.Closed BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM') GROUP BY dbo.tbl_Calls.CompanyName, dbo.tbl_Groups.GroupName ORDER BY dbo.tbl_Calls.CompanyName false Customer Category # Cases SELECT TOP 100 PERCENT dbo.tbl_Calls.CallID, dbo.tbl_Calls.CompanyName, dbo.tbl_Groups.GroupName, dbo.tbl_PrimaryKeys.PrimaryKey, dbo.tbl_SecondaryKeys.SecondaryKey, dbo.tbl_TertiaryKeys.TertiaryKey, dbo.tbl_Calls.Computer FROM dbo.tbl_Calls LEFT OUTER JOIN dbo.tbl_Groups ON dbo.tbl_Calls.GroupID = dbo.tbl_Groups.GroupID LEFT OUTER JOIN dbo.tbl_TertiaryKeys ON dbo.tbl_Calls.Key3 = dbo.tbl_TertiaryKeys.TertiaryKeyID LEFT OUTER JOIN dbo.tbl_SecondaryKeys ON dbo.tbl_Calls.Key2 = dbo.tbl_SecondaryKeys.SecondaryKeyID LEFT OUTER JOIN dbo.tbl_PrimaryKeys ON dbo.tbl_Calls.Key1 = dbo.tbl_PrimaryKeys.PrimaryKeyID WHERE (dbo.tbl_Calls.QueueID = [PARAM1]) AND (dbo.tbl_Calls.CallStatusID = 3) AND (dbo.tbl_Calls.Closed BETWEEN '[STARTDATE1] 00:00:00 AM' AND '[ENDDATE1] 11:59:59 PM') ORDER BY dbo.tbl_Calls.CompanyName, dbo.tbl_Groups.GroupName, dbo.tbl_PrimaryKeys.PrimaryKey, dbo.tbl_SecondaryKeys.SecondaryKey, dbo.tbl_TertiaryKeys.TertiaryKey false Case # Primary Company Category Category 1 Category 2 Category 3 Primary SLA