Skip to content
v2.277.0

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.