Skip to content
v2.275.0

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.