Pivot Reports display CDR and Queue data in a Business Intelligence fashion. Reports are also dynamic, which means that you can create your custom report by manipulating field objects and filtering data ( with TopN filer, Date filter or field filtering).
Above is an image of Pivot Reports organization.
There are six main parts:
There is a “Home” and “Print/Export” Area
If you don’t want to display the “Other Values” just uncheck the command’s button.
If you want to limit your reports to display just 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 the reports are filtered by date and vice versa. The same applies to the “TopN” filter.
Templates let you save your current fields configuration and reload it. Templates “remember” the fields layout, so you can go back to it anytime.
If there are more than 100.000 items to be displayed in pivot grid, than the display is separated into pages, each holding up to that many items.
The information about the current page and the number of pages is also available on the status bar.
Here are the commands for printing and exporting data.
When you choose one of “Print Preview” commands, a window appears as shown on the image below:
Depending on which command you choose, data, chart, or both will be shown in window. There you can further customize the report for printing, and export it to Adobe PDF document as well.
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:
Here is how the created worksheet looks when loaded into Excel:
Here is how the created HTML page looks when loaded into Firefox:
Here is how the XML file look when loaded into MS Internet Explorer:
Here is how the created text file looks when loaded into Notepad:
Chart can be saved as a bitmap, or copied to clipboard. The same commands are available on the pivot chart toolbar.
The Data Toolbar affects both gird and chart. It lets you choose sorting options and also to export data.
You may switch sorting on and off by pressing the “Not Sorted” button on the toolbar.
Sorting affects other data manipulation options. When “Not Sorted” is checked than TopN filter is disabled, for it works only on sorted data to determine the top values.
You can choose which field the data is sorted by, as well as the sorting summary.
Sort field can be sorted by the corresponding grand total values instead of its own values. All you need to do to make this happen is to specify which summary should be used for sorting.
As you may see on the image, the sorted field is displayed in bold.
The Pivot Data 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.
It 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.
The filtered field does not have to reside in the filter area. It may be in any of the areas. Filtered field is always underlined.
It lets you decide which columns the grid will 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.
It is where you put the actual values to be displayed. Those values are then grouped by column and row areas.
It lets you design which rows the grid contains. Fields my be nested here as well. In that case they form a hierarchy.
The chart shows Asterisk call data that is currently visible in the pivot grid.
Chart is refreshed dynamically, so when you drag drop some field, the chart refreshes and changes instantly.
Chart may be exportedto the clipboard or a bitmap image.
- Stacked Bar
- Stacked Column
- Stacked Area
Chart Type menu lets you change the current chart.
If chart has more than 12 items it gets separated into pages, each holding up to 12 items. When you print or export chart only the current page is exported/printed.
There are also chart export commands available.
The last part of the toolbar shows the information abut currently displayed items.
The status bar lets you see current information.