X Report Datasets

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Agents

List of agents using a delimiter '|'

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

N

TimeZone

TimeZone name, is preffered option than @Offset

N

ShiftID

Shift ID

F_AgentLife.ShiftId

ShiftID

AgentName

Agent Name

F_AgentLife.AgentId → D_Agent.AgentId

AgentName

AgentLoginTime

Shift Login Time

min(F_AgentLife.StartTime)

AgentLoginTime

AgentLogoffTime

Shift Logout Time

max(F_AgentLife.EndTime)

AgentLogoffTime

ShiftLoginTime

Total Login Time

[Shift Logout Time] - [Shift Login Time]

ShiftLoginTime

StatusName

Agent Mode

F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId

StatusName

StartTime

Start Time

F_AgentLife.StartTime

StartTime

EndTime

End Time

F_AgentLife.EndTime

EndTime

TimeInStatus

Time In Mode

[End Time] - [Start Time]

TimeInStatus

DirectionName

Direction

F_AgentLife.InteractionId → F_Interactions.InteractionId → F_Interactions.DirectionId → D_Direction.DirectionId

Direction

InteractionMediaName

Media Type

F_AgentLife.InteractionId → F_Interactions.InteractionId → F_Interactions.InteractionMediaId → D_InteractionMediaId

MediaType

ExternalTransferDID

External Transfer DID

F_AgentLife.InteractionId → F_Interactions.InteractionId → F_Interactions.ExternalTransferDID

ExternalTransferDID

InteractionStateName

Interaction State

F_AgentLife.InteractionStateId → D_InteractionState.

InteractionStateName

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Agents

List of agents using a delimiter '|'

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Counters

List of counters using a delimiter '|'

Y

Checkbox

Include Archive data

Y

Severity

out-dated parameter, pass 0

Y

DWDBName

DW DB Name

N

SeverityStr

Alert severity, list of possible values

N

TimeZone

TimeZone name, is preffered option than @Offset

N

Seq Number

No2

CounterTypeName

Counter

F_Alerts.CounterTypeId → D_CounterType.CounterTypeId

CounterTypeName2

AgentName

Agent Name

F_Alerts.AgentId → D_Agent.AgentId 

AgentName2

Value

Counter Value

can be in different format, depends on CounterType:

0 - integer

2 - datetime

other cases - percents

F_Alerts.Value

Value2

Alert

Alert Type - is not used in the report directly

F_Alerts.AlertTypeId

AlertID

Alert ID - is used in the graph

F_Alerts.AlertId

Duration

Duration in seconds

F_Alerts.EndTime - F_Alerts.StartTime

Duration2

CounterType

Counter Type - is not used in the report directly

F_Alerts.ValueType

StartTime

Alert Start Time

F_Alerts.StartTime

StartTime2

EndTime

Alert End Time

F_Alerts.EndTime

EndTime2

AlertTypeName

Severity

F_Alerts.AlertTypeId - D_AlertType.AlertTypeId 

Severity2

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

AgentName

List of agents using a delimiter '|'

Y

TransferType

Type of transferring

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

N

TimeZone

TimeZone name, is preffered option than @Offset

N

If F_Interactions.ExternalTransferDID is empty (null or '') then "Internal"

else "External"

DWDBName

DW DB Name

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Agents

List of agents using a delimiter '|'

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Checkbox

Include Archive data

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

AgentId

Agent ID

F_AgentLife.AgentId

AgentName

Agent Name

F_AgentLife.AgentId → D_Agent.AgentId

AgentName

StartTime

Break start time

F_AgentLife.StartTime

StartTime

EndTime

Break end time

F_AgentLife.EndTime

BreakTime

Duration

F_AgentLife.EndTime - F_AgentLife.StartTime

Duration

BreakTypeName

Type

F_AgentLife.BreakTypeId → D_BreakType.BreakTypeId

BreakTypeName

Category

Category

F_AgentLife.BreakCategoryTypeID→ D_BreakCategoryType.BreakCategoryTypeID

Category

RequestTime

Time of a request

F_AgentLife.RequestTime

SupervisorDecisionTime

Time of a decision

F_AgentLife.SuperVisorDecisionTime

Supervisor

Supervisor name

