Docs for all releases
This section provides a user with a possibility to generate a report with a focus on actual traffic over the specified period. The report allows customizing a display of routes limits, vendors, total records, etc.
Screenshot: LCR Lists query form
Creating an LCR Report
To create a new LCR report, go to the Statistics section and open the LCR Lists. Then, you will need to fill out the search form with the next parameters:
|Information Block||Field Description|
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.
Specify an interval for the report and a timezone. Please note that the Period field is mandatory.
Select from the list of the following accessible options to group the data in reports:
This option is intended to simplify the grouping option, the system will automatically group data in specified columns.
|Service||Specify a target service (calls, data, SMSs)|
There are the following accessible additional filters:
Specify a target reseller
|Client Tags||Indicate client tags that will be used for the report|
|Code||Enter the code of a target destination|
|Code Name||Define the code name you would like to be displayed in a report|
Indicate the limit of routes that will be shown. To display all possible routes, leave this field empty.
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|
There are the following columns to add to the report:
|Other output settings|
Choose a format of the report from a drop-down list: Web/CSV/Excel XLS/Excel XLSx.
The table view of the report is Plain by default.
You can send generated reports via email. For example, it is useful when it takes a lot of time to run the report. Also, it is possible to specify several emails.
Specify a currency of the report. All values will be automatically converted to the specified currency in the report.
Select a code deck from a drop-down list. All code decks in the following report will be presented according to the specified code deck. All data will be unified by code names.
|Show Vendors checkbox|
Specify whether you need vendor (terminator) names to be displayed in the report or not.
|Show Total Calls checkbox|
Check if you want total calls amount to be shown.
The LCR report has the following look:
Screenshot: LCR report
Each route, presented in a report, besides a total number of events and vendors (displayed when respective checkboxes are marked) has the following data specified (see screenshot above):
- Event volume;
- Event rate;
Also, you can create a template for reports and save specified parameters by clicking the Save Query button. Visit our Reports Templates article for detailed information.
To query by template, click the Load Query button and the icon .
Export generated report
You can export data to a CSV or XLSx file, which contains only currently displayed data, with no automatic request to update data while exporting.
- To download a report in .csv, click on the Export to CSV button above the report.
- To download a .xlsx report file, click on the Export to XLSx button above the report.
Sharing a Report
Each time you get a report output, the system generates a unique link in the format of "/view?id=<uniq-string>". It allows sharing data between the users, even if they belong to different resellers (the feature works similarly to Share by Link in Google Drive).
The link refers to the report data valid for a specific moment.
Example: When you send a link to a report, you ensure the recipient would see the same data as you do. If you change data in the system (for example, perform rerating), the previously copied link to the report will display data valid for the moment of generation (even though the actual data is now different).
You can also view the additional information about the generated report by hovering over the Info icon, which is located under the Output section:
|Data Period||States the period set for a report|
|Generated by||Indicates the Role of the user who generated a report and specifies a generation time|