Connect your data to Atlassian Analytics
Learn how to connect and manage your connected Atlassian data and external data.
Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.
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.
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.
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
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
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)
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
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.
Was this helpful?