Configuring Multiple Filters Line Chart (Floating Weeks) Macro

Title

Line Chart (Floating Weeks)

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

Period Type

Weeks Before (Including current)

The period to plot:

• Weeks Before (Including current)

• Weeks After (Including current)

• Weeks Before and After

No. of Weeks

0

The number of weeks to display before and/or after (maximum of 8 weeks)

First Day of Week

Sunday

The first day of the week:

• Sunday

• Monday

• Tuesday

• Wednesday

• Thursday

• Friday

• Saturday

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