How can I create a custom gantt chart with data from the Jira in a HTML macro

[Chris Kemp]

Objective:

Create Confluence page that contains pivot table with Milestones being worked on each fiscal quarter, and gantt chart view for initiatives, milestones created by the initiative, and task created by those milestones. Jira roadmap is not supported as our company is not on the current release version and with such a large company upgrading versions is not something feasible at this time.

Request:

Seeking help to understand how I can have the Jira macro execute my JQL to get the information from Jira, while having the table hidden. I can easily create the table with the Jira macros which exposes the key fields needed by my HTML code (Labels, Components, Summary, Start Date, and Planned Done Date), however I can not figure out how to access the data directly in HTML although it is on the same page.

Design Blockers:

- Use of 3rd party macros is not allowed in my company.

- Can not use API to call Jira directly.

- Complex JS seems to break resulting in graphics not to be shown.

Version: Atlassian Confluence 7.13.2

[Stiltsoft support]

Hi @Chris Kemp ,

I'm aware of the first blocker regarding the 3rd party macros but as there are no any hints regarding the case, I'll mention our app - Table Filter, Charts & Spreadsheets for Confluence. Maybe it will help other users who browse the Community.

Here is an example how to create a live Gantt Chart based on the Jira Issues macro.

Maybe we can arrange a live call with your team? The app enhances working with Confluence tables in general, we'll be able to show you many more use cases besides the Gantt Chart.