Fields Details -------------- Overview ........... The data elements in the **Fields** box have several analytic options depending on the context of the field and the desired functions, (e.g. Integer Field with a SUM Calculation). The following field type options are available: * Text * Integer * Calculate Text Fields ............. If the extracted field is a text field, the **Field Type** value is "Text". The **Title** is automatically populated with the field name from the log. This title can be changed to describe more accurately the data field. An **Operation** box provides these options: .. tabularcolumns:: |p{5cm}|p{10cm}| +-----------------------------------+----------------------------------------------------------------------+ | Option | Description | +===================================+======================================================================+ | Grouping Count | Groups all of the same fields and counts the number of times they | | | occur in the data, for example: Field is Acme Trading and it | | | occurred 35 times. The output will be Acme Trading count of 35. | +-----------------------------------+----------------------------------------------------------------------+ | Select Query | Allows you to choose to output all records from the query without | | | grouping them. Warning: This could result in a tremendous amount of | | | data depending on the topic being analyzed. Example is a call table | | | that could return millions of rows. | +-----------------------------------+----------------------------------------------------------------------+ | Count | Returns the total count of the value. If there are 1000 | | | occurrences of the value "350" the output will be 1000. | +-----------------------------------+----------------------------------------------------------------------+ | Partition By and Partition Order | These two functions are specific to our PostgreSQL database and | | | allow you to show the most recent or the earliest entries in the | | | data. | | | They are utilized with the "Select Query" on the data set. | +-----------------------------------+----------------------------------------------------------------------+ |analytics-fields-details-text| Integer Fields ................. If the extracted field is an integer field then it will show *Integer* in the **Field Type**. The **Title** is automatically populated with the field name from the log. This title can be changed to describe more accurately the data field. An **Operation** box provides eight options: .. tabularcolumns:: |p{5cm}|p{10cm}| +-----------------------------------+----------------------------------------------------------------------+ | Option | Description | +===================================+======================================================================+ | Grouping Count | Groups all of the same fields and counts the number of times they | | | occur in the data, for example: Field is the value "350" and it | | | occurred 10 times. The output will be 350 count of 10. | +-----------------------------------+----------------------------------------------------------------------+ | Select Query | Allows you to choose to output all records from the query without | | | grouping them. Warning: This could result in a tremendous amount of | | | data depending on the topic being analyzed. Example is a call table | | | that could return millions of rows. | +-----------------------------------+----------------------------------------------------------------------+ | Count | Will return the total count of the value. If there are 1000 | | | occurrences of the value "350", the output will be 1000. | +-----------------------------------+----------------------------------------------------------------------+ | Min | Will calculate the minimum value that has occurred in the data and | | | output that value. | +-----------------------------------+----------------------------------------------------------------------+ | Max | Will calculate the maximum value that has occurred in the data and | | | output that value. | +-----------------------------------+----------------------------------------------------------------------+ | Avg | Will calculate the average value of all the data and output that | | | value. | +-----------------------------------+----------------------------------------------------------------------+ | Sum | Will calculate the sum of all the data and output that value. | +-----------------------------------+----------------------------------------------------------------------+ | Variance | Will calculate the variance within the data and output that value. | | | Variance is how far a set of integers are spread out, thus a | | | variance value of zero indicates that all the values are identical. | +-----------------------------------+----------------------------------------------------------------------+ | Stddev | Will calculate the standard deviation within the data and output | | | that value. Standard deviation will quantify the amount of variation | | | or dispersion of the data set. A value close to zero indicates that | | | the data points are close to the *mean* or the expected value while | | | a high value indicates that the data points are spread out over a | | | wide range of values. | +-----------------------------------+----------------------------------------------------------------------+ | Partition By and Partition Order | These two functions are specific to our PostgreSQL database and | | | allow you to show the most recent or the earliest entries in the | | | data. They are utilized with the "Select Query" on the data set. | +-----------------------------------+----------------------------------------------------------------------+ |analytics-fields-details-integer| Calculated Fields .................... If the extracted field is a pre calculated field, then it will show *Calculated* in the **Field Type**. The **Title** is automatically populated with the field name used in the database. This title can be changed to describe more accurately the data field. An **Operation** box provides two options: +-----------------------------------+----------------------------------------------------------------------+ | Option | Description | +===================================+======================================================================+ | Value | Will output the exact value of the calculated field, for example: | | | The calculation is the count of all failed calls then the output | | | will be that value. | +-----------------------------------+----------------------------------------------------------------------+ | Sum | Will sum up all the values of the calculated filed, for example: The | | | calculation is the call failure ratio then the output will be the | | | sum of all of these values. | +-----------------------------------+----------------------------------------------------------------------+ |analytics-fields-details-calculate| .. |analytics-fields-details-text| image:: /src/images/analytics-fields-details-text.png .. |analytics-fields-details-integer| image:: /src/images/analytics-fields-details-integer.png .. |analytics-fields-details-calculate| image:: /src/images/analytics-fields-details-calculate.png