Table chart settings

General

Hide duplicate values

Hides duplicate values in the first column

Use zebra stripes

Alternates the background color of the rows in the chart

Font size

The font size of the chart

The minimum value is 8.

Show column aggregation for numeric columns

Aggregates the values of each numeric column and presents the results in a column aggregation.

The default aggregation is sum.

You can change the aggregation type for a specific column (for example, average instead of sum) by adding a new formatting rule in the Formatting tab.

Show column aggregation at the top

Makes the aggregation the first column of the chart

The totals column always displays at the bottom or top of the chart (depending on your selection), even if all the columns don’t fit in the available chart space.

Word wrap automatically

Wraps the cell’s contents if it is longer than the cell width (for example, a cell containing a long email message); otherwise, the contents may truncate.

Formatting

This tab allows you to customize the way data appears in your table chart.

Default column formatting

Apply consistent formatting to all the columns of your table chart.

Number format

The number format and how to handle rounding

• Number format:

  • 1,000.00

  • 1000.00

  • 1 000,00

  • 1000,00

• Rounding:

  • No rounding

  • Round to integers

  • 2 decimal places

Date format

Select one of the following date formats:

• Default

• June 30, 2015

• y2015

• 2015-06-30

• 2015-06

• 2015-W25

• 2015-06-T10

• 2015-06-30T10:24

• 2015-06-30T10:24:35

• Custom

Column width

The width of the column

Text

Select the text color, styling (bold and italics), and text alignment of the column

Custom formatting

Customize the style and presentation of your data.

Select Add rule to apply a formatting and/or conditional rule. The following settings will appear:

Column(s) to format

Select columns from your table chart that you’d like to apply a formatting and/or conditional rule. Depending on the type of column you select, different formatting options will appear.

Note: You can only select columns of the same column type (For example, you can only select all number, date, or string columns. You can’t select a number column and a date column).

Column formatting

Customize the formatting of specific columns in your table chart.

Column width

The width of the column

• Default - Dynamic column width dependent on the row length

• Custom - Specify a fixed pixel amount for the column width of your table chart. Any text overflow in your column will be truncated with an ellipsis, and the full text is viewable on hover.

Data format

Select one of the following formats you’d like to display data in your table:

• Number

• Currency

• Percentage

• None

Number format

Select the number format and how to handle rounding:

• Number format:

  • 1,000.00

  • 1000.00

  • 1 000,00

  • 1000,00

• Rounding:

  • No rounding

  • Round to integers

  • 2 decimal places

Column aggregation

Specify the aggregation type to use when Show column aggregation for numeric columns is selected from the General tab

Note: This option only shows up for numeric columns.

You can choose from the following options:

• Sum

• Average

• Maximum

• Minimum

• None

Date format

Select one of the following date formats:

• Default

• June 30, 2015

• y2015

• 2015-06-30

• 2015-06

• 2015-W25

• 2015-06-T10

• 2015-06-30T10:24

• 2015-06-30T10:24:35

Conditional formatting

Apply formatting to cells when they meet a specific condition.

Select Add rule to apply formatting to cells when a condition is met.

Once you’ve selected a column, the following settings will appear:

Condition

The options vary based on the value’s data type.

For all data types:

• Is null

• Is not null

String-specific condition:

• Text contains

• Text does not contain

• Text starts with

• Text ends with

• Text is exactly

Number-specific condition:

• Is greater than

• Is greater than or equal

• Is less than

• Is less than or equal

• Is equal

• Is not equal

• Is between

• Is not between

Date-specific condition:

• Date is

• Date before

• Date after

Text

Select the text color and styling (bold and italics) to apply to the column(s) when the specified condition is met

Cell background

The background color is applied to a cell when a specific condition is met.

Apply text styles and cell background to whole row

Applies the Text and Cell background for the conditional rule to the whole row, rather than just the specific column(s)

In the image above, we format any results where the count of created issues is between 2 and 13. We create a condition with the following settings:

• Column(s) to format: Count of Issues

• Condition: Is between

• Number: 2

• Number: 13

• Text style: Green and bold

• Cell background: None

• Apply text styles and cell background to whole row: Unselected

Visualization

This tab allows you to use heatmaps to visualize patterns within your data.

Select Show heatmap to apply specific colors to the data in your table.

Once you’ve selected a column, the following settings will appear:

• Color palette: The collection of colors that you’d like to use visually represents your data.

• Scale type: How you want your data to be perceived in your table chart

  • Steps

  • Continuous