Tariscope 4.6. User's guide
Chapter 2. Tariscope application
2.2. Working with views for calls
2.2.16 Grouping function
The grouping function allows you to aggregate rows displayed in a view using the specified parameters, summing up the data contained in other fields or to perform another aggregate function.
Aggregate functions can be used to the following actions:
- To sum data.
- To calculate a number of items in a group.
- To define a maximum value in a group.
- To define a minimum value in a group.
- To calculate an average value in a group.
Thus, in columns that were selected for grouping, you will see the unique data values in these columns, for example, types of calls. In all other columns, the sums or values of another aggregate function will be displayed, for example, a total duration of calls. That is, you can calculate, for example, a total duration of calls for a certain period for each subscriber, or the number of calls for each of the categories, etc. You can group data on one or more fields. For each of the fields, you can choose an aggregate function separately. The grouping feature is accessible for a view for calls, services, or IP traffic.
For example, in the view for calls you want to quickly determine how many calls of different types were made. Select a cell in the Call type column and click on the Grouping icon on the toolbar. An example of such a view is shown in Figure 2.2.16.1.
Figure 2.2.16.1
The Grouping window appears as it is shown in Figure 2.2.16.2. The window contains a list that allows you to select the desired options.
Figure 2.2.16.2
There are the following options:
- By this field.
- Default.
- Average.
- Count.
- Maximum.
- Minimum.
- Amount.
Leave the By this field item and click Group. The view page will be as shown in Figure 2.2.16.3.
Figure 2.2.16.3
In the column headings, in brackets, the name of the function that has been applied to a particular column by default will be displayed. The heading of the column whose cell was selected will display the word of Group. If you want to change the grouping function for a specific column, select a cell in that column and click the Grouping icon. In the appeared window, select the desired function and click Group.
For example, in Figure 2.2.16.4 the view with grouping function is shown where the Amount function was applied for the Call seconds column instead of the Average function.
Figure 2.2.16.4
If necessary, the data in the table can be sorted.
The result of grouping can be printed or exported to an external file.
You can use similar actions to create a wide range of different reports. But it should be borne in mind that Tariscope already contains a large number of ready-made forms of reports, so you can use these reports instead of the grouping function.
In conclusion, the knowledge of the SQL language is not required to use the grouping function. However, if you need to create more complex reports, you can use the Microsoft Report Builder program, whose work is based on SQL queries. Therefore, we recall that the grouping function corresponds to the next expression of SQL: GROUP BY.
