Skip to content
v2.274.0

PivotTableSortConfigurationProperty Struct ​

The sort configuration for a PivotTableVisual .

Example ​

ts
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_quicksight as quicksight } from 'aws-cdk-lib';
const pivotTableSortConfigurationProperty: quicksight.CfnTemplate.PivotTableSortConfigurationProperty = {
  fieldSortOptions: [{
    fieldId: 'fieldId',
    sortBy: {
      column: {
        direction: 'direction',
        sortBy: {
          columnName: 'columnName',

          // the properties below are optional
          dataSetIdentifier: 'dataSetIdentifier',
          topicIdentifier: 'topicIdentifier',
        },

        // the properties below are optional
        aggregationFunction: {
          attributeAggregationFunction: {
            simpleAttributeAggregation: 'simpleAttributeAggregation',
            valueForMultipleValues: 'valueForMultipleValues',
          },
          categoricalAggregationFunction: 'categoricalAggregationFunction',
          dateAggregationFunction: 'dateAggregationFunction',
          numericalAggregationFunction: {
            percentileAggregation: {
              percentileValue: 123,
            },
            simpleNumericalAggregation: 'simpleNumericalAggregation',
          },
        },
      },
      dataPath: {
        direction: 'direction',
        sortPaths: [{
          dataPathType: {
            pivotTableDataPathType: 'pivotTableDataPathType',
          },
          fieldId: 'fieldId',
          fieldValue: 'fieldValue',
        }],
      },
      field: {
        direction: 'direction',
        fieldId: 'fieldId',
      },
    },
  }],
};

Properties ​

fieldSortOptionsIResolvable | IResolvable | CfnTemplate.PivotFieldSortOptionsProperty[]field_sort_optionstyping.Union[IResolvable, typing.List[typing.Union[IResolvable, PivotFieldSortOptionsProperty]]]fieldSortOptionsIResolvableFieldSortOptionsIResolvableFieldSortOptionsinterface{}#
The field sort options for a pivot table sort configuration.