Cloudera Docs

Changing field aggregation

You may find it useful to change the basic fields defaults in your dataset.

The following steps demonstrate how to change the default aggregation function from Sum to Average for the field

life_expectancy in the dataset World Life Expectancy [data source: main.world_life_expectancy].
  1. On the main navigation bar, click Data.

    The Data view appears, open on the Datasets tab.

  2. In the left navigation menu, click samples.
  3. In the Datasets area, select World Life Expectancy (samples.world_life_expectancy).
  4. In the Dataset Detail menu, select Fields.
  5. In the Fields interface, select Edit Fields.
  6. Under Measures, find the field life_expectancy and click the (down arrow)icon on its right side.
  7. From the menu, select Edit Fields.

    The Edit Field Parameters window modal appears.

  8. Change Default Aggregation from Sum to Average, and click Apply.

    The Edit Field Parameters window modal appears.

  9. Under Dataset: World Life Expectancy, click Save.

As a result of this change, all new visuals created from this dataset will automatically use the new aggregation.