Configuring Summary SQL Operation for Chart View

Follow these steps to configure the criteria the chart view uses to summarizes the grouped data.

1. Click the Summary tab.
2. From the Summary Function drop-down list, specify the function that you want to use to summarize the data for each grouping on the chart. In general, most users will select either Count or Sum.
   • • Count: The chart counts the number of data items per group. Typically, the Count function is used to count the number of records per group (such as the number of records of each Database Object type in the system).
     • Sum: The chart sums up the value of the summary field for each group.
     • Minimum: A group's chart value corresponds to the record's whose summary field has the smallest value in the group.
     • Maximum: A group's chart value corresponds to the record's whose summary field has the greatest value in the group.
     • Average: A group's chart value corresponds to the average value of the summary field for the records in the group.
     • Standard Deviation: A group's chart value corresponds to the standard deviation of the summary field values for the records in the group.
     • The standard deviation is a measure of the variability of a series of data about its mean value. The standard deviation is equal to the square root of the Variance, from which it is derived, and measures the sum of the differences between a series' values and its mean.
     • A standard deviation can describe either a sample of data items or the entire population. For the latter, select Standard Deviation (Population).
       
       
   • Variance: A group's chart value corresponds to the variance of the summary field values for the records in the group.
   1. • Variance is a measure of the spread or dispersion of a variable about its mean or average value. The variance is calculated by taking the sum of the squares of the deviations, that is, the sum of the difference between each record's value and the series mean value, and dividing by the sample size (number of records).
      • Variance can describe either a sample of data items or the entire population. For the latter, select Variance (Population).
        
        
3. From the Summary Field drop-down list, select the field in the service whose data you want to be summarized in the chart view. 
   • The Summary Field is not applicable if Count is selected as the function.
     
     
4. Advanced users who are familiar with SQL can specify their own Summary SQL statement. Select the Customize Summary Method option and enter a custom SQL statement in the Summary SQL text field.