DescriptionThis report shows on a service number basis, which region the calls were received from. The grouping is according to state.Image Removed Settings of the ReportIn addition to the standard settings "Output format" and "Period", the following additional settings are available Name | Value | Description |
---|
Granularity | | Granularity for the consolidation of data | Service Number | | Service number to which the report refers |
Selection CriteriaCriterion | Description |
---|
Period | All calls whose occurrence in the system lies within the time intervals (StatisticsPartA.dtCallStart) | Service Number | Service number whose calls are included in the report. |
ColumnsName | Value |
---|
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. Translations Ignore |
---|
IFNULL(IF( ac.bMobile, ac.Name, ac.StateName), '')
|
Explanation: Translations Ignore |
---|
JTELWeb.AreaCodes ac ON a.ANumber_AreaCodesID = ac.ID
|
| Calls | The number of calls for this type. Translations Ignore |
---|
COUNT(a.dtCallStart)
|
| Duration | The duration of calls from entry to the system to hangup. (StatisticsPartA.CallSeconds ) Translations Ignore |
---|
SUM(a.CallSeconds)
|
|
|