LCR Lists

On this page

Section overview

This section provides user with a possibility to generate a report with a focus on actual traffic over the specified period of time. The report allows customizing display of routes limits, vendor, total records, etc.

Screenshot: LCR Lists query form

Creating LCR Report

In order to create a new LCR report go to the Statistics section and open the LCR Lists. Then you need to fill out the search form with next parameters:

Information block	Field Description
Filters	On the Filters menu, select required parameters for the report. To cancel any filter, click on the delete sign next to the filter. You can start a quick search by typing filters' names in the field at the top of drop-down menu with filters.
	Period	Specify an interval for the report and time zone. Please note that the Period field is mandatory.
	Group By	Select from the list of following accessible options to group the data in reports: *Code* Code Name This option is intended to simplify grouping option, the system will automatically group data in specified columns. Attention Please note, the Group By field is mandatory, it couldn't be empty in order to generate the report. Grouping by code is a default output. When you select the grouping by code name, please be aware that simulation marks will not be shown and effective date, also the next rate, may not be accurate. This data is taken from one of codes of the group.
	Service	Specify a target service (calls, data, sms)
	Additional Filters
	There are following accessible additional filters: Clients: Owner, Client Tags *Events:* Code/ Code Name Extras: Routes Limit
	Owner	Specify a target reselle
	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
	Routes Limit	Indicate the limit of route that will be shown. To display all possible routes, leave this field empty.
Output	This form contains settings of the report output data. Click plus sign next to Columns and select required columns in order to add them to Output information block. Also, you can cancel any chosen item.
	Accessible columns in the report
	There are following columns to add to the report: *Code* *Code Name* *Total Volume*
	Other output settings
	Type	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.
	Send to	You can send generated reports via e-mail. For example, it is useful when it takes a lot of time to run the report. Also, it is possible to specify several emails. Attention This feature is available only for CSV / Excel XLS / Excel XLSx formats of the report, it doesn't work with Web.
	Currency	Specify a currency of the report. All values will be automatically converted in the report to the specified currency.
	Code Deck	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. Warning Please be aware that if you do not specify the code deck, the system will use the code decks assigned to each pulled client or rate table. Code deck must contain code names and codes used for calls, otherwise the LCR report would not show results for missing codes and code names in the code deck.
	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.

LCR report has the following look (see screenshot):

Screenshot: LCR report

Each route, presented in a report, besides total number of events and vendors (displayed when respective checkboxes are marked) has the following data specified (see screenshot above):

Event volume;
Event rate;
ASR
ACD.

Also, you can create a template for reports and save specified parameters by clicking Save Query button. Visit our Report Templates article for a detailed information.

To query by template, press Load Query button and click on icon .

Export generated report

You can export data to a CSV and 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 an .xlsx report file, press Export to XLSx button above the report.

Attention

You can check an actual date interval by clicking on Info icon. The displayed data could be different from the Interval specified above if there is no date for the period.