4.13 Disposition Code Distribution Report:
- Dataset Report_DispositionCodesDistribution, new fields:
- DispositionCodeCategory
- DispositionCodeSubCategory
- Parameter: @ShowCategoryDetails:
- Default = False - the report will display only showing the Disposition Code value
= True - the report would display both the Disposition Category Name and Disposition Sub-Category Name
Format = Category Name > Sub Category Name > Disposition Code
- Default = False - the report will display only showing the Disposition Code value
- Parameter: @HandledByAgentOnly:
- Default = False - the report will display with current denominator in % calculation of Total Handled Interactions
= True - the percentage denominator would change from "Total Handled Interactions" to "Non-Campaign Handled by Agent".
- Default = False - the report will display with current denominator in % calculation of Total Handled Interactions
LOGIC CHANGES:
4.13 Disposition Code Distribution Report:
- procedures changed:
- DW.spRpt_DispositionCodesDistribution
- DW.spRpt_CampaignInspection_SubDs1
- Disposition Code Name -> Disposition Category Name > Disposition Sub-Category Name > Disposition Code Name:
- Previous:
- Count(F_Interactions.InteractionID)
(grouping be each F_Interactions.Disposition Code)
- Count(F_Interactions.InteractionID)
- Current:
- Count(F_Interactions.InteractionID)
if @ShowCategoryDetails = false
(grouping by each F_Interactions.Disposition Code)
if @ShowCategoryDetails = true
(grouping by F_Interactions.DispositionCodeCategory,
F_Interactions.DispositionCodeSubCategory,
F_Interactions.Disposition Code)
- Count(F_Interactions.InteractionID)
- Previous:
- % Interactions by Disposition Code:
- Previous:
[Disposition Code Name]/[Total Handled Interactions] - Current:
if @HandledByAgentOnly = false
[Disposition Code Name]/[Total Handled Interactions]
if @HandledByAgentOnly = true
[Disposition Code Name]/[Non-Campaign Handled by Agent]
- Previous:
6.03 Campaign Inspection Report:
- procedures changed:
- DW.spRpt_CampaignInspection
- DW.spRpt_CampaignInspection_SubDs1
- Successfully Handled By Agent:
- Previous:
- Count (F_Campaigns.CampaignInteractionID)
F_Campaigns.LastInteractionState = ''Handled''
AND F_Campaigns.NumberOfAttempts = 1
AND F_Campaigns.AgentID is not null
- Count (F_Campaigns.CampaignInteractionID)
- Current:
- Count (F_Campaigns.CampaignInteractionID)
last F_InteractionSegments.InteractionState = ''Handled''
AND F_InteractionSegments.AgentID is not null
- Count (F_Campaigns.CampaignInteractionID)
- Previous:
- Successfully Handled By BP:
- Previous:
- Count (F_Campaigns.CampaignInteractionID)
F_Campaigns.LastInteractionState = ''Handled''
AND F_Campaigns.NumberOfAttempts = 1
AND F_Campaigns.AgentID is null
AND F_Campaigns.BusinessProcessId is not null
- Count (F_Campaigns.CampaignInteractionID)
- Current:
- Count (F_Campaigns.CampaignInteractionID)
last F_InteractionSegments.InteractionState = ''Handled''
AND F_InteractionSegments.AgentID is null
AND F_InteractionSegments.BusinessProcessId is not null
- Count (F_Campaigns.CampaignInteractionID)
- Previous: