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.