Docs for all releases
Page History
...
Screenshot: Summary Report query form
Creating a New Summary Report
...
Information block | Field Description | |||||||||
---|---|---|---|---|---|---|---|---|---|---|
Filters | On the Filters menu, select the required parameters for the report. To cancel any filter, click on the delete icon next to the filter. You can start a quick search by typing filters' names in the field at the top of a drop-down menu with filters. | |||||||||
Period (1) | Specify the time interval for the report and a timezone. Please note that the Period field is mandatory. | |||||||||
Period 2 | Accessible when you enable the Compare Period option by clicking on the plus icon next to the Period. Specify the second interval for the report:
| |||||||||
Group by | Select from the list of the following accessible options to group the data in reports:
| |||||||||
Additional Filters | ||||||||||
The accessible additional filters are:
| ||||||||||
Client Type | Select a client's type for the report: Client, Reseller, Calling Card or Call Shop | |||||||||
Client | Define a client for the report | |||||||||
Account | Enter an account for the report | |||||||||
Client/Account Tags | Define a client's or account's tag | |||||||||
Cards Serial | Indicate cards serial for the report | |||||||||
Package | Enter a package for the report | |||||||||
Code | Specify a code of the needed destination | |||||||||
Code Name | Specify a code name of the desired destination | |||||||||
Cost Total | Enter the range of total call cost | |||||||||
Origin | Indicate an origin - origination or termination of the event | |||||||||
Result Code | Define a result code as a filtering parameter | |||||||||
Gateway | Specify a gateway | |||||||||
Time Profile | Specify the time profile of the event | |||||||||
Owner | Indicate the owner | |||||||||
Total Volume | Enter the range of total duration | |||||||||
Total Records | Enter the range of total records | |||||||||
Not Zero Records | Define the range of records that have a duration equal to or more than 1 unit | |||||||||
ASR Current | Specify the range of ASR Cur for records you would like to display | |||||||||
ACD Current | Specify the range of ACD Cur for records you would like to display | |||||||||
Service Name | Determine the name of service for the report | |||||||||
Output | This form contains settings of the report output data. Click the plus icon next to Columns and select the required columns to add them to the Output information block. Also, you can cancel any chosen item. | |||||||||
Accessible columns in the report | ||||||||||
The list of additional columns include: Columns for the main period: Cost Total, Setup Fee Cost, Average Rate, Package Credit, Total Volume, Billed Volume, Package Volume, Total Events, Not Zero, Success, Busy, No Channel, Error, ASR Std, ASR Cur, ACD Srd, ACD Cur, PDD Avg, SCD Avg, xDRs List, Taxes Total, Additive Cost. Columns for the comparative period are the same as for the main period. Moreover, all parameters could be selectedexpressed in percentage. | ||||||||||
Rate | Avg. Rate - an average cost calculated | |||||||||
Totals |
| |||||||||
Statistics | ASR - average success rate (successful records percentage) in minutes
ACD - average call duration in minutes
PDD Avg - average post-dial delay in seconds SCD Avg - average session connect delay in seconds | |||||||||
xDRs List - list of detailed records statistics | ||||||||||
Other output settings | ||||||||||
Order by | Select parameters to sort already grouped data in columns. Here you can sort data from highest to lowest values (or vice versa) and select different values. | |||||||||
Type | Choose a format of the report from a drop-down list: Web/CSV/Excel XLS/Excel XLSx Also, select a look of a table view next to the Type field:
| |||||||||
Limit | Determine the number of rows that will be visible in the report. It is useful for displaying some top positions by the chosen parameter. It is available only for the Plain report type. | |||||||||
Send to | You can send generated reports via email. Also, it is possible to specify several emails.
| |||||||||
Currency | Specify a currency of the report. All values will be automatically converted to the specified currency in the report. | |||||||||
Code Deck | Select a code deck from a drop-down list. All codes in the following report will be presented according to the specified code deck. |
...
Screenshot: Summary Report section
If the data in the report is grouped, it will be shown initially collapsed. To expand or collapse data in your report, click the plus or minus icons. To expand all data in the report, please click Ctrl + the icon.
...
Also, you can create a template for reports and save specified parameters by clicking on the Save Query button. A pop-up window with settings will appear, and you will need to fill in the following form.
Screenshot: New Template form
To load already existed templates while generating statistic reports, click the Load Query button in the Summary Report section.
...
Screenshot: Summary Report section
Side-by-side report
...
Screenshot: Summary Report section
Then choose columns for a main and comparative period in the report Output form. When all required parameters are specified, click the Query button.
...
Screenshot: Summary Report section
Tip | ||
---|---|---|
| ||
Example 1: If you select the Period to be Today 00:00:00 til 23:59:59, the Previous Period and Previous Day values would be the same and show yesterday. The Previous Week option would display the same day last week (i.e., Monday for Monday), the Previous Month option would show the same date last month, and the Previous Year will display the same date last year. Example 2: If you select the Period to be This Week, the system will take the period starting Monday 00:00:00 and up to 23:59:59 on the current day. That is if your current day is Thursday, This Week would be Monday to Thursday. The comparative periods will work accordingly, selecting the same periods from the past week, month, year. Only the Previous Day option will result in offsetting a period one day behind (if a period is Monday to Thursday, comparative would be Sunday to Wednesday). |
...
Screenshot: Summary report Info icon
Knowledge Base Articles
...