Define Column Aggregations Dialog Box

The Define Column Aggregations dialog box enables you to specify the group-by columns, aggregation type, and data type for an aggregate calculation.

Aggregation type options:

  • sum
  • count
  • count distinct
  • min
  • max
  • avg
  • variance
  • stddev
  • custom

Data type options:

  • BIGINT
  • BOOLEAN
  • BIT
  • BIT VARYING
  • CHAR
  • DATE
  • DOUBLE PRECISION
  • NUMERIC
  • INTEGER
  • INTERVAL
  • TIMESTAMP
  • TIME
  • VARCHAR