eazyBI for Jira
On this page:
Issue Epic Gantt chart
This example will show how to create Gantt charts with Jira data.
The main attribute of any Gantt chart is Start and End date. You would like to use some measure representing date for your Gant chart; any first two date columns will be drawn in the Gantt. You could use date properties. For example, Issues, Sprints, and Fix versions have date properties you can use on the Gantt chart as the Start date and End date.
This report uses the Issue dimension Epic hierarchy representing open epics and issues in open epics. The measures from issues within the Epic are summed up on the Epic level, e.g., the Hours spent show all hours logged on issues within the Epic, Story Points created shows total planned story Points in issues in epic.
For the Issue Epic Gantt chart, the Issue created date and Epic End date measures are used as the Start date and End date. Issue created date represents a created date of the epic itself. Measure Epic End date uses a custom formula to calculate the latest due date in issues in epic:
The report uses the calculated measure Issue epic link status as a filter. This measure represents the status of an epic for the epic itself and any sub-level issues.
Progress of a task can be visualized with colors:
- blue - upcoming tasks and completed tasks without completion ratio;
- green - completed tasks with completion ratio (%);
- red - overdue tasks with completion ratio (%);
- grey - a group of tasks.
To get the progress of issues, there is a custom measure
Issue resolved % defined with formula
Define the formatting of the measure to
Integer percentage %, the % part of the line will be colored accordingly.
Sprint Gantt chart
A similar report can be created to show Sprint's progress. You can design below visible Gantt chart if you are using Jira Agile Sprint and Story Points custom fields.
This chart uses Sprint custom dimension on rows and Sprint Start and End date measures on columns.
The following formula is used to calculate Story points completed % for each sprint.