F_AgentLife.SupervisorID → D_Agent.AgentId

Paid

Paid or non-paid

F_AgentLife.Paid

Paid

ExceededSeconds

Exceeded time in seconds

F_AgentLife.ExceededSeconds

ExceededSeconds

countDays

count of days in specified period

DateDiff(Day, F_AgentLife.StartTime, F_AgentLife.EndTime)

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartDate

Start of selected period

Y

EndDate

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

AgentName

List of agents using a delimiter '|'

Y

BPName

List of business processes using a delimiter '|'

Y

MediaName

List of media types using a delimiter '|'

Y

IncludeArchivedData

Include Archive data

Y

DWDBName

DW DB Name

N

InteractionType

List of interaction types using a delimiter '|'

N

TimeZone

TimeZone name, is preffered option than @Offset

N

AgentName

Agent Name

F_InteractionSegments.StartTime (where InteractionState = 'AgentSelecting')

-

F_InteractionSegments.StartTime (where InteractionState = 'Rejected')

DW_DBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

BusinessProcessName

List of business processes using a delimiter '|'

Y

InteractionType

List of interaction types using a delimiter '|'

Y

ShowOption

Show tables (All tables / Day/Hour interval / Year/Month/week/Day intervals)

Y

MediaType

List of media types using a delimiter '|'

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Total / Detail

Period for a grouping

distinct F_AgentLife.AgentId in a specific subslice

where F_AgentLife.AgentStatus <> 'Offline'

distinct F_AgentLife.AgentId in a specific subslice

where F_AgentLife.AgentStatus in ('Ready', 'Busy')

[Busy time] / [Available time]

where:

Busy Time - duration in next statuses: 

'Busy','Dialing', 'WaitingForOffline', 'WaitingForBreak', 'WaitingForBackofficeAdministrative', 'WaitingForHandlingOutgoingInteractions'

Available time - duration in next statuses:

'Busy', 'Dialing', 'WaitingForOffline', 'WaitingForBreak', 'WaitingForBackofficeAdministrative', 'WaitingForHandlingOutgoingInteractions', 'Ready', 'Offered'

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Agents

List of agents using a delimiter '|'

Y

BusinessProcessName

List of business processes using a delimiter '|'

Y

InteractionType

List of interaction types using a delimiter '|'

Y

TransferredOnly

Transferred Interactions Only

Y

DirectionName

List of directions using a delimiter '|'

Y

DispositionCode

List of disposition codes using a delimiter '|'

Y

GroupBy

Group by Interaction/Destination/DispositionCode

Y

Checkbox

Include Archive data

Y

MediaType

List of media types using a delimiter '|'

Y

Demands

List of demands using a delimiter '|'

Y

DWDBName

DW DB Name

N

TimeZone

TimeZone name, is preffered option than @Offset

N

ClientName

List of client names using a delimiter '|'

N

InboundCampaignName

List of campaign names using a delimiter '|'

N

ProductName

List of products using a delimiter '|'

N

ProductType

List of product types using a delimiter '|'

N

HoldTime

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

DWDBName

DW DB Name

N

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Agents

List of agents using a delimiter '|'

Y

MainTableAccumulatedBy

Main Table Accumulated by, Int value: 1 - Hour, 2 - Day, 3- Week, 4 - Month, 5 - Quarter, 6 - Year

Y

Checkbox

Include Archive data

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

AgentName

Agent Name

F_AgentLife.AgentId → D_Agent.AgentId

AgentName

DateAggr

Main TimeSlice

F_AgentLife.StartTimeSliceId → D_TimeSlice.TimeSliceId

MainTimeSlice

TotalAnswered

Total count of interactions answered by agent

count(F_Interactions.InteractionId)

TotalLoginTime

Total Login Time

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

TotalLoginTime

TotalReadyTime

Total Ready Time

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

TotalReadyTime

TotalNotReadyTime

Total Not Ready Time

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

TotalNotReadyTime

TotalHandlingTime

Total Handling Time

F_InteractionSegments.TalkTime + F_Interactions.WrapUpTime

TotalHandlingTime

[TotalHandlingTime] / [TotalAnswered]

AverageHandlingTime

TotalBusyTime

Total Busy Time

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

TotalBusyTime

TotalNoAnswerTime

