Fields in General

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:

  1. Quantitative fields
  2. Date and Time fields
  3. Calculated fields
  4. Element fields
  5. Descriptive fields

Quantitative fields

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.

They are:

  1. Count
  2. CDR:
    1. Billable Sum and Billable Avg
    2. Duration Sum and Duration Avg
  3. Queue:
    1. Talk Sum and Talk Avg
    2. Hold Sum and Hold Avg

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

Count field tells you the number of calls for a given date, time and some other field constellation in a report.

Asterisk Field Count of Calls

SAM Reports 2 Field Count of Calls

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.

CDR Quantitative Fields

Billable Sum and Billable Avg

Fields that show the accrued or average billable seconds for a given time period and currently selected fields in the pivot gird.

SAM Reports 2 Fields - Billable Time

SAM Reports 2 Fields - Billable Time

Duration Sum and Duration Avg

Fields that show the accrued or average duration in seconds.

SAM Reports 2 Fields - Duration

SAM Reports 2 Fields - Duration

Queue Quantitative Fields

Talk Sum and Talk Avg

They show the accrued or average talk time in seconds for a given period and currently selected fields in the pivot grid.

SAM Reports 2 Fields - Talk Time

SAM Reports 2 Fields - Talk Time

Hold Sum and Hold Avg

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.

SAM Reports 2 Fields - Hold Time

SAM Reports 2 Fields - Hold Time

Date and Time fields

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).

Those fields are the same for the queue reports as well. In that case they are generated form queue log’s time-stamps.
They are:

Year Field

Year field carries just the year portion of log file’s time stamp.

SAM Reports 2 Fields - Year

SAM Reports 2 Fields - Year

Quarter Field

Quarter field breaks a year into four quarters.

SAM Reports 2 Fields - Quarter

SAM Reports 2 Fields - Quarter

Month Name Field

This field displays the month name using current Windows local settings. So the month will appear in you language.

SAM Reports 2 Fields - Month Name

SAM Reports 2 Fields - Month Name

Week Number Field

This field shows the current week number of the year.

SAM Reports 2 Fields - Week Number

SAM Reports 2 Fields - Week Number

Day Of Week Field

Shows the name of current weekday in local language.

SAM Reports 2 Fields - Week day

SAM Reports 2 Fields - Week day

Day of Month Field

Shows the number of a day in a month.

SAM Reports 2 Fields - Day Of Month

SAM Reports 2 Fields - Day Of Month

Hour Field

Shows the hour of day.

SAM Reports 2 Fields - Hour

SAM Reports 2 Fields - Hour

Calculated fields

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.

They are:

CDR Calculated fields

Direction

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.
SAM Reports 2 Fields - CDR Direction

SAM Reports 2 Fields - CDR Direction

Origin

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.
SAM Reports 2 Fields - CDR origin

SAM Reports 2 Fields - CDR origin

Status

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.
SAM Reports 2 Fields - CDR Status

SAM Reports 2 Fields - CDR Status

Way

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.
SAM Reports 2 Fields - CDR Way

SAM Reports 2 Fields - CDR Way

Kind

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.
SAM Reports 2 Fields - CDR Call Kind

SAM Reports 2 Fields - CDR Call Kind

Queue Calculated fields

Answered/Failed

Answered/Failed field  tells you whether the call was answered by an agent or not.

SAM Reports 2 Fields - Queue Answered or Failed Call

SAM Reports 2 Fields - Queue Answered or Failed Call

Possible values are:

  • answered: the call was answered by an agent
  • failed: the call was not answered

Hangup

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.

SAM Reports 2 Fields - Queue Hangup

SAM Reports 2 Fields - Queue Hangup

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

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).

SAM Reports 2 Fields - Queue Exit

SAM Reports 2 Fields - Queue Exit

Possible values for this field may differ from one report to another. They depend on the current available data, filtering …

Element fields

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.

They are:

  1. Phone Number
  2. Contact
  3. CDR Elements:
    1. Channel
    2. Trunk
  4. Queue Elements:
    1. Agent
    2. Queue

Phone Number

This field shows a phone number that was present id either CDR or queue log file.

SAM Reports 2 Fields - Phone Number

SAM Reports 2 Fields - Phone Number

Contact

This field was generated from CallerID either form CDR or queue log file.

SAM Reports 2 Fields - Contact

SAM Reports 2 Fields - Contact

CDR Element fields

Channel

Lists all channel available for the current selection in the grid.

SAM Reports 2 Fields - CDR Channel

SAM Reports 2 Fields - CDR Channel

Trunk

Lists all trunks available for the current selection in the grid.

SAM Reports 2 Fields - CDR Trunk

SAM Reports 2 Fields - CDR Trunk

Queue Element fields

Agent

Shows Agents present in the current report selection.

SAM Reports 2 Fields - Queue Agent

SAM Reports 2 Fields - Queue Agent

Queue

Lists queues available in the grid.

SAM Reports 2 Fields - Queue

SAM Reports 2 Fields - Queue

Descriptive fields

Descriptive fields add additional information to the report and are original fields from the log files.

They are:

CDR Descriptive fields

Destination Context

Shows all destination contexts available for the current selection.

SAM Reports 2 Fields - CDR Destination Context

SAM Reports 2 Fields - CDR Destination Context

Queue Descriptive fields

Transfer

Shows all transfer extensions and CallerIDs available.

SAM Reports 2 Fields - Queue Transfer

SAM Reports 2 Fields - Queue Transfer

Entry Position

Shows all entry positions available for the current data in the grid.

SAM Reports 2 Fields - Queue Entry Position

SAM Reports 2 Fields - Queue Entry Position

Exit Position

Lists all exit positions available.

SAM Reports 2 Fields - Queue Exit Position

SAM Reports 2 Fields - Queue Exit Position

Clicky Web Analytics