ColumnHierarchyProperty Struct
The option that determines the hierarchy of the fields for a visual element.
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 columnHierarchyProperty: quicksight.CfnTemplate.ColumnHierarchyProperty = {
dateTimeHierarchy: {
hierarchyId: 'hierarchyId',
// the properties below are optional
drillDownFilters: [{
categoryFilter: {
categoryValues: ['categoryValues'],
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
},
numericEqualityFilter: {
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
value: 123,
},
timeRangeFilter: {
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
rangeMaximum: 'rangeMaximum',
rangeMinimum: 'rangeMinimum',
timeGranularity: 'timeGranularity',
},
}],
},
explicitHierarchy: {
columns: [{
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
}],
hierarchyId: 'hierarchyId',
// the properties below are optional
drillDownFilters: [{
categoryFilter: {
categoryValues: ['categoryValues'],
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
},
numericEqualityFilter: {
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
value: 123,
},
timeRangeFilter: {
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
rangeMaximum: 'rangeMaximum',
rangeMinimum: 'rangeMinimum',
timeGranularity: 'timeGranularity',
},
}],
},
predefinedHierarchy: {
columns: [{
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
}],
hierarchyId: 'hierarchyId',
// the properties below are optional
drillDownFilters: [{
categoryFilter: {
categoryValues: ['categoryValues'],
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
},
numericEqualityFilter: {
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
value: 123,
},
timeRangeFilter: {
column: {
columnName: 'columnName',
// the properties below are optional
dataSetIdentifier: 'dataSetIdentifier',
topicIdentifier: 'topicIdentifier',
},
rangeMaximum: 'rangeMaximum',
rangeMinimum: 'rangeMinimum',
timeGranularity: 'timeGranularity',
},
}],
},
};
Properties
dateTimeHierarchyoptionalIResolvable | CfnTemplate.DateTimeHierarchyPropertydate_time_hierarchyoptionaltyping.Union[IResolvable, DateTimeHierarchyProperty]dateTimeHierarchyoptionalIResolvableDateTimeHierarchyoptionalIResolvableDateTimeHierarchyoptionalinterface{}#The option that determines the hierarchy of any `DateTime` fields.
explicitHierarchyoptionalIResolvable | CfnTemplate.ExplicitHierarchyPropertyexplicit_hierarchyoptionaltyping.Union[IResolvable, ExplicitHierarchyProperty]explicitHierarchyoptionalIResolvableExplicitHierarchyoptionalIResolvableExplicitHierarchyoptionalinterface{}#The option that determines the hierarchy of the fields that are built within a visual's field wells.
These fields can't be duplicated to other visuals.
predefinedHierarchyoptionalIResolvable | CfnTemplate.PredefinedHierarchyPropertypredefined_hierarchyoptionaltyping.Union[IResolvable, PredefinedHierarchyProperty]predefinedHierarchyoptionalIResolvablePredefinedHierarchyoptionalIResolvablePredefinedHierarchyoptionalinterface{}#The option that determines the hierarchy of the fields that are defined during data preparation.
These fields are available to use in any analysis that uses the data source.