You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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

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.


SUM(a.CallSeconds)

  • No labels