ColumnSortProperty Struct
The sort configuration for a column that is not used in a field well.
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 columnSortProperty: quicksight.CfnAnalysis.ColumnSortProperty = {
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',
},
},
};
python
# The code below shows an example of how to instantiate this type.
# The values are placeholders you should change.
from aws_cdk import aws_quicksight as quicksight
column_sort_property = quicksight.CfnAnalysis.ColumnSortProperty(
direction="direction",
sort_by=quicksight.CfnAnalysis.ColumnIdentifierProperty(
column_name="columnName",
# the properties below are optional
data_set_identifier="dataSetIdentifier",
topic_identifier="topicIdentifier"
),
# the properties below are optional
aggregation_function=quicksight.CfnAnalysis.AggregationFunctionProperty(
attribute_aggregation_function=quicksight.CfnAnalysis.AttributeAggregationFunctionProperty(
simple_attribute_aggregation="simpleAttributeAggregation",
value_for_multiple_values="valueForMultipleValues"
),
categorical_aggregation_function="categoricalAggregationFunction",
date_aggregation_function="dateAggregationFunction",
numerical_aggregation_function=quicksight.CfnAnalysis.NumericalAggregationFunctionProperty(
percentile_aggregation=quicksight.CfnAnalysis.PercentileAggregationProperty(
percentile_value=123
),
simple_numerical_aggregation="simpleNumericalAggregation"
)
)
)
java
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import software.amazon.awscdk.services.quicksight.*;
ColumnSortProperty columnSortProperty = ColumnSortProperty.builder()
.direction("direction")
.sortBy(ColumnIdentifierProperty.builder()
.columnName("columnName")
// the properties below are optional
.dataSetIdentifier("dataSetIdentifier")
.topicIdentifier("topicIdentifier")
.build())
// the properties below are optional
.aggregationFunction(AggregationFunctionProperty.builder()
.attributeAggregationFunction(AttributeAggregationFunctionProperty.builder()
.simpleAttributeAggregation("simpleAttributeAggregation")
.valueForMultipleValues("valueForMultipleValues")
.build())
.categoricalAggregationFunction("categoricalAggregationFunction")
.dateAggregationFunction("dateAggregationFunction")
.numericalAggregationFunction(NumericalAggregationFunctionProperty.builder()
.percentileAggregation(PercentileAggregationProperty.builder()
.percentileValue(123)
.build())
.simpleNumericalAggregation("simpleNumericalAggregation")
.build())
.build())
.build();
csharp
// Install: dotnet add package Amazon.CDK.Lib
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
using Amazon.CDK.AWS.QuickSight;
var columnSortProperty = new ColumnSortProperty {
Direction = "direction",
SortBy = new ColumnIdentifierProperty {
ColumnName = "columnName",
// the properties below are optional
DataSetIdentifier = "dataSetIdentifier",
TopicIdentifier = "topicIdentifier"
},
// the properties below are optional
AggregationFunction = new AggregationFunctionProperty {
AttributeAggregationFunction = new AttributeAggregationFunctionProperty {
SimpleAttributeAggregation = "simpleAttributeAggregation",
ValueForMultipleValues = "valueForMultipleValues"
},
CategoricalAggregationFunction = "categoricalAggregationFunction",
DateAggregationFunction = "dateAggregationFunction",
NumericalAggregationFunction = new NumericalAggregationFunctionProperty {
PercentileAggregation = new PercentileAggregationProperty {
PercentileValue = 123
},
SimpleNumericalAggregation = "simpleNumericalAggregation"
}
}
};
go
// Install: go get github.com/aws/aws-cdk-go/awscdk/v2
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import "github.com/aws/aws-cdk-go/awscdk"
columnSortProperty := &ColumnSortProperty{
Direction: jsii.String("direction"),
SortBy: &ColumnIdentifierProperty{
ColumnName: jsii.String("columnName"),
// the properties below are optional
DataSetIdentifier: jsii.String("dataSetIdentifier"),
TopicIdentifier: jsii.String("topicIdentifier"),
},
// the properties below are optional
AggregationFunction: &AggregationFunctionProperty{
AttributeAggregationFunction: &AttributeAggregationFunctionProperty{
SimpleAttributeAggregation: jsii.String("simpleAttributeAggregation"),
ValueForMultipleValues: jsii.String("valueForMultipleValues"),
},
CategoricalAggregationFunction: jsii.String("categoricalAggregationFunction"),
DateAggregationFunction: jsii.String("dateAggregationFunction"),
NumericalAggregationFunction: &NumericalAggregationFunctionProperty{
PercentileAggregation: &PercentileAggregationProperty{
PercentileValue: jsii.Number(123),
},
SimpleNumericalAggregation: jsii.String("simpleNumericalAggregation"),
},
},
}
Properties
aggregationFunctionoptionalIResolvable | CfnAnalysis.AggregationFunctionPropertyaggregation_functionoptionaltyping.Union[IResolvable, AggregationFunctionProperty]aggregationFunctionoptionalIResolvableAggregationFunctionoptionalIResolvableAggregationFunctionoptionalinterface{}#The aggregation function that is defined in the column sort.
The sort direction.
sortByIResolvable | CfnAnalysis.ColumnIdentifierPropertysort_bytyping.Union[IResolvable, ColumnIdentifierProperty]sortByIResolvableSortByIResolvableSortByinterface{}required#