Tariscope 4.6. User's guide
Chapter 2. Tariscope application
2.2. Working with views for calls
2.2.1 Creating or selecting a view for calls
If you have already started the process of collecting data about the calls and you want to analyze the data, create a new view for calls. To work with the views, in the Tariscope menu, select Views → Views list. The Views page appears an example of which is shown in Figure 2.2.1.1.
Figure 2.2.1.1
The Views page contains a toolbar, table with views, and text box to search.
The toolbar includes the following icons:
- Open. It is intended to open the selected view. If you did not select a view, this icon is not available.
- Add. The item allows you to create a new view.
- Group management. This item is used to create, change, or delete a group of views.
- Edit. It allows to change the selected view settings such as: a list of fields to display, sorting, grouping, and filtering. The icon is not applied to the views from the Standard views group.
- Relocate. The item allows you to move the selected view from one group to another.
- Delete. Deletes the selected view. You cannot delete a view from the Standard views group.
- Create shared copy. All new views are created only for user who create them. To share a view to other users, use this icon.
- Copy for yourself. This icon is active only if you selected a view in the Shared views group. The group is appeared when a user had created a shared copy of the view.
- Background calls recharge. The item allows you to recharge calls of the selected views in the background.
- Traffic calculation. Allows to create a graph of calls traffic.
- Show filters. This icon provides a selection of filter to apply it in the view. A list of filters contains standard filters and filters which were created by user.
- Find duplicate records. It allows to find and delete duplicate records in the calls database.
- Export to file. This icon provides an export of the view table to one of the following files: Excel, HTML, CSV, or PDF.
By default, the Views page contains only the Standard views group. The group includes the following views:
- Cost distribution by groups for previous month.
- Cost distribution by groups for this month.
- Cost distribution by subscribers for previous month.
- Cost distribution by subscribers for this month.
- Last call date and time by equipment.
- Outgoing calls for the last month without subscribers.
- Subscribers charges previous month.
- The highlighted long-distance calls for this month in off-peak time.
- The highlighted long-distance calls for the previous month.
- Top-1000 longest calls for previous month.
- Top-1000 longest calls this month.
- Top-1000 most expensive calls this month.
- Unanswered calls for today.
The Tariscope user can use one of these views or create an own view.
To create a view, click on the Add icon on the toolbar. The menu is appeared that contains the following items:
- Create a view for calls.
- Create a provider summary view.
- Create a view for services.
- Create a view for IP traffic.
Select the Create a view for calls. The New view for calls page appears is as it is shown in Figure 2.2.1.2.
Figure 2.2.1.2
In the View name box, enter a view name that displays the purpose of the view.
The Row limit (zero for no limit) box contains by default the value of 1000. This means that the view will display only 1000 records. You can change the value. To display all records, change the value to 0. We recommend limiting the number of records.
The Equipment position allows you to select a single telephone system or group of telephone systems for which call information will display. Click on the button located right on the position. The Equipment window appears. Select the desired PBXs. If you have only a single PBX, do not do anything here.
The Period list allows you to select a period to display calls information. The list includes the next options:
- Today.
- Yesterday.
- This week.
- Last week.
- This month.
- Last month.
- This year.
- Last year.
- Selected month.
- Selected year.
- Custom period.
If you have selected the Selected month option, two lists appear: Year and Month. Select in these lists the required year and month.
If you have selected the Selected year option, the Year list appears. Select the required year.
If you have selected the Custom period option, the From and To calendar boxes appear. Specify the required period in these boxes.
The next filtering parameters are on the General and Advanced tabs.
The General tab (Figure 2.2.1.2) contains the following parameters.
The Source list allows you to select a call originator. There are the next options:
- Auto.
- Extension.
- External number.
- Subscriber.
- Group.
- Route, trunk, gateway.
- List.
Consider each of these options.
The Auto option allows you to select all records that contain the value entered in the Source value box. The selection will be executed in the view fields: Originator, Number A, From subscriber, From telephone.
If you have selected the Extension option, the Select button appears on the right of the Source value box. Click on the button. The Extensions window appears that contains a list on extensions. Select the desired extension. The records will be selected that contains the same value in the Originator column of the view.
The External number option allows you to select incoming calls where the call was made from the telephone number the value of which equals to a value entered in the Source value box.
If you have selected the Subscriber option, the Select button appears on the right from the Source value box. Click on the button. The Subscribers window appears. Choose the desired subscriber.
If you have selected the Group option, the Select button appears on the right from the Source value box. Click on the button. The Groups window appears. Choose the desired group the subscribers of which made calls.
If you have selected the Route, trunk, gateway option, the Select button appears on the right from the Source value box. Click on the button. The Routes, trunks, gateways window appears. Choose the desired route, trunk or gateway from which calls were made.
If you need to select the records where calls were made from some extensions or external telephone numbers, choose the List item in the Source list and enter a list of extensions and/or external telephone numbers from which calls were made. These extensions or telephone numbers are displayed in the Number A column of a view.
The Destination list and the Destination value allows you to specify an object to which calls were made. This list contains the same options as the Source list.
The From city box allows you to filter incoming calls, where the originator is. Specify a city (town) name in the box.
The To city box allows you to filter outgoing and transit calls, where the destination is located. Specify a city (town) name in the box.
The Direction list allows you to select calls the directions of which correspond to the selected values. There are the following values:
- Unknown.
- Internal.
- Incoming.
- Outgoing.
- Transit.
The Call type list allows you to choose calls the call type of which corresponds to the selected values in this list:
- Unknown.
- Internal.
- Incoming.
- Local.
- National.
- International.
- Mobile.
- Transit.
- Call start.
- Data Transfer (Traffic).
- Data Transfer (Duration).
- VoIP.
- Corporate.
- SMS.
- Free line.
- Paid line.
The Record type list allows you to select calls that have the record type corresponded to the selected values in this list. There are the following options:
- Unknown.
- Regular.
- Transfer.
- Conference.
- Not answered.
- Realtime.
- Imported.
- DataFlow.
- Automatic Call Distribution.
- Automatic Call Distribution transfer.
- Automatic Call Distribution conference.
- Voice over IP.
- TextMessage.
The Release cause list allows you to select calls with the specific release cause. There are the following options in the list:
- Unknown.
- Unassigned number.
- No route to specified transit network.
- No route to destination.
- Send special information tone.
- Misdialed trunk.
- and others.
In the case when you need to unite the set filter parameters with previously saved filter, the Combine with filter lists are used. In the right list, where the word of OR is displayed, select the logical function, which will unite the set filter parameters with the saved filter. In the left list, select the name of desired saved filter.
There are additional filter parameters that are set on the Advanced tab (Figure 2.2.1.3).
This tab includes the following filter parameters.
The Auth code box allows you to select calls that were made with authorization code entered in this box.
The Category list allows you to select calls that match certain categories.
The Cost from box allows you to filter calls, which have the cost more than the specified value.
The Cost to box allows you to filter calls, which have the cost less than the specified value.
If you need to select calls for specific day of the week, use the Day type list. Select the desired day types. The following values are available:
- Unknown.
- Workday.
- Saturday.
- Sunday.
- Holiday.
Figure 2.2.1.3
If you need to select calls for specific day period, use the Time of day calendar boxes. Select the From and/or To calendar boxes and set the desired period.
If you want to filter calls with the specific duration, use the Duration calendar boxes (From, To).
If you want to filter calls with the specific ring time, use the TTA calendar boxes (From, To).
If you wish to look at a part of SQL query that is after the word WHERE of the query for the set filter parameters, click on the Show query button. The SQL Editor window appears. An example of the window is shown in Figure 2.2.1.4.
Figure 2.2.1.4
You can change the query and save it. Only users with rights of Tariscope administrators have ability to change the query
Also, you can choose the desired fields which will be displayed in the view. To do this, click on the Configuring the view fields button. The Select columns to display window appears as shown in Figure 2.2.1.5.
Figure 2.2.1.5
Choose the desired fields and click OK. A list of a view for calls is described below.
If you have set all desired parameters for view, click on the Save button. The view is displayed that contains calls which correspond to the filter parameters.
To open an existing view, choose it on the Views page and click on the Open icon in the toolbar.
