Changing Field Aggregation

You can apply functions to data fields to display aggregate information, such as the sum of impressions for a printer.

All the aggregate functions can be applied to numeric fields. You cannot apply aggregate functions to fields in dimension field wells.

By default, the Count function is automatically applied to a dimension if you choose to use it in a field well that expects a measure. You can apply one of the other aggregate functions instead.

These aggregate functions are available:

  • Average – Calculates the average value for the selected field.
  • Count – Provides a count of the number of records containing the selected measure for a given dimension.
  • Distinct Count – Provides a count of how many different values are in the selected measure, for the selected dimension or dimensions.
  • Max – Calculates the maximum value for the selected field.
  • Min – Calculates the minimum value for the selected field.
  • Median – Calculates the median value of the specified measure, grouped by the chosen dimension or dimensions.
  • Sum – Totals all of the values for the selected field.
  • Standard Deviation – Calculates the standard deviation of the set of numbers in the specified measure, grouped by the chosen dimension or dimensions, based on a sample or on a biased population.
  • Variance – Calculates the variance of the set of numbers in the specified measure, grouped by the chosen dimension or dimensions, based on a sample or on a biased population.
  • Percentile – Computes the nth percentile of the specified measure, grouped by the chosen dimension or dimensions.

To change the aggregation function for a field:
  1. Click Dashboards tab, the Dashboards tab.
  2. Click Dashboard Designer, in the bottom-left corner.
  3. On the Analyses dialog, click Options button, the Options button, next to an existing analysis and select Edit.
  4. On the analysis page, select a visual.
  5. Click Visualize button, the Visualize button, on the toolbar to display the Visuals panel.Analysis page - Edit a visual
  6. In the Visuals panel, click Options button, the Options button, next to a field, then select Aggregate and one of the available aggregate functions.
    The visual elements that support aggregated fields depend on the visual type.
In visuals that display field labels, you can also configure field settings directly from the visual. Click Options button, the Options button, next to a field label and select an option from the menu.
Parent topic: Customizing Data Presentation