View Source

Before you start

configure link

display all issues

no more 1000 (Jira limitations)

in all the use cases below, we use JQL: 'project = name' and apply filtration with the TF macro

remember about date format and worklog settings

use one Jira issues table to create multiple pivot tables and charts

hide Jira user macro

настройки языка

Aggregating Issues by Assignee

Macro configuration:

Table Filter:

Filter Column	Status
Filter Type	Dropdown
Filter Values	Reversed filter 'Done'

Pivot Table:

Row Labels	Assignee
Column Labels	Status
Calculated Column	Key
Operation Type	Count, Literal

Additional parameters:

Set the Literal value delimiter option: Bulleted list.
Hide totals of the pivot table.

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > aggregating by assignee_3.png

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > aggregating by assignee_2.png

Evaluating Calculated Planned and Spent Time Per Assignee

Macro configuration:

Table Filter:

Filter Column	Status
Filter Type	Dropdown
Filter Values	Done

Pivot Table:

Row Labels	Assignee
Column Labels	-
Calculated Column	Original Estimate, Time Spent
Operation Type	Sum

Table Transformer:

Use the following SQL query:

SELECT *,
CASE WHEN 'Sum of Time Spent' > 'Sum of Original Estimate' 
THEN "OVERDUE" 
ELSE "IN TIME" END AS 'Time Evaluation'
FROM T1

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > eval planned-spent_3.png

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > eval planned-spent_2.png

Visualizing of the Amount of Planned and Spent Time Within the Project

Macro configuration:

Table Filter:

Filter Column	Status
Filter Type	Dropdown
Filter Values	Done

Pivot Table:

Row Labels	T
Column Labels	-
Calculated Column	Original Estimate, Time Spent
Operation Type	Sum

Chart from Table:

Type	Bar
Labels Column	T
Values Column	Sum of Original Estimate, Sum of Time Spent

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > project time_3.png

Visualizing the Issues Distribution by Sprints or Releases

Macro configuration:

Table Filter:

Filter Column	Status
Filter Type	Dropdown
Filter Values	Reversed filter 'Done'

Pivot Table:

Row Labels	Assignee
Column Labels	Status
Calculated Column	Key
Operation Type	Count, Literal

Chart from Table:

Type	Stacked column
Labels Column	Fix Version(s)
Values Column	Count Improvement, Count New Feature

Additional parameters:

Set the Show data labels option: Percentage.

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > release distribution_3.png

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > release distribution_5.png

Comparison of Graphs of Open and Resolved Tasks

Macro combination (the chart is based on two transformed pivot tables):

Step 1. Configure Table1:

Insert the Jira Issues macro.
Wrap the Table Filter macro in the Pivot Table macro.
Wrap the Pivot Table macro and the table containing statuses in the Table Transformer macro.

Step 2. Configure Table2:

Insert the Jira Issues macro.
Wrap the Jira macro in the Table Filter macro.
Wrap the Table Filter macro in the Pivot Table macro.
Wrap the Pivot Table macro and the table containing statuses in the Table Transformer macro.

Step 3. Wrap Table1 and Table2 in the Chart from Table macro.

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > created-resolved_3.png

Macro configuration:

Step 1. Configure Table1:

Pivot Table:

Row Labels	Created
Column Labels	-
Calculated Column	Summary
Operation Type	Count

Additional parameters:

Set the Date period aggregation option: Week.

Table Transformer:

Use the following SQL query:

SELECT 'Created', SUM (TT2.'Count') AS 'Count'
FROM T1 AS TT1 
JOIN T1 AS TT2 on TT1.'Created' >= TT2.'Created'
GROUP BY TT1.'Created'
ORDER BY TT1.'Created'

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > created-resolved_6.png

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > created-resolved_5.png

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > created-resolved_7.png

Step 2. Configure Table2:

Table Filter:

Filter Column	Resolved
Filter Type	Dropdown
Filter Values	Reversed filter '-empty-'

Pivot Table:

Row Labels	Resolved
Column Labels	-
Calculated Column	Summary
Operation Type	Count

Additional parameters:

Set the Date period aggregation option: Week.

Table Transformer:

Use the following SQL query:

SELECT 'Resolved', SUM (TT2.'Count') AS 'Count'
FROM T1 AS TT1 
JOIN T1 AS TT2 on TT1.'Resolved' >= TT2.'Resolved'
GROUP BY TT1.'Resolved'
ORDER BY TT1.'Resolved'

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > created-resolved_8.png

