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 row aggregation for numeric columns

Aggregates the values of each numeric column and shows the outputs in an aggregation row.

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 Columns tab.

Show aggregation row at the top

Makes the aggregation row the first row of the chart

The totals row always displays at the bottom or top of the chart (depending on your selection), even if all the rows 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.

Color

Columns

Default column formatting

These settings are applied to all columns in the table chart.

Number formatting

The number format and how to handle rounding

• Number format options:

  • 1,000.00

  • 1000.00

  • 1 000,00

  • 1000,00

• Rounding options:

  • No rounding

  • Round to integers

  • 2 decimal places

Date formatting

Select one of the following date formats:

• Default (for example, Apr 1, 2020)

• ISO-8601 (for example, 2020-04-01)

Text

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

Add a formatting rule

Select Add formatting rule to apply special formatting to the values in a specific column.

The following settings will appear:

Column to format

The column from your table chart to which you’d like to apply the formatting rule

Text

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

Column width

The width of the column

• Auto - Dynamic column width dependent on the row length

• Percent - Specify a fixed percentage of the table for the column width. Other columns’ sizes will auto-adjust accordingly. Any text-overflow in your column will be truncated with an ellipsis, and the full text is viewable on hover or by selecting the View all columns and rows at the bottom of the table.

Datetime formatting

If you use the Quarter time bucket, the format is always YYYY QQ (for example, 2020 Q2).

• Second formatting

  • Default (example - Apr 1, 2020 16:59:59)

  • ISO-8601 (example - 2020-04-01 16:59:59)

  • Twelve hour clock (example - Apr 1, 2020 4:59:59 PM)

• Minute formatting

  • Default (example - Apr 1, 2020 16:59)

  • ISO-8601 (example - 2020-04-01 16:59)

  • Twelve hour clock (example - Apr 1, 2020 4:59 PM)

• Hour formatting

  • Default (example - Apr 1, 2020 16:00)

  • ISO-8601 (example - 2020-04-01 16:00H)

  • Twelve hour clock (example - Apr 1, 2020 4:00 PM)

• Day formatting

  • Default (example - Apr 1, 2020)

  • ISO-8601 (example - 2020-04-01)

  • Long (example - 1 Apr 2020)

• Week formatting

  • ISO-8601 (example - 2020-W14)

  • Long (start day - end day) (example - Mar 30 - Apr 05, 2020)

• Month formatting

  • Default (example - Apr 2020)

  • ISO-8601 (example - 2020-04)

• Year formatting

  • Default (example - 2020)

  • ISO-8601 (example - 2020)

The following fields are available if the column chosen for Format column is a number:

Data format

Select one of the following formats:

• Number

• Currency

• Percentage

Number formatting

Select the number format and how to handle rounding:

• Number format options:

  • 1,000.00

  • 1000.00

  • 1 000,00

  • 1000,00

• Rounding options:

  • No rounding

  • Round to integers

  • 2 decimal places

Aggregate row

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

Options:

• Sum

• Average

• Column ratio

• Maximum

• Minimum

• None

Conditions

Apply formatting to column values when they meet a specific condition. You may create as many conditional rules as you wish to a table chart.

Select Add condition to apply formatting to the value when the condition is met.

The following settings will appear:

Column(s) to format

Select the column to create a conditional rule for. Alternatively, you can create a conditional rule that can apply to all columns of the same data type:

• All text columns

• All numeric columns

Condition

The condition to check for

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

For any data type:

• Is null

• Is not null

String-specific condition options:

• Text contains

• Text does not contain

• Text starts with

• Text ends with

• Text is exactly

Number-specific condition options:

• 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

Datetime-specific condition options:

• Date is

• Date before

• Date after

Text style

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

Background color

The cell color to apply to the column(s) when the specified condition is met

Format whole row

Applies the Text style and Background color 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 150 and 230. We create a condition with the following settings:

• Column(s) to format: Count of users

• Condition: Is between

• Number: 150

• Number: 230

• Text style: Green and bold

• Background color: None

• Format whole row: Unselected