About Asterisk Reports Organization

SAM Reports divides both CDR and queue reports into several areas of data:

  • There is a general “Call” area. It takes into account just the call itself, and ignores all other “participants” (elements), such as extensions and trunks for CDR report and agents and queues for queues report.
  • Then there is the “element” area which focuses on extensions and trunks respectively for CDR reports and agents and queues respectively for queue reports.
  • The last “elements” are the caller-id based data.

    This help file is for the old version of SAM Reports. New version brings more reports and a lot of new features.

    There are new help files for Application Organization for the new version -> SAM Reports2 :

    Application Organization (SAM Reports 2)

    These report views, in both CDR and queue reports, display all the available data with a focus on caller-id. If the caller-id is know than such information is displayed in the “Contact” (CDR or queue) area. If the caller-id is not known, than it is displayed in “unknown numbers” area (CDR or queue).


Report Elements of CDR and Queue Asterisk Reports

Report Elements of CDR and Queue Reports



Both CDR and Queue Reports windows share the same User Interface structure:
There is the ribbon with the most used commands. Then, form top to bottom, comes the pivot grid with data fields and an accompanying tool bar.
At the bottom is the chart with it’s own tool bar.


SAM Asterisk Reports Overall Structure

Overall Structure


The data and the chart may be printed and exported to other file formats.

The Ribbon has three main areas. The data area lets you move between different types of reports.
The TopN filter lets you display just the top values. The Date filter lets you filter the data by date.


SAM Reports Ribbon

SAM Reports Ribbon


The other tab on the ribbon is the “Print/Export” tab. There you can print, preview and export the data and the chart to popular file formats.

On the picture above you see the different views available for queues:

  • Calls Summary displays the data on the call level. It holds only the outcome of the call significant (answered/failed), and not the attempt based data (number of rings, retries).
  • Agents Summary goes into more detail when describing a call and records all unanswered rings etc.
  • Queues Summary is also more detailed than the calls summary, but on the queue level.
  • Contacts Summary focuses on the caller-id data gathered from CDRs and queues. The application lets you match caller-ids with your proprietary contact data.

And for the CDR, look at the image below.


CDR Report Data Types

CDR Report Data Types


There we have:

If the data is sorted, which can be done by pressing a single button on the tool bar, than you can display just the top performing data for your filtered filed.
You can also display the remaining values grouped into just one value (as shown on the picture below). That lets you see the ratio between the top n values and the rest.


Asterisk Queue Data Showing Top 4 values

TopN Filter


If you want to limit your reports to display jut the data from some period in time then you can set it up here. Choose the start and the end date and then press the “Date Filter” button. It’s an on/off switch. While it’s pressed down the reports are filtered by date and vice versa. The same applies to the “TopN Values” filter.

The pivot grid lets you make custom pivot reports on your Asterisk data.
You just take any field, and you drag and drop it onto one of the grid areas, as shown below.
Depending on where you put it, the report will show the data in a different way.


The Pivot Grid


The areas to drop the fields in, are:

  • Filter Area is useful when you just want to filter out some filed values (like display only Answered calls), but don’t want to see that data in the gird. It is also a place to put the fields that you currently don’t use in the report.
  • Column Area lets you decide which columns will the grid actually display. Fields may be nested, grouped. In that case a little plus (“+“) sign appears near a distinct value, indicating that you can do a further drill down for that value. That means that if you put “Hour” as the first field and then “Answered/Failed” as the second one, then you will be able to make a drill-down of answered or failed calls by the hour, by clicking on a specific hour value.
  • Data Area is where you put the actual values to be displayed. Those values are then grouped by column and row areas.
  • Row Area lets you design which rows the grid contains. Fields my be nested here as well. In that case they form a hierarchy.

It is used to sort the grid by a specific filed and export the grid data to popular formats (Excel worksheet, XML data, HTML and RTF).
When displaying Asterisk CDR Reports the you may sort by:

For Asterisk Queue Reports the sorting is possible by following:

The exporting of the grid’s data is explained here.


SAM Reports Tool bar

SAM Reports Tool bar



The chart shows Asterisk call data that is currently visible in the pivot grid.
Chart is refreshed dynamically, so when you drag & drop some filed, the chart refreshes and changes instantly. Chart may be exported to the clipboard or a bitmap image.


Asterisk Queue Call Data Displayed in a Chart

SAM reports Chart with tool bar


There are five diagrams : column, bar, area, line and pie. In the image below you see the same data as it appears in different diagrams.


Asterisk Queue Call Data Displayed in five different diagrams

SAM Reports chart diagrams


http://samreports.com/online-help/queue-reports#queueagents

For both CDR reports and queue reports printing and exporting is done the same way.


Printing And Exporting Asterisk Reports with SAM Reports

Printing And Exporting Asterisk Reports


  • 1.Print and Preview window.
  • 2.Exporting just the data
  • 3.Exporting just the  chart.

The Print Preview Window


Print And Preview Asterisk Reports With SAM Reports

Print And Preview Reports With SAM Reports


Export to pdf


Export Asterisk Reports To PDF with SAM Reports

Export Reports To PDF


The commands for exporting data are also available from the pivot grid data tool bar.

Data that is currently visible in the pivot grid can be exported into four different formats:

Excel Worksheet (XLS)

Here is how the created worksheet looks when loaded into Excel.


Asterisk Report Data Exported To Excel Worksheet

Report Data Exported To Excel Worksheet


XML Data

Here is how the XML file look when loaded into MS Internet Explorer.


Asterisk Report Data Exported To XML

Report Data Exported To XML


HTML Page

Here is how the created HTML page looks when loaded into Firefox


Asterisk Report Data Exported to HTML

Report Data Exported to HTML


Text File

Here is how the created text file looks when loaded into Notepad:


Asterisk Report Data in Notepad

Report Data in Notepad


The commands for exporting the chart are also available from the chart tool bar.

The chart can be copied to the clipboard or saved as a bitmap (*.bmp).

Clicky Web Analytics