Visualizing the Story Points Performance

Macro configuration:

Table Filter:

Filter Column	T	Sprint
Filter Type	Visual	Dropdown
Filter Values	Improvement, New Feature	Reversed filter '-empty-'

Pivot Table:

Row Labels	Sprint
Column Labels	Status
Calculated Column	Story points
Operation Type	Sum

Chart from Table:

Type	Column
Labels Column	Sprint
Values Column	Sum of story points Done, Sum of story points In Progress, Sum of story points To Do

Additional parameters:

Set the Show trendline option.

(OUTDATED) Table Filter and Charts for Confluence > Using Table Filter and Charts in Combination with the Jira Issues Macro > story points_2.png

Calculating Velocity

Macro configuration:

Table Filter:

Filter Column	Status
Filter Type	Dropdown
Filter Values	Reversed filter 'Done'

Pivot Table:

Row Labels	Assignee
Column Labels	Status
Calculated Column	Key
Operation Type	Count, Literal

Chart from Table:

Type	Stacked column
Labels Column	Fix Version(s)
Values Column	Count Improvement, Count New Feature

Additional parameters:

Set the Show data labels option: Percentage.

Visualizing of Completed Story Points by Teams

Macro configuration:

Table Filter:

Filter Column	Status
Filter Type	Dropdown
Filter Values	Reversed filter 'Done'

Pivot Table:

Row Labels	Assignee
Column Labels	Status
Calculated Column	Key
Operation Type	Count, Literal

Chart from Table:

Type	Stacked column
Labels Column	Fix Version(s)
Values Column	Count Improvement, Count New Feature

Additional parameters:

Set the Show data labels option: Percentage.

Burnup Chart

Macro configuration:

Table Filter:

Filter Column	Status
Filter Type	Dropdown
Filter Values	Reversed filter 'Done'

Pivot Table:

Row Labels	Assignee
Column Labels	Status
Calculated Column	Key
Operation Type	Count, Literal

Chart from Table:

Type	Stacked column
Labels Column	Fix Version(s)
Values Column	Count Improvement, Count New Feature

Additional parameters:

Set the Show data labels option: Percentage.

Building a Gantt Chart

Macro configuration:

Table Filter:

Filter Column	Status
Filter Type	Dropdown
Filter Values	Reversed filter 'Done'

Pivot Table:

Row Labels	Assignee
Column Labels	Status
Calculated Column	Key
Operation Type	Count, Literal

Chart from Table:

Type	Stacked column
Labels Column	Fix Version(s)
Values Column	Count Improvement, Count New Feature

Additional parameters:

Set the Show data labels option: Percentage.

Before you start

Aggregating Issues by Assignee

Macro combination:

Macro configuration:

Table Filter:

Pivot Table:

Additional parameters:

Evaluating Calculated Planned and Spent Time Per Assignee

Macro combination:

Macro configuration:

Table Filter:

Pivot Table:

Table Transformer:

Visualizing of the Amount of Planned and Spent Time Within the Project

Macro combination:

Macro configuration:

Table Filter:

Pivot Table:

Chart from Table:

Visualizing the Issues Distribution by Sprints or Releases

Macro combination:

Macro configuration:

Table Filter:

Pivot Table:

Chart from Table:

Additional parameters:

Comparison of Graphs of Open and Resolved Tasks

Macro combination (the chart is based on two transformed pivot tables):

Macro configuration:

Pivot Table:

Additional parameters:

Table Transformer:

Step 2. Configure Table2:

Table Filter:

Pivot Table:

Additional parameters:

Table Transformer:

Step 3. Wrap Table1 and Table2 in the Chart from Table macro.

Chart from Table:

Visualizing the Story Points Performance

Macro combination:

Macro configuration:

Table Filter:

Pivot Table:

Chart from Table:

Additional parameters:

Calculating Velocity

Macro configuration:

Table Filter:

Pivot Table:

Chart from Table:

Additional parameters:

Visualizing of Completed Story Points by Teams

Macro configuration:

Table Filter:

Pivot Table:

Chart from Table:

Additional parameters:

Burnup Chart

Macro configuration:

Table Filter:

Pivot Table:

Chart from Table:

Additional parameters:

Building a Gantt Chart

Macro configuration:

Table Filter:

Pivot Table:

Chart from Table:

Additional parameters: