Cloudera Docs

Specifying default aggregation field for a dataset in NLS

In Data Visualization, you can specify which field's values report the default aggregation.

When a search phrase does not specify an aggregate measure, Data Visualization reports results of a default column as an aggregate. In the majority of cases, this default column is Record Count, a default aggregation measurement generated by the system.

In this example, inspection_score is selected to illustrate this functionality.

  1. Navigate to the Fields page on the dataset page.
  2. Click Edit Fields.
  3. Click Edit Field for the field that you want to use as an aggregate.
  4. Choose a Default Aggregation type from the drop-down list.
  5. Click APPLY.
  6. Navigate to the Search Modeling page.
  7. Select the Default Aggregation Field from the drop-down list.
  8. Click SAVE.

If you type 'inspection score' in the search bar you get an average score as a result.