This report shows on a service number basis, which region the calls were received from. The grouping is according to state. Image Added
Settings of the ReportIn addition to the standard settings "Output format" and "Period", the following additional settings are available Name | Value | Description |
---|
Granularity | Image Added
| Granularity for the consolidation of data | Service Number | Image Added
| 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)
|
|
|