This report shows on a service number basis, which region the calls were received from. The grouping is according to state. ![](/download/attachments/327897/Call%20Origin.PNG?version=1&modificationDate=1595595260000&api=v2)
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)
|
|
|