Total No Answer Time

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

TotalNoAnswerTime

TotalBreakTime

Total Break Time

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

TotalBreakTime

TotalHandlingOutgoingTime

Total Handling Outgoing Interactions time

F_InteractionSegments.TalkTime + F_Interactions.WrapUpTime

TotalHandlingOutgoingInteractions

TotalBackOfficeTime

Total Backoffice Time

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

TotalBackOfficeTime

[TotalBusyTime] / [TotalLoginTime]

BusyToLoginTimeRatio

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

DWDBName

DW DB Name

N

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Agents

List of agents using a delimiter '|'

Y

BusinessProcessName

List of business processes using a delimiter '|'

Y

MainTableAccumulatedBy

Main Table Accumulated by, Int value: 1 - Hour, 2 - Day, 3- Week, 4 - Month, 5 - Quarter, 6 - Year

Y

InteractionType

List of interaction types using a delimiter '|'

Y

Checkbox

Include Archive data

Y

SubTableAccumulatedBy

Sub Table Accumulated by, Int value: 0 - 15 minutes, 1 - Hour

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Agent Name

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Ready'

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName <> 'Ready'

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Busy'

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'No Answer'

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Break'

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Backoffice - Administrative'

DWDBName

DW DB Name

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

AgentName

List of agents using a delimiter '|'

Y

MainTableAccumulatedBy

Main Table Accumulated by, Int value: 1 - Hour, 2 - Day, 3- Week, 4 - Month, 5 - Quarter, 6 - Year

Y

StartDateDelta

outdated, use 0 as default

Y

EndDateDelta

outdated, use 0 as default

Y

Checkbox

Include Archive data

Y

MediaType

List of media types using a delimiter '|'

Y

InteractionType

List of interaction types using a delimiter '|'

Y

BusinessProcess

List of agents using a delimiter '|'

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

DateAggr

Main TimeSlice

F_AgentLife.StartTimeSliceId → D_TimeSlice.TimeSliceId

MaintimeSlice

AgentName

Agent Name

F_InteractionSegments.AgentId → D_Agent.AgentId

AgentName

TotalAnswered

Total Incoming Queue

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

and F_InteractionSegments.AgentId <> -1

TotalAnswered

BusinessProcessAnswered

Total Handled (Incoming + Outgoing)

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

TotalHandled

BusinessProcessRejected

Business Process Rejected

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

BPRejected

TotalMissed

Total Missed

