|
- Diagram Editor
- The Diagram Editing is possible in the web interface and in the special dialog. They look differently but have the same functionality indeed.
- Diagram parameter
- Each diagram has two main configuration parameters: Diagram Name and Data Source Name. Datasource will be explained in the details later. The base idea is to separate data reception/parsing (Data Source) and data processing (Diagram). In that case, it is possible to have multiple various diagrams on same data source. Data Source is chosen from the DataSource List
- Diagram sample
- Let us examine the diagram internals with the example of phone call data. There is a table of data to analyze.
| rec num | Date | Internal phone number | External number | call duration (sec) | | 1 | 1 Jan 2005 | 101 | 90431143 | 65 | | 2 | 2 Jan 2005 | 111 | 42758248 | 12 | | 3 | 2 Jan 2005 | 112 | 90431143 | 45 | | 4 | 3 Jan 2005 | 111 | 42758248 | 68 | | 5 | 3 Jan 2005 | 112 | 90431143 | 41 | | 6 | 3 Jan 2005 | 112 | 90328181 | 22 | | 7 | 4 Jan 2005 | 105 | 90431143 | 600 |
- Filter allows to extract only part of data records to analyze. For example, we could take into account only records with internal phone number not equal to "101". For that purpose you should create filter, name it (ex: "Except 101 phone"), choose the field we are interesting ("internal phone number"), set the expression ("101"), and set inversion parameter to "yes". It means that the filter will pass all the record which internal phone number is not equal "101". There is the possibility to create many filters on any available fields (including different filters on the same field). You could also create more complex filter expression. If you want to count records of January 2005 only, the field will be "Date", the Invert will be "No" and expression will be "[0-9]+ +Jan +2005" See Regular Expressions for the details
- Groups. After the records were filtered, you will be ready to create the diagram itself. First, you should decide what field (or fields) would be used for main diagram axis. Let us try to create the diagram by date. It means you should create single group by "Date" field with the expression equal to ".*". It means any Date field content will be used. As the result in our sample we will have four points in the main diagram axis (for 1,2,3,4 of January). Expression parameter gives you the ability to create complex diagrams. In the case you want to calculate something for the internal phone numbers 101/105 together (one axis point) and 111/112 the second axis point, you should use the expression "1[0-9]". It means we make no difference in last digit, first digit must be "1" and we will group all the data by second digit only. In the other words, we can extract any complex part of any field and use for grouping. Each the result group appears as separate point on the main diagram axis.
You can group by several fields simultaneously creating the separate group strings in Groups list. For example, you are interesting in average phone call duration by each day and each internal phone. In that case, you should create two groups: one for Date field and one for Internal Phone Number field. Both have to have expression set to ".*" as you do not mark any special Dates of Phone Numbers. - Axises allows you to create as many data values on each group as you want. For example, we grouped the input data field "Date". We want to count number of all phone calls and number of calls from 101/105 phones. We should create two axises. First axis will enumerate all phone calls. You could use any field for the calculation, because record count does not depend on field. the Expression must be set to ".*" and the operation - to "COUNT". The second axis will be a little bit complex. Field must be set to "Internal Phone Number", Expression to "10". It means you will count number starts from 10. The operation will be count again.
All the possible operations for calculating inside group are: - MIN calculates Minimum value in a group
- MAX calculates Maximum value in a group
- AVERAGEfinds average value in a group
- SUM sums all group values( including time/duration values in HH:MM:SS format
- COUNT calculates values quantity in a group
- FIRST finds first value in a group
- LAST finds last value in a group
Do not forget to set understandable names for the axises/groups/filters. It will help you to make needed diagram modifications
Note the graphic (3D) view is possible only with digit fields. If a field is not a digit, it will look like zero value in graph. In that case, you should use text form output. - Diagram Dialog
-
 Diagram Dialog contains fields - Diagram Name to set a name of the diagram
- Data source allows you to choose what the data source log is used by the diagram
- Filter is the list of available filters for initial data filtering. Filters can be inserted modified or deleted.
- Groups is the list of available groups
- Axises is the list of available axises
No parameter above can be modified in running diagram. To modify the diagram it must be previously stopped. The modifications can be performed by keyboard or right mouse button menu. Fields will be chosen from available fields list. The field list is determined by the DataSource. Each Data Source has its correspondent list of available fields. - Every expression value could be edited via the special editing form allowing you to test regular expression manually before it will be used as diagram parameter.
- The last list is Monitor. This list helps you to verify accuracy of the diagram parameters above. The diagrams contains several last log data strings. Pressing the Monitor button, you will see the processing results of that strings (filter passing, result group name and the result value) will be added to the statistics by each axis.
- Editing Diagrams via Web
-
 All of these parameters could be modified via web interface. - Continue returns you to the diagram list
- Launch activates (starts) the diagram before returning to the diagram list
|
Windows 7 Firewall Control
