Configuring Multiple Filters Bar Chart Macro

Title

Bar Chart

The title of the macro

Display Type

Bar Chart Only

To display:

• Bar Chart Only

• Data Table Only

• Bar Chart and Data Table

Color Scheme

Basic

The color scheme for bar chart:

• Basic

• Contrasting

• Shades

• Warm

• Custom

Add Filter

Click to add filter

^{*Maximum of 12 filters can be added.}

JQL n

Enter JQL to get the Jira issues

Alias n

The display name for the filter

Date n

Created

The date field to get date value for x-axis:

• Created

• Updated

• Resolved

• Due Date

• Date picker custom fields

• Date time picker custom fields

Calculation Mode n

Issue Count

The calculation mode field to get value for y-axis:

• Issue Count

• Original Estimate

• Remaining Estimate

• Time Spent

• Σ Original Estimate

• Σ Remaining Estimate

• Σ Time Spent

• Number custom fields

The operator:

• Sum

• Average

• Minimum

• Maximum

^{*Not applicable for Issue Count}

Color n

The color for the bar

^{*Configurable only if Color Scheme is set to Custom}

Display Time In

Hours

The unit to display time in:

• Hours

• Days

• Weeks

^{*Applicable for Time Fields only}

Cumulative Mode

No

Display cumulative data over time:

• Yes

• No

Period Format

Months with Year

The period format for the x-axis labels:

• Months with Year

• Months without Year

• Numeric Months with Year

• Numeric Months without Year

• Quarter with Year

• Quarter without Year

• Half with Year

• Half without Year

Months In Group

1

The number of months to group together:

• 1

• 2

• 3

• 4

• 6

• 12

• All Time

• All Time (Hide label on x-axis)

Display All Months

No

Display all month groups:

• Yes

• No

Display Full Year

No

Display all 4 digits of the year (e.g. 2008):

• Yes

• No

Sort

Date ascending

Sort the dates in ascending or descending order:

• Date ascending

• Date descending

X-Axis Label

Created

The x-axis label

Y-Axis Label

Issue Count

The y-axis label

Display Mode

Grouped

How the bars should be displayed:

• Grouped

• Stacked

Data Labels

Show

The value above each bar:

• Show

• Hide

Tick Interval

The interval between each tick on the y-axis

Reference Line

Enter a value to display the reference line

Click on the colored square to select color

The style of the reference line:

• Dashed

• Dotted

• Solid

Table Orientation

Vertical

Display filters horizontally or vertically:

• Horizontal

• Vertical

Table Totals

Hide

The totals for each column and row:

• Hide

• Show (Columns Only)

• Show (Rows Only)

• Show