count(F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Rejected'

TotalMissed

TotalTransfer

Total Transferred

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.ExternalTransferDID is not null

or exists another record in F_InteractionSegments with the same F_InteractionSegments.InteractionId and another handler (agent - F_InteractionSegments.AgentId, bp - F_InteractionSegments.BusinessProcessId)

TotalTransferred

TotalConsult

Total Consult

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Consulting'

TotalConsult

TotalAnsweredAsConsult

Total Answered as Consult

[TotalAnswered] && [TotalConsult]

TotalAnsweredAsConsult

TotalOutgoingExternal

Total Outgoing External

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingExternal'

TotalOutgoingExternal

TotalOutgoingInternal

Total Outgoing Internal

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingInternal'

TotalOutgoingInternal

TotalOutgoingPrivate

Total Outgoing Private

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingInternal' or 'OutgoingInternal'

and F_InteractionSegments.AgentId is not null and not exists a record in F_InteractionSegments where (F_InteractionSegments.BusinessProcessId is not null or F_InteractionSegments.InteractionChannelId is not null)

TotalOutgoingPrivate

TotalIncomingPrivate

Total Incoming Private

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'Incoming'

and F_InteractionSegments.AgentId is not null and not exists a record in F_InteractionSegments where (F_InteractionSegments.BusinessProcessId is not null or F_InteractionSegments.InteractionChannelId is not null)

TotalIncomingPrivate

DWDBName

DW DB Name

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

AgentName

List of agents using a delimiter '|'

Y

InteractionType

List of interaction types using a delimiter '|'

Y

MainTableAccumulatedBy

Main Table Accumulated by, Int value: 1 - Hour, 2 - Day, 3- Week, 4 - Month, 5 - Quarter, 6 - Year

Y

BusinessProcess

List of agents using a delimiter '|'

Y

StartDateDelta

outdated, use 0 as default

Y

EndDateDelta

outdated, use 0 as default

Y

SubTableAccumulatedBy

Sub Table Accumulated by, Int value: 0 - 15 minutes, 1 - Hour

Y

Checkbox

Include Archive data

Y

MediaType

List of media types using a delimiter '|'

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

GroupedColumn

BP Name as a group field

F_InteractionSegments.BusinessProcessId → D_BusinessProcess.BusinessProcessId

AgentName

Agent Name

F_InteractionSegments.AgentId → D_Agent.AgentId

IsBusinessProcess

outdated

1 (true) as default

DateAggr

Sub TimeSlice

F_AgentLife.StartTimeSliceId → D_TimeSlice.TimeSliceId

TotalAnswered

Total Incoming Queue

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

and F_InteractionSegments.AgentId <> -1

MainDateAggr

Main TimeSlice

F_AgentLife.StartTimeSliceId → D_TimeSlice.TimeSliceId

BusinessProcessAnswered

Total Handled (Incoming + Outgoing)

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

BusinessProcessRejected

Business Process Rejected

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

TotalMissed

Total Missed

count(F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Rejected'

TotalTransfer

Total Transferred

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.ExternalTransferDID is not null

or exists another record in F_InteractionSegments with the same F_InteractionSegments.InteractionId and another handler (agent - F_InteractionSegments.AgentId, bp - F_InteractionSegments.BusinessProcessId)

TotalConsult

Total Consult

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Consulting'

TotalAnsweredAsConsult

Total Answered as Consult

[TotalAnswered] && [TotalConsult]

TotalOutgoingExternal

Total Outgoing External

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingExternal'

TotalOutgoingInternal

Total Outgoing Internal

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingInternal'

TotalOutgoingPrivate

Total Outgoing Private

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingInternal' or 'OutgoingInternal'

and F_InteractionSegments.AgentId is not null and not exists a record in F_InteractionSegments where (F_InteractionSegments.BusinessProcessId is not null or F_InteractionSegments.InteractionChannelId is not null)

TotalIncomingPrivate

Total Incoming Private

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'Incoming'

and F_InteractionSegments.AgentId is not null and not exists a record in F_InteractionSegments where (F_InteractionSegments.BusinessProcessId is not null or F_InteractionSegments.InteractionChannelId is not null)

DWDBName

DW DB Name

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

AgentName

List of agents using a delimiter '|'

Y

MainTableAccumulatedBy

Main Table Accumulated by, Int value: 1 - Hour, 2 - Day, 3- Week, 4 - Month, 5 - Quarter, 6 - Year

Y

StartDateDelta

outdated, use 0 as default

Y

EndDateDelta

outdated, use 0 as default

Y

Checkbox

Include Archive data

Y

MediaType

List of media types using a delimiter '|'

Y

InteractionType

List of interaction types using a delimiter '|'

Y

BusinessProcess

List of agents using a delimiter '|'

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Agent Name

Main TimeSlice

count(distinct F_InteractionSegments.InteractionId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

and F_InteractionSegments.AgentId <> -1

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Handling'

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Rejected'

where 

F_InteractionSegments.ExternalTransferDID is not null

or exists another record in F_InteractionSegments with the same F_InteractionSegments.InteractionId and another handler (agent - F_InteractionSegments.AgentId, bp - F_InteractionSegments.BusinessProcessId)

where 

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Consulting'

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingExternal'

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingInternal'

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingInternal' or 'OutgoingInternal'

and F_InteractionSegments.AgentId is not null and not exists a record in F_InteractionSegments where (F_InteractionSegments.BusinessProcessId is not null or F_InteractionSegments.InteractionChannelId is not null)

where 

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreation.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'Incoming'

and F_InteractionSegments.AgentId is not null and not exists a record in F_InteractionSegments where (F_InteractionSegments.BusinessProcessId is not null or F_InteractionSegments.InteractionChannelId is not null)

DWDBName

DW DB Name

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

BusinessProcessName

List of business processes using a delimiter '|'

Y

Agents

List of agents using a delimiter '|'

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

TimeSlice

Selected time interval: Hourly, 30 minutes, 15 minutes, Daily, Weekly, Monthly

Y

Archive

Include Archive data

Y

EmptyRows

Show empty rows

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Agent Name

where 

exists another record in F_InteractionSegments with the same F_InteractionSegments.InteractionId and another handler (agent - F_InteractionSegments.AgentId, bp - F_InteractionSegments.BusinessProcessId)

where 

ExternalTransferDID is not null

where F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionsState.InteractionStateName = 'Handling'

and F_InteractionSegments.AgentId <> -1

and F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'Incoming'

where F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionsState.InteractionStateName = 'Handling'

and F_InteractionSegments.AgentId <> -1

and F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'OutgoingExternal' or 'Campaign'

where F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionsState.InteractionStateName = 'Handling'

and F_InteractionSegments.AgentId <> -1

and F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName = 'Callback'

Voice

[Inbound] + [Outbound] + [Callback]

where F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId → D_InteractionMedia.InteractionMediaName = 'Telephony'

Voice

[Inbound] + [Outbound] + [Callback]

where F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId → D_InteractionMedia.InteractionMediaName = 'Chat'

[Inbound] + [Outbound] + [Callback]

where F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId → D_InteractionMedia.InteractionMediaName = 'Email'

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Ready' or 'Offered'

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Break'

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Busy' or 'Dialing' or 'WaitingFor%'

sum(F_InteractionSegments.TalkTime)

where F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId → D_InteractionMedia.InteractionMediaName = 'Telephony'

sum(max(F_InteractionSegments.HoldTime) group by InteractionId)

where F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId → D_InteractionMedia.InteractionMediaName = 'Telephony'

sum(max(F_InteractionSegments.WrapUpTime) group by InteractionId)

where F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId → D_InteractionMedia.InteractionMediaName = 'Telephony'

sum(F_InteractionSegments.TalkTime) + sum(max(F_InteractionSegments.HoldTime) group by InteractionId) + sum(max(F_InteractionSegments.WrapUpTime) group by InteractionId)

where F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId → D_InteractionMedia.InteractionMediaName = 'Chat'

sum(F_InteractionSegments.TalkTime) + sum(max(F_InteractionSegments.HoldTime) group by InteractionId) + sum(max(F_InteractionSegments.WrapUpTime) group by InteractionId)

where F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId → D_InteractionMedia.InteractionMediaName = 'Email'

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'No Answer'

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Backoffice - Administrative'

sum(F_AgentLife.EndTime - F_AgentLife.StartTime)

where F_AgentLife.AgentStatusId → D_AgentStatus.AgentStatusId  → D_AgentStatus.AgentStatusName = 'Handling - Outgoing Interactions'

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

BusinessProcessName

List of business processes using a delimiter '|'

Y

MistreatReason

List of reasons using a delimiter '|'

Y

Number

Origin/Destination

Y

InteractionResult

List of interaction results using a delimiter '|'

Y

DispositionCode

List of disposition codes using a delimiter '|'

Y

Checkbox

Include Archive data

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

DWDBName

Potential parameter for DW db

0 = Customer on call - Agent disconnected

1 = Customer on hold - Customer disconnected

2 = Customer on hold - Agent disconnected

Mistreated Time

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Number

Origin/Destination

Y

Remark

String search in remarks

Y

DispositionCode

List of disposition codes using a delimiter '|'

Y

Checkbox

Include Archive data

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

DWDBName

Potential parameter for DW db

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Agents

List of agents using a delimiter '|'

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

BPs

List of business processes using a delimiter '|'

Y

SupervisorsList

List of supervisors using a delimiter '|'

Y

ActionList

List of actions using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

DW_DBName

DW DB Name

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Agents

List of agents using a delimiter '|'

BusinessProcessName

List of business processes using a delimiter '|'

Y

InteractionCreationType

List of interaction types using a delimiter '|'

Demands

List of demands using a delimiter '|'

TimeZone

TimeZone name, is preffered option than @Offset

N

1 = if F_InteractionSegments.InteractionResultId → D_InteractionResult.InteracitonId → D_InteractionResult.interactionResultName = 'Abandoned' and F_InteractionSegments.Ququed = 1

0 = in other cases

if [IsAbandon] = 1

[PreQueueDuration] + [QueueDuration]

1 = if F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeName= 'Callback'

0 = in other cases

1 = F_InteractionSegments.ExternalTransferDID is not null

0 = in other cases

1 = F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId → D_InteractionState.InteractionStateName = 'Consulting'

0 = in other cases

where 

exists another record in F_InteractionSegments with the same F_InteractionSegments.InteractionId and another handler (agent - F_InteractionSegments.AgentId, bp - F_InteractionSegments.BusinessProcessId)

DW_DBName

DW DB Name

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Agents

List of agents using a delimiter '|'

Y

MediaType

List of media types using a delimiter '|'

Y

BusinessProcessName

List of BPs using a delimiter '|'

Y

DispositionCode

List of disposition codes using a delimiter '|'

Y

Demands

List of demands using a delimiter '|'

Y

InteractionResult

List of results using a delimiter '|'

Y

TimeZone

TimeZone name, is preffered option than @Offset

Y

OriginDestination

Origin or Destination - string search

Y

OriginallyOriginatedBy

Originated By Organization/Customer

Y

InteractionID

F_InteractionConversations.InteractionId → F_Interactions.InteractionId  → F_Interactions.Origin

F_InteractionConversations.InteractionId → F_Interactions.InteractionId  → F_Interactions.Destination

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

ShowOnlyRemarks

Show Only Interactions With Remarks

Y

BusinessProcessName

List of BPs using a delimiter '|'

Y

MediaType

List of media types using a delimiter '|'

Y

InteractionResult

List of interaction results using a delimiter '|'

Y

DispositionCode

List of disposition codes using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DNCOnly

Only interactions ended in "Do Not Call"

Y

InteractionType

List of interaction types using a delimiter '|'

Y

AgentName

List of agents using a delimiter '|'

Y

Demands

List of business processes using a delimiter '|'

Y

GroupByDDLB

Group By

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

ClientName

Client Name

N

InboundCampaignName

Inbound Campaign Name

N

ProductName

Product Name

N

ProductType

Product Type

N

AgentName

Agent Name

F_InteractionSegments.AgentId

InteractionSegmentID

Segment Id

F_InteractionSegments.InteractionSegmentId

InteractionID

Interaction ID

F_InteractionSegments.InteractionId

InteractionNo

DispositionCode

Disposition Code

F_InteractionSegments.DispositionCode

Disposition_Code

InteractionStartTime

Interaction Start Time

F_InteractionSegments.InteractionStartTime

StartTime

InteractionEndTime

Interaction End Time

F_InteractionSegments.InteractionEndTime

EndTime

InteractionTime

Duration

F_InteractionSegments.InteractionEndTime - F_InteractionSegments.InteractionStartTime

Duration

HoldTime

Hold Time

F_InteractionSegments.HoldTime

HoldTime

InteractionTypeName

Interaction Type

F_InteractionSegments.InteractionCreationTypeId → D_InteractionCreationType.InteractionCreationTypeId 

InteractionTypeName

DirectionName

F_InteractionSegments.DirectionId → D_Direction.DirectionId 

Origin

Origin

F_InteractionSegments.Origin

Originator

Destination

Destination

F_InteractionSegments.Destination

Destination

InteractionResultName

Interaction Result

F_InteractionSegments.InteractionResultId → D_InteractionResult.InteractionResultId 

InteractionResult

SegmentStartTime

Segment Start Time

F_InteractionSegments.StartTime

SegmentEndTime

Segment End Time

F_InteractionSegments.EndTime

SegmentTime

Segment Duration

F_InteractionSegments.EndTime - F_InteractionSegments.StartTime

InteractionStateName

Segment Status

F_InteractionSegments.StartTime.InteractionStateId → D_InteractionState.InteractionStateId 

BusinessProcessName

BP, Entity Name

F_InteractionSegments.BusinessProcessId → D_BusinessProcess.BusinessProcessId 

BusinessProcessName

ContactCenterName

Contact Center, is not used in the report

F_InteractionSegments.BusinessProcessId → D_BusinessProcess.BusinessProcessId → D_BusinessProcess.ContactCenterName

HandlerTypeName

Entity Type

F_InteractionSegments.HandlerTypeId → D_HandlerType.HandlerTypeId 

Remarks

Remarks

F_InteractionSegments.Remarks

Remarks

CustomerBillingCode

Customer Billing Code, is not used in the report

F_InteractionSegments.CustomerBillingCode

SegmentFullStartTime

Segment Start Time, is not used in the report

F_InteractionSegments.StartTime

ExternalTransferDID

Ext. Trans. DID

F_InteractionSegments.ExternalTransferDID

ExtTransDID

TelephonyTimeIncoming

Tele. Time (In)

F_InteractionSegments.TelephonyTimeIncoming

TeleTimeIn

TelephonyTimeOutgoing

Tele. Time (Out)

F_InteractionSegments.TelephonyTimeOutgoing

TeleTimeOut

TelephonyTimeExternalAgent

Tele. Time (Ex. Agent)

F_InteractionSegments.TelephonyTimeExternalAgent

TeleTimeExAgent

CampaignName

Campaign Name

F_InteractionSegments.CampaignId → D_Campaign.CampaignId 

Campaign_Name

EndedInRequestDNC

DNC

F_InteractionSegments.DNC

DNC

InteractionMedia

Media Type

F_InteractionSegments.InteractionMediaId → D_InteractionMedia.InteractionMediaId

Media

InteractionStateID

Segment Status

F_InteractionSegments.InteractionStateId → D_InteractionState.InteractionStateId 

Demands

Demands

F_InteractionSegments.InterationGUIDID → F_InteractionSkills.InteractionId → F_InteractionSkills.SkillId → D_Skill.SkillId

Demands

TelephonyTotalUsageTime

Tele. Total Usage Time

[TelephonyTimeIncoming] + [TelephonyTimeOutgoing] + [TelephonyTimeExternalAgent]

TelephonyTotalUsageTime

FullAgentName

Agent Name

F_InteractionSegments.AgentId → D_Agent.AgentId

FullAgentName

RoutingClientName

Client Name

F_InteractionSegments.RoutingClientName

ClientName

RoutingInboundCampaignName

Inbound Campaign Name

F_InteractionSegments.RoutingInboundCampaignName

InboundCampaignName

RoutingProductName

Product Name

F_InteractionSegments.RoutingProductName

ProductName

RoutingProductType

Product Type

F_InteractionSegments.RoutingProductType

ProductType

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

ShowOnlyRemarks

Show Only Interactions With Remarks

Y

BusinessProcessName

List of BPs using a delimiter '|'

Y

MediaType

List of media types using a delimiter '|'

Y

InteractionResult

List of interaction results using a delimiter '|'

Y

DispositionCode

List of disposition codes using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DNCOnly

Only interactions ended in "Do Not Call"

Y

InteractionType

List of interaction types using a delimiter '|'

Y

AgentName

List of agents using a delimiter '|'

Y

Demands

List of business processes using a delimiter '|'

Y

GroupByDDLB

Group By

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

ClientName

Client Name

N

InboundCampaignName

Inbound Campaign Name

N

ProductName

Product Name

N

ProductType

Product Type

N

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Number

Originator / Destination, string search

Y

Remark

Remark or part of remark, string search

Y

DispositionCode

List of disposition codes using a delimiter '|'

Y

Checkbox

Include Archive data

Y

Demands

List of demands using a delimiter '|'

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

ClientName

Client Name

N

InboundCampaignName

Inbound Campaign Name

N

ProductName

Product Name

N

ProductType

Product Type

N

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

AgentName

List of agents using a delimiter '|'

Y

BusinessProcessName

List of BPs using a delimiter '|'

Y

DirectionName

List of directions using a delimiter '|'

Y

DispositionCode

List of disposition codes using a delimiter '|'

Y

MediaName

List of media types using a delimiter '|'

Y

Checkbox

Include Archive data

Y

CampaignName

List of campaigns using a delimiter '|'

Y

MainTableAccumulatedBy

Main Time Slice: 1 - Hour, 2 - Day, 3 - Week, 4 - Month, 5 - Quarter, 6 - Year

Y

DWDBName

DW DB Name

Y

InteractionType

List of interaction types using a delimiter '|'

N

TimeZone

TimeZone name, is preffered option than @Offset

N

FiterType

Agent

Business Process

Campaign

Direction / Media Name

F_InteractionSegments.AgentId → D_Agent.AgentId

F_InteractionSegments.BusinessProcessId → D_BusinessProcess.BusinessProcessId

F_InteractionSegments.CampaignId → D_Campaign.CampaignId

F_InteractionSegments.DirectionId → D_Direction.DirectionId / F_InteractionSegments.interactionMediaId → D_InteractionMedia.InteractionMediaId

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

InteractionType

List of interaction types using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Dest

Origin / Destination

F_InteractionUsage.Destination / F_InteractionUsage.Origin

Duration

Total Calls Duration

F_InteractionUsage.EndTime - F_InteractionUsage.StartTime

ProratedDuration

Total Calls Prorated Duration

F_InteractionUsage.EndTime - F_InteractionUsage.StartTime

(in timeslice borders)

Direction

Direction

F_InteractionUsage.DirectionId → D_Direction.DirectionId

Total

Total Calls

count(F_InteractionUsage.InteractionUsageId)

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

InteractionType

List of interaction types using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Total Calls Duration

F_InteractionUsage.EndTime - F_InteractionUsage.StartTime

(in timeslice borders)

Disposition Code

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Checkbox

Include Archive data

Y

DWDBName

Potential parameter for DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Checkbox

Include Archive data

Y

DW_DBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Checkbox

Include Archive data

Y

DW_DBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Checkbox

Include Archive data

Y

DW_DBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Checkbox

Include Archive data

Y

DW_DBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

InteractionType

List of interaction types using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Duration

Total Calls Duration

F_InteractionUsage.EndTime - F_InteractionUsage.StartTime

ProratedDuration

Total Calls Prorated Duration

F_InteractionUsage.EndTime - F_InteractionUsage.StartTime

(in timeslice borders)

Direction

Direction

F_InteractionUsage.DirectionId → D_Direction.DirectionId

BusinessProcess

Business Process

F_InteractionUsage.BusinessProcessId → D_BusinessProcess.BusinessProcessId

Total

Total Calls

count(F_InteractionUsage.InteractionUsageId)

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

InteractionType

List of interaction types using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

StartTime

Duration

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

InteractionType

List of interaction types using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Duration

Total Calls Duration

F_InteractionUsage.EndTime - F_InteractionUsage.StartTime

ProratedDuration

Total Calls Prorated Duration

F_InteractionUsage.EndTime - F_InteractionUsage.StartTime

(in timeslice borders)

Direction

Direction

F_InteractionUsage.DirectionId → D_Direction.DirectionId

BusinessProcess

Business Process

F_InteractionUsage.BusinessProcessId → D_BusinessProcess.BusinessProcessId

Total

Total Calls

count(F_InteractionUsage.InteractionUsageId)

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

InteractionType

List of interaction types using a delimiter '|'

Y

Checkbox

Include Archive data

Y

DWDBName

DW DB Name

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Duration

DWDBName

DW DB Name

Y

EndTime

End of selected period

Y

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

Checkbox

Include Archive data

Y

InteractionType

List of interaction types using a delimiter '|'

Y

StartTime

Start of selected period

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

Total Calls Duration

F_InteractionUsage.EndTime - F_InteractionUsage.StartTime

(in timeslice borders)

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

BusinessProcessName

List of BPs using a delimiter '|'

Y

Checkbox

Include Archive data

Y

Demands

List of demands using a delimiter '|'

Y

PeriodBuckets

List of period buckets using a delimiter '|': 1 - Hour of day, 2 - Day of week, 3 - Weekly, 4 - Monthly, 5 - Quarterly, 6 - Yearly

Y

TimeZone

TimeZone name, is preffered option than @Offset

N

DWDBName

DW DB Name

Y

ClientName

Client Name

N

InboundCampaignName

Inbound Campaign Name

N

ProductName

Product Name

N

ProductType

Product Type

:N

HistoryDBName

History DB Name, was kept for backward compatibilities

Y

StartTime

Start of selected period

Y

EndTime

End of selected period

Y

Offset

Timezone offset, can be omitted since 5.3.0, if @TimeZone was passed 

Y

BusinessProcessName

List of BPs using a delimiter '|'

Y

Agents

List of agents using a delimiter '|'

Y