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.
      • 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).

        Summary Functions
  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. 
  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.

Summary Tab