interface TopicCalculatedFieldProperty
| Language | Type name |
|---|---|
.NET | Amazon.CDK.Mixins.Preview.AWS.QuickSight.Mixins.CfnTopicPropsMixin.TopicCalculatedFieldProperty |
Go | github.com/aws/aws-cdk-go/awscdkmixinspreview/v2/awsquicksight/mixins#CfnTopicPropsMixin_TopicCalculatedFieldProperty |
Java | software.amazon.awscdk.mixins.preview.services.quicksight.mixins.CfnTopicPropsMixin.TopicCalculatedFieldProperty |
Python | aws_cdk.mixins_preview.aws_quicksight.mixins.CfnTopicPropsMixin.TopicCalculatedFieldProperty |
TypeScript | @aws-cdk/mixins-preview » aws_quicksight » mixins » CfnTopicPropsMixin » TopicCalculatedFieldProperty |
A structure that represents a calculated field.
Example
// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { mixins as quicksight_mixins } from '@aws-cdk/mixins-preview/aws-quicksight';
const topicCalculatedFieldProperty: quicksight_mixins.CfnTopicPropsMixin.TopicCalculatedFieldProperty = {
aggregation: 'aggregation',
allowedAggregations: ['allowedAggregations'],
calculatedFieldDescription: 'calculatedFieldDescription',
calculatedFieldName: 'calculatedFieldName',
calculatedFieldSynonyms: ['calculatedFieldSynonyms'],
cellValueSynonyms: [{
cellValue: 'cellValue',
synonyms: ['synonyms'],
}],
columnDataRole: 'columnDataRole',
comparativeOrder: {
specifedOrder: ['specifedOrder'],
treatUndefinedSpecifiedValues: 'treatUndefinedSpecifiedValues',
useOrdering: 'useOrdering',
},
defaultFormatting: {
displayFormat: 'displayFormat',
displayFormatOptions: {
blankCellFormat: 'blankCellFormat',
currencySymbol: 'currencySymbol',
dateFormat: 'dateFormat',
decimalSeparator: 'decimalSeparator',
fractionDigits: 123,
groupingSeparator: 'groupingSeparator',
negativeFormat: {
prefix: 'prefix',
suffix: 'suffix',
},
prefix: 'prefix',
suffix: 'suffix',
unitScaler: 'unitScaler',
useBlankCellFormat: false,
useGrouping: false,
},
},
disableIndexing: false,
expression: 'expression',
isIncludedInTopic: false,
neverAggregateInFilter: false,
nonAdditive: false,
notAllowedAggregations: ['notAllowedAggregations'],
semanticType: {
falseyCellValue: 'falseyCellValue',
falseyCellValueSynonyms: ['falseyCellValueSynonyms'],
subTypeName: 'subTypeName',
truthyCellValue: 'truthyCellValue',
truthyCellValueSynonyms: ['truthyCellValueSynonyms'],
typeName: 'typeName',
typeParameters: {
typeParametersKey: 'typeParameters',
},
},
timeGranularity: 'timeGranularity',
};
Properties
| Name | Type | Description |
|---|---|---|
| aggregation? | string | The default aggregation. |
| allowed | string[] | The list of aggregation types that are allowed for the calculated field. |
| calculated | string | The calculated field description. |
| calculated | string | The calculated field name. |
| calculated | string[] | The other names or aliases for the calculated field. |
| cell | IResolvable | (IResolvable | Cell)[] | The other names or aliases for the calculated field cell value. |
| column | string | The column data role for a calculated field. |
| comparative | IResolvable | Comparative | The order in which data is displayed for the calculated field when it's used in a comparative context. |
| default | IResolvable | Default | The default formatting definition. |
| disable | boolean | IResolvable | A Boolean value that indicates if a calculated field is visible in the autocomplete. |
| expression? | string | The calculated field expression. |
| is | boolean | IResolvable | A boolean value that indicates if a calculated field is included in the topic. |
| never | boolean | IResolvable | A Boolean value that indicates whether to never aggregate calculated field in filters. |
| non | boolean | IResolvable | The non additive for the table style target. |
| not | string[] | The list of aggregation types that are not allowed for the calculated field. |
| semantic | IResolvable | Semantic | The semantic type. |
| time | string | The level of time precision that is used to aggregate DateTime values. |
aggregation?
Type:
string
(optional)
The default aggregation.
Valid values for this structure are SUM , MAX , MIN , COUNT , DISTINCT_COUNT , and AVERAGE .
allowedAggregations?
Type:
string[]
(optional)
The list of aggregation types that are allowed for the calculated field.
Valid values for this structure are COUNT , DISTINCT_COUNT , MIN , MAX , MEDIAN , SUM , AVERAGE , STDEV , STDEVP , VAR , VARP , and PERCENTILE .
calculatedFieldDescription?
Type:
string
(optional)
The calculated field description.
calculatedFieldName?
Type:
string
(optional)
The calculated field name.
calculatedFieldSynonyms?
Type:
string[]
(optional)
The other names or aliases for the calculated field.
cellValueSynonyms?
Type:
IResolvable | (IResolvable | Cell)[]
(optional)
The other names or aliases for the calculated field cell value.
columnDataRole?
Type:
string
(optional)
The column data role for a calculated field.
Valid values for this structure are DIMENSION and MEASURE .
comparativeOrder?
Type:
IResolvable | Comparative
(optional)
The order in which data is displayed for the calculated field when it's used in a comparative context.
defaultFormatting?
Type:
IResolvable | Default
(optional)
The default formatting definition.
disableIndexing?
Type:
boolean | IResolvable
(optional)
A Boolean value that indicates if a calculated field is visible in the autocomplete.
expression?
Type:
string
(optional)
The calculated field expression.
isIncludedInTopic?
Type:
boolean | IResolvable
(optional, default: false)
A boolean value that indicates if a calculated field is included in the topic.
neverAggregateInFilter?
Type:
boolean | IResolvable
(optional, default: false)
A Boolean value that indicates whether to never aggregate calculated field in filters.
nonAdditive?
Type:
boolean | IResolvable
(optional, default: false)
The non additive for the table style target.
notAllowedAggregations?
Type:
string[]
(optional)
The list of aggregation types that are not allowed for the calculated field.
Valid values for this structure are COUNT , DISTINCT_COUNT , MIN , MAX , MEDIAN , SUM , AVERAGE , STDEV , STDEVP , VAR , VARP , and PERCENTILE .
semanticType?
Type:
IResolvable | Semantic
(optional)
The semantic type.
timeGranularity?
Type:
string
(optional)
The level of time precision that is used to aggregate DateTime values.

.NET
Go
Java
Python
TypeScript