ValueColumnConfigurationProperty Struct
Configuration for how to handle value columns in pivot operations, including aggregation settings.
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 valueColumnConfigurationProperty: quicksight.CfnDataSet.ValueColumnConfigurationProperty = {
aggregationFunction: {
listAggregation: {
distinct: false,
separator: 'separator',
// the properties below are optional
inputColumnName: 'inputColumnName',
},
percentileAggregation: {
percentileValue: 123,
// the properties below are optional
inputColumnName: 'inputColumnName',
},
simpleAggregation: {
functionType: 'functionType',
// the properties below are optional
inputColumnName: 'inputColumnName',
},
},
};
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
value_column_configuration_property = quicksight.CfnDataSet.ValueColumnConfigurationProperty(
aggregation_function=quicksight.CfnDataSet.DataPrepAggregationFunctionProperty(
list_aggregation=quicksight.CfnDataSet.DataPrepListAggregationFunctionProperty(
distinct=False,
separator="separator",
# the properties below are optional
input_column_name="inputColumnName"
),
percentile_aggregation=quicksight.CfnDataSet.DataPrepPercentileAggregationFunctionProperty(
percentile_value=123,
# the properties below are optional
input_column_name="inputColumnName"
),
simple_aggregation=quicksight.CfnDataSet.DataPrepSimpleAggregationFunctionProperty(
function_type="functionType",
# the properties below are optional
input_column_name="inputColumnName"
)
)
)
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.*;
ValueColumnConfigurationProperty valueColumnConfigurationProperty = ValueColumnConfigurationProperty.builder()
.aggregationFunction(DataPrepAggregationFunctionProperty.builder()
.listAggregation(DataPrepListAggregationFunctionProperty.builder()
.distinct(false)
.separator("separator")
// the properties below are optional
.inputColumnName("inputColumnName")
.build())
.percentileAggregation(DataPrepPercentileAggregationFunctionProperty.builder()
.percentileValue(123)
// the properties below are optional
.inputColumnName("inputColumnName")
.build())
.simpleAggregation(DataPrepSimpleAggregationFunctionProperty.builder()
.functionType("functionType")
// the properties below are optional
.inputColumnName("inputColumnName")
.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 valueColumnConfigurationProperty = new ValueColumnConfigurationProperty {
AggregationFunction = new DataPrepAggregationFunctionProperty {
ListAggregation = new DataPrepListAggregationFunctionProperty {
Distinct = false,
Separator = "separator",
// the properties below are optional
InputColumnName = "inputColumnName"
},
PercentileAggregation = new DataPrepPercentileAggregationFunctionProperty {
PercentileValue = 123,
// the properties below are optional
InputColumnName = "inputColumnName"
},
SimpleAggregation = new DataPrepSimpleAggregationFunctionProperty {
FunctionType = "functionType",
// the properties below are optional
InputColumnName = "inputColumnName"
}
}
};
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"
valueColumnConfigurationProperty := &ValueColumnConfigurationProperty{
AggregationFunction: &DataPrepAggregationFunctionProperty{
ListAggregation: &DataPrepListAggregationFunctionProperty{
Distinct: jsii.Boolean(false),
Separator: jsii.String("separator"),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
PercentileAggregation: &DataPrepPercentileAggregationFunctionProperty{
PercentileValue: jsii.Number(123),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
SimpleAggregation: &DataPrepSimpleAggregationFunctionProperty{
FunctionType: jsii.String("functionType"),
// the properties below are optional
InputColumnName: jsii.String("inputColumnName"),
},
},
}
Properties
aggregationFunctionoptionalIResolvable | CfnDataSet.DataPrepAggregationFunctionPropertyaggregation_functionoptionaltyping.Union[IResolvable, DataPrepAggregationFunctionProperty]aggregationFunctionoptionalIResolvableAggregationFunctionoptionalIResolvableAggregationFunctionoptionalinterface{}#The aggregation function to apply when multiple values map to the same pivoted cell.