• Products
  • Documentation
  • Resources

Atlassian Analytics is in open beta

Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.

Table chart settings

General

Chart title

The title of your chart

Title font size

The font size of your chart title

The minimum value is 8.

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.

Increase the font size of your table charts to make them easier to read if you display your dashboards on monitors or print them out.

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.

If you want some of the aggregation rows to be treated as text and exclude them from the aggregation row, you can simply cast them as text using a custom formula.

Show aggregation row at the top

Available when Show row aggregation for numeric columns is selected

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.

Discover more tips for how to handle long text in table charts.


Color

Background color

The background color of your chart

By default, it uses the background color of the dashboard theme. Selecting another color overrides the background color of the dashboard theme.


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.

If you need a column in your chart for formatting or some other reason but you don’t want it displayed in the table on your dashboard, you can “hide” the column by setting its width percentage to 0. Note that the column’s results will still be available in the extended table view and in table chart downloads.

Datetime formatting

Available if the column selected for Format column is a datetime

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.

Later conditional rules can override earlier ones. If a column value fits multiple rules, the later rule will be applied.

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)

Conditional formatting applied to a table chart. Details in following paragraph.

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


Drilldown

Use this chart as a variable control by selecting a dashboard and connecting other variable controls to it. Learn more about how to set up drilldowns for a chart.

Additional Help