Description

This report shows on a service number basis, which region the calls were received from. The grouping is according to state.

Settings of the Report

In addition to the standard settings "Output format" and "Period", the following additional settings are available

NameValueDescription
Granularity

Granularity for the consolidation of data
Service Number

Service number to which the report refers

Selection Criteria

CriterionDescription
PeriodAll calls whose occurrence in the system lies within the time intervals (StatisticsPartA.dtCallStart)
Service NumberService number whose calls are included in the report.

Columns

NameValue

Period

Shows the time period to which the data applies.

Type

Shows where the call came from. This can be the name of a state, “Mobile”, “Others” or another relevant description of the origin of the call.


IFNULL(IF( ac.bMobile, ac.Name, ac.StateName), '')



Explanation: 

JTELWeb.AreaCodes ac ON a.ANumber_AreaCodesID = ac.ID

Calls

The number of calls for this type.


COUNT(a.dtCallStart)

Duration

The duration of calls from entry to the system to hangup. (StatisticsPartA.CallSeconds)


SUM(a.CallSeconds)

  • No labels