Aggregation Function - only

Summary

The only aggregation is provided by AdapTable to supplement the Aggregation Functions provided by AG Grid
It returns a value if that value is the only one that appears in the aggregated data group

AdapTable provides an only aggregation function for use in Grouped Layouts.

Note

This is in addition to the ONLY aggregation function in AdapTableQL, used in Calculated Columns

The only aggregation returns a value if that value is the only one that appears in the aggregated data group.

Hint

A set of [5, 5, 4] will return null, as will a set of [5, 5, null] - but a set of [5, 5, 5] will return 5

Aggregations: 'Only' Custom Aggregation

Fork Fork

In this example we group on the Language Column and provide 2 only aggregations - on the License and Issue Change Columns
We have also amended the usual row Data so that all the values for HTML in the License column are "MIT License", and all the TypeScript values in the Issues Change Column are "12"
As a result we see the only aggregation return these values for these 2 groups

import {AdaptableOptions} from '@adaptabletools/adaptable';
import {WebFramework} from './rowData';

export const adaptableOptions: AdaptableOptions<WebFramework> = {
  primaryKey: 'id',
  adaptableId: 'Only Aggregation',
  initialState: {
    Dashboard: {
      Tabs: [{Name: 'Demo', Toolbars: ['Layout']}],
    },
    StatusBar: {
      StatusBars: [
        {
          Key: 'Center Panel',
          StatusBarPanels: ['Layout'],
        },
      ],
    },
    Theme: {CurrentTheme: 'dark'},
    Layout: {
      CurrentLayout: 'Grouped Layout',
      Layouts: [
        {
          Name: 'Grouped Layout',
          RowGroupedColumns: ['language'],
          TableAggregationColumns: [
            {
              ColumnId: 'github_watchers',
              AggFunc: 'sum',
            },
            {
              ColumnId: 'github_stars',
              AggFunc: 'sum',
            },
            {
              ColumnId: 'week_issue_change',
              AggFunc: 'only',
            },
            {
              ColumnId: 'license',
              AggFunc: 'only',
            },
          ],
          RowGroupValues: {
            RowGroupDefaultBehavior: 'always-expanded',
          },
          TableColumns: [
            'name',
            'github_watchers',
            'license',
            'week_issue_change',
            'github_stars',
            'updated_at',
            'created_at',
            'language',
          ],
          ColumnSorts: [
            {
              ColumnId: 'language',
              SortOrder: 'Asc',
            },
          ],
        },
      ],
    },
    FormatColumn: {
      FormatColumns: [
        {
          Name: 'formatColumn-license-issue-change',
          Scope: {
            ColumnIds: ['license', 'week_issue_change'],
          },
          Style: {
            FontStyle: 'Italic',
            ForeColor: 'LightGreen',
            FontWeight: 'Bold',
            Alignment: 'Center',
          },
          RowScope: {
            ExcludeDataRows: true,
          },
        },
      ],
    },
    CustomSort: {
      CustomSorts: [
        {
          Name: 'customSort-language',
          ColumnId: 'language',
          SortedValues: ['HTML', 'TypeScript', 'JavaScript'],
        },
      ],
    },
  },
};

PreviousWeighted Averages NextFormatting Aggregations

Framework: