Configuring Multiple Filters Line Chart (Days of Week) Macro

Title

Line Chart (Days of Week)

The title of the macro

Display Type

Line Chart Only

The types of data to display:

• Line Chart Only

• Data Table Only

• Line Chart and Data Table

Color Scheme

Basic

The color scheme for line chart:

• Basic

• Contrasting

• Shades

• Warm

• Custom

Add Filter

Click to add filter

^{*Maximum of 12 filters}

JQL n

Enter JQL to get the Jira issues

Alias n

The display name for JQL n

Date n

Created

The date field for JQL n:

• Created

• Updated

• Resolved

• Due Date

• Custom fields:

  • Date picker

  • Date time picker

Calculation Mode n

Issue Count

The calculation mode for JQL n:

• Issue Count

• Original Estimate

• Remaining Estimate

• Time Spent

• Σ Original Estimate

• Σ Remaining Estimate

• Σ Time Spent

• Custom fields

  • Number

The operator:

• Sum

• Average

• Minimum

• Maximum

^{*Not applicable for Issue Count}

Color n

The line color for JQL n

^{*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 (e.g. Time Spent)}

Cumulative Mode

No

Whether to display cumulative data over time:

• Yes

• No

Week Span

Current Week

The week span to plot:

• Current Week

• Last Week

First Day of Week

Sunday

The first day of the week:

• Sunday

• Monday

• Tuesday

• Wednesday

• Thursday

• Friday

• Saturday

Days to Display

7 Days

The number of days to display:

• 5 Days

• 6 Days

• 7 Days

Display Full Year

No

Whether to 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 for the chart

Y-Axis Label

Issue Count

The y-axis label for the chart

Display Mode

Side By Side

How the lines should be displayed:

• Overlapped

• Side By Side

Interpolation

Linear

The method of curve fitting:

• Linear

• Monotone

Data Labels

Show

Whether to show/hide the value above each dot:

• 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

Whether to 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