Page History

...

The list of query fields is as follows:

Information block

Field Description

Filters

On the Filters menu, select required parameters for the report. To cancel any filter, click the delete Image Modified 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 (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 Image Modified sign next to the Period. Specify the second interval for the report.

Panel

borderColor	#ccffcc
bgColor	#ccffcc
borderWidth	2px
borderStyle	solid

Image Modified Tip

When you select one of Time parameters for Group By, the end date of the Period 2 will be set automatically to make equal intervals of Period 1 and Period 2.

Reseller

Specify the name of target Reseller.

Mode

Choose the mode of the report:

All visible - all represented visually.
Hide External Originators - all external originators of the selected manager will not be displayed.
Hide External Clients - only events made by solely between clients of the chosen manager will be shown.

By default, field value is set to All visible

Group By

Select a grouping option, here you can choose and swap columns, as well as change its order. There are following accessible options to group data in reports:

Time: Year, Month, Day, Hour.
Clients: Income Client, Income Account, Income Code, Income Code Name, Orig Rate, Outcome Client, Outcome Account, Outcome Code, Outcome Code Name.
Extras: Service Name, Income Series.

Panel

borderColor	#ffffb3
bgColor	#ffffb3
borderWidth	2px

Attention

Please note, the Group By field is mandatory, it couldn't be left empty in order to generate the report.

Additional Filters

There are following accessible filters:

Clients: Income Client, Income Client's Tag, Income Account, Income Account's Tag, Income Code, Income Code Name, Income Serial, Income Reseller, Outcome Client, Outcome Client's Tag, Outcome Account, Outcome Account's Tag, Outcome Code, Outcome Code Name.
Extras: Package

Income Client

Specify an origination client(s) for the report

Income Client's Tag

Specify tag(s) assigned to orignation clients

Income Account

Determine origination client's account(s)

Income Account's Tag

Indicate origination account's tags

Income Code

Define an incoming code

Income Code Name

Specify an incoming code name

Income Serial

Indicate a serial number of originator's call card

Income Reseller

Specify target reseller(s) for the report

Outcome Client

Define a termination client(s)

Outcome Client's Tag

Define termination client's tag(s)

Outcome Account

Indcate account(s) of termination client(s) for the report

Outcome Account's Tag

Specify termination account's tags if any

Outcome Code

Specify a termination code of the client

Outcome Code Name

Indicate termination code name

Package

Determine a name of the used package

Output

This form contains settings of the output data of the report.

Click plus Image Modified 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

Additional columns of the report are:

Columns for main period:

Volume Total, Income Cost, Income Avg Rate, Income Billed Time, Outcome Cost, Outcome Avg Rate, Outcome Billed Time, Profit, Profit (%).

Columns for comparative period:

Total time, min; Income Rate, Outcome Rate, Income Cost, Income Avg Rate, Income Billed Time, Outcome Cost, Outcome Avg Rate, Outcome Billed Time, Profit, Profit (%), Profit Difference.
And it's possible to choose each parameter expressed as percentage.

Volume Total

Total time of calls in minutes

Rate

The call rate

Income Avg Rate - an average call rate that is used for origination
Outcome Avg Rate - an average call rate that is used for termination

Profit

The revenue

Profit - a revenue in a respective currency (in fact, any system currency can be specified here)
Profit (%) - a revenue in percent value

Time

The billed time

Income Billed Volume - the whole billed time for origination
Outcome Billed Volume - the whole billed time for termination

Cost

The call cost

Income Cost - a call cost that is used for origination
Outcome Cost - a call cost that is used for termination

Other output settings

Order By

Select parameters to sort already grouped data in columns. There are following accessible options to order the data: by Time, Clients, Extras.

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 next to the Type field a table view:

Plain - a simple table view
Grouped - a table view with grouped data and possibility to collapse / expand it

Panel

borderColor	#ffffb3
bgColor	#ffffb3
borderWidth	2px

Attention

Please note that Grouped type of table view is available only for Excel XLSx and Web formats, it doesn't work with CSV.

Limit

Determine the number of rows that will be visible in the report. It is useful for displaying some top positions by chosen parameter. It is available only for plain type of the report.

Send to

You can send generated reports via email. Also, it is possible to specify several emails.

Panel

borderColor	#ffffb3
bgColor	#ffffb3
borderWidth	2px

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 for the report.

And all values will be automatically converted in the report to the specified currency.

Code Deck

Using a drop-down list select a respective code deck. All codes names will be rewritten and presented according to the specified code deck.

If there is no value specified, code deck assigned to the Client or Rate Table will be in usage.

A generated profit report is demonstrated on a screenshot below:

...

Versions Compared

Old Version 2

New Version 3

Key