PivotTableOptionsProperty Struct
The table options for a pivot table visual.
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 pivotTableOptionsProperty: quicksight.CfnTemplate.PivotTableOptionsProperty = {
cellStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontFamily: 'fontFamily',
fontSize: {
absolute: 'absolute',
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
collapsedRowDimensionsVisibility: 'collapsedRowDimensionsVisibility',
columnHeaderStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontFamily: 'fontFamily',
fontSize: {
absolute: 'absolute',
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
columnNamesVisibility: 'columnNamesVisibility',
defaultCellWidth: 'defaultCellWidth',
metricPlacement: 'metricPlacement',
rowAlternateColorOptions: {
rowAlternateColors: ['rowAlternateColors'],
status: 'status',
usePrimaryBackgroundColor: 'usePrimaryBackgroundColor',
},
rowFieldNamesStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontFamily: 'fontFamily',
fontSize: {
absolute: 'absolute',
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
rowHeaderStyle: {
backgroundColor: 'backgroundColor',
border: {
sideSpecificBorder: {
bottom: {
color: 'color',
style: 'style',
thickness: 123,
},
innerHorizontal: {
color: 'color',
style: 'style',
thickness: 123,
},
innerVertical: {
color: 'color',
style: 'style',
thickness: 123,
},
left: {
color: 'color',
style: 'style',
thickness: 123,
},
right: {
color: 'color',
style: 'style',
thickness: 123,
},
top: {
color: 'color',
style: 'style',
thickness: 123,
},
},
uniformBorder: {
color: 'color',
style: 'style',
thickness: 123,
},
},
fontConfiguration: {
fontColor: 'fontColor',
fontDecoration: 'fontDecoration',
fontFamily: 'fontFamily',
fontSize: {
absolute: 'absolute',
relative: 'relative',
},
fontStyle: 'fontStyle',
fontWeight: {
name: 'name',
},
},
height: 123,
horizontalTextAlignment: 'horizontalTextAlignment',
textWrap: 'textWrap',
verticalTextAlignment: 'verticalTextAlignment',
visibility: 'visibility',
},
rowsLabelOptions: {
customLabel: 'customLabel',
visibility: 'visibility',
},
rowsLayout: 'rowsLayout',
singleMetricVisibility: 'singleMetricVisibility',
toggleButtonsVisibility: 'toggleButtonsVisibility',
};
Properties
cellStyleoptionalIResolvable | CfnTemplate.TableCellStylePropertycell_styleoptionaltyping.Union[IResolvable, TableCellStyleProperty]cellStyleoptionalIResolvableCellStyleoptionalIResolvableCellStyleoptionalinterface{}#The table cell style of cells.
collapsedRowDimensionsVisibilityoptionalstringcollapsed_row_dimensions_visibilityoptionalstrcollapsedRowDimensionsVisibilityoptionalStringCollapsedRowDimensionsVisibilityoptionalstringCollapsedRowDimensionsVisibilityoptional*string#The visibility setting of a pivot table's collapsed row dimension fields.
If the value of this structure is HIDDEN , all collapsed columns in a pivot table are automatically hidden. The default value is VISIBLE .
columnHeaderStyleoptionalIResolvable | CfnTemplate.TableCellStylePropertycolumn_header_styleoptionaltyping.Union[IResolvable, TableCellStyleProperty]columnHeaderStyleoptionalIResolvableColumnHeaderStyleoptionalIResolvableColumnHeaderStyleoptionalinterface{}#The table cell style of the column header.
columnNamesVisibilityoptionalstringcolumn_names_visibilityoptionalstrcolumnNamesVisibilityoptionalStringColumnNamesVisibilityoptionalstringColumnNamesVisibilityoptional*string#The visibility of the column names.
defaultCellWidthoptionalstringdefault_cell_widthoptionalstrdefaultCellWidthoptionalStringDefaultCellWidthoptionalstringDefaultCellWidthoptional*string#The default cell width of the pivot table.
metricPlacementoptionalstringmetric_placementoptionalstrmetricPlacementoptionalStringMetricPlacementoptionalstringMetricPlacementoptional*string#The metric placement (row, column) options.
rowAlternateColorOptionsoptionalIResolvable | CfnTemplate.RowAlternateColorOptionsPropertyrow_alternate_color_optionsoptionaltyping.Union[IResolvable, RowAlternateColorOptionsProperty]rowAlternateColorOptionsoptionalIResolvableRowAlternateColorOptionsoptionalIResolvableRowAlternateColorOptionsoptionalinterface{}#The row alternate color options (widget status, row alternate colors).
rowFieldNamesStyleoptionalIResolvable | CfnTemplate.TableCellStylePropertyrow_field_names_styleoptionaltyping.Union[IResolvable, TableCellStyleProperty]rowFieldNamesStyleoptionalIResolvableRowFieldNamesStyleoptionalIResolvableRowFieldNamesStyleoptionalinterface{}#The table cell style of row field names.
rowHeaderStyleoptionalIResolvable | CfnTemplate.TableCellStylePropertyrow_header_styleoptionaltyping.Union[IResolvable, TableCellStyleProperty]rowHeaderStyleoptionalIResolvableRowHeaderStyleoptionalIResolvableRowHeaderStyleoptionalinterface{}#The table cell style of the row headers.
rowsLabelOptionsoptionalIResolvable | CfnTemplate.PivotTableRowsLabelOptionsPropertyrows_label_optionsoptionaltyping.Union[IResolvable, PivotTableRowsLabelOptionsProperty]rowsLabelOptionsoptionalIResolvableRowsLabelOptionsoptionalIResolvableRowsLabelOptionsoptionalinterface{}#The options for the label that is located above the row headers.
This option is only applicable when RowsLayout is set to HIERARCHY .
rowsLayoutoptionalstringrows_layoutoptionalstrrowsLayoutoptionalStringRowsLayoutoptionalstringRowsLayoutoptional*string#The layout for the row dimension headers of a pivot table. Choose one of the following options.
TABULAR: (Default) Each row field is displayed in a separate column.HIERARCHY: All row fields are displayed in a single column. Indentation is used to differentiate row headers of different fields.
singleMetricVisibilityoptionalstringsingle_metric_visibilityoptionalstrsingleMetricVisibilityoptionalStringSingleMetricVisibilityoptionalstringSingleMetricVisibilityoptional*string#The visibility of the single metric options.
toggleButtonsVisibilityoptionalstringtoggle_buttons_visibilityoptionalstrtoggleButtonsVisibilityoptionalStringToggleButtonsVisibilityoptionalstringToggleButtonsVisibilityoptional*string#Determines the visibility of the pivot table.