Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


Mybanner

This version of the app's documentation is outdated. Please find the information you're looking for here:



Excerpt
hiddentrue

Building a Burndown Chart


The Source Table:

The Result:



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

Step 1. Configure Table1:

  1. Insert the Jira Issues macro.
  2. Wrap the Jira Issues macro in the Table Filter macro.
  3. Wrap the Table Filter macro in the Pivot Table macro.
  4. Insert the Jira issues macro with all the issues from the particular sprint (or use the Table Excerpt and Table Excerpt Include macros to reuse the filtered Jira Issues macro from Table2).
  5. Wrap the Pivot Table macro and the Jira Issues macro in the Table Transformer macro.

Step 2. Configure Table2:

  1. Insert the Jira Issues macro (or use one Jira issues macro for both tables with the help of the Table Excerpt and Table Excerpt Include macros).
  2. Wrap the Jira Issues macro in the Table Filter macro.
  3. Wrap the Table Filter macro in the Table Excerpt macro to reuse this table in Table1.
  4. Wrap the Table Filter macro in the Pivot Table macro.
  5. Place the Pivot Table macro in a cell of a manually created table containing start and end dates of a sprint.

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

Macro configuration:

Step 1. Configure Table1:

Table Filter:

Filter ColumnStatusSprint
Filter TypeDropdownDropdown
Filter ValuesDoneECS Sprint 3

Pivot Table:

Row LabelsResolved
Column Labels-
Calculated ColumnStory points
Operation TypeSum

Table Transformer:

Use the following SQL query:

Code Block
languagesql
SELECT 'Resolved', 
(SELECT SUM(T2.'story points') FROM T2) - SUM (TT2.'Sum of story points') AS 'Actual'
FROM T1 AS TT1
JOIN T1 AS TT2 on TT1.'Resolved' >= TT2.'Resolved'
GROUP BY TT1.'Resolved'
ORDER BY TT1.'Resolved'



Handy Carousel


Step 2. Configure Table2:

Table Filter:

Filter ColumnSprint
Filter TypeDropdown
Filter ValuesECS Sprint 3

Pivot Table:

Row Labels-
Column Labels-
Calculated ColumnStory points
Operation TypeSum


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

Chart from Table:

TypeTime Line
Dates ColumnResolved
Values ColumnIdeal, Actual


Excerpt IncludeUsing Table Filter and Charts in Combination with the Jira Issues MacroUsing Table Filter and Charts in Combination with the Jira Issues Macronopaneltrue