The main element of both pivot and detailed reports is the field. Fields are defined by the actual Asterisk CDR and queue structure. Pivot reports let you move those fields into different field areas and thus structure the report to your own needs. Detailed reports let you filter and group to build a drill-down report.
SAM Reports 2 divides fields into five categories:
Quantitative fields are original values taken form the Asterisk CDR and queue logs. They have not been changed in any way, only aggregated to display accordingly to the current report view in the pivot/detailed gird. Or displayed as they are when shown in drill down detailed reports.
In detailed reports there are no “Sum” (summary) and “Avg” (average) fields, just the actual filed value (for example Duration or Talk time).
Count field tells you the number of calls for a given date, time and some other field constellation in a report.
It is not present in detailed reports, for it counts a number of calls, and detailed reports display one call per line. In that case the value of count would always be 1.
If you group fields in detailed reports you do get a count of that group though.
Fields that show the accrued or average billable seconds for a given time period and currently selected fields in the pivot gird.
Fields that show the accrued or average duration in seconds.
They show the accrued or average talk time in seconds for a given period and currently selected fields in the pivot grid.
They show the accrued or average hold time in seconds for a given period and currently selected fields in the pivot grid.
Hold time field has either hold time or wait time from the original Asterisk queue log file. Some events in queue_log report hold time (time that caller was holding), and others have wait time instead. This field combines the two. queue_log never has both times together in the same event.
Date and time fields are generated from CDR’s start and end time stamps. There are six date fields (Year, Quarter, WeekNo, Month Name, Day Of Month, Day Of Week ) and one time field (Hour).
Year field carries just the year portion of log file’s time stamp.
Quarter field breaks a year into four quarters.
This field displays the month name using current Windows local settings. So the month will appear in you language.
This field shows the current week number of the year.
Shows the name of current weekday in local language.
Shows the number of a day in a month.
Shows the hour of day.
Calculated fields are those whose value was not obvious from the Asterisk’s logs. It had to be calculated taking into account additional data about the particular Asterisk PBX installation.
Direction determines whether the call was incoming or outgoing. This is a calculated field, which means that it’s value was determined by the SAM Reports upon processing the data from Asterisk PBX.
The possible values are:
- Incoming call does not necessarily mean that the call came from the outside. It could be Peter calling Ann while sitting next to each other. Incoming, for Ann’s extension, just means that it received a call from some destination, no matter where from.
- Outgoing call, also, does not assume placing a call to some destination outside a host PBX, it just denotes the direction which the call took.
This field is also calculated by SAM Reports. Origin may be internal and external. Internal call is a call between extensions of the same Asterisk PBX. External call is a call between local extension and an outside extension, destination.
The possible values are:
- Internal call means that the caller and the callee are both the extensions of the same host PBX.
- External call, in contrary, means that one of the sides in the call was from some other destination than our host PBX.
Status field tells you whether the call was successful or not.
It has three possible values:
- Normal : the call was successful.
- inc_noans : the call failed and it was an incoming call.
- our_noans : the call failed and it was an outgoing call.
This field informs of whether a call had one or two participants. One-way call would be when you dial an extension to check your voicemail.
It has two possible values :
- way_one: one-way call.
- way_two: two-way call.
Kind field informs on whether a call was direct or not.
It has two possible values:
- direct: means that a call was a direct call.
- indirect: means that a call was transferred, or made using a “local” channel.
Answered/Failed field tells you whether the call was answered by an agent or not.
Possible values are:
- answered: the call was answered by an agent
- failed: the call was not answered
Hangup field tells you how this particular call has ended. Whether it ended by an agent or the caller, or perhaps transferred to another agent or extension.
Possible values are:
- Agent: agent has ended the call
- Caller: caller ended the call
- Transfer: agent transferred the call to another agent or extension.
Exit field just records the last queue event (queue action) on call completion. That way you can determine whether the caller hung up the phone (ABANDON event), or perhaps was he kept waiting on the line for too long and gave up (EXITWITHTIMEOUT event).
Possible values for this field may differ from one report to another. They depend on the current available data, filtering …
Element fields represent the elements for which the report is created. The purpose of creating any Asterisk log file report is to know about performance and behaviur of these elements.
This field shows a phone number that was present id either CDR or queue log file.
This field was generated from CallerID either form CDR or queue log file.
Lists all channel available for the current selection in the grid.
Lists all trunks available for the current selection in the grid.
Shows Agents present in the current report selection.
Lists queues available in the grid.
Descriptive fields add additional information to the report and are original fields from the log files.
Shows all destination contexts available for the current selection.
Shows all transfer extensions and CallerIDs available.
Shows all entry positions available for the current data in the grid.
Lists all exit positions available.