How can I create live diagram in confluence?

[Sirbulescu Alexandra-Elena]

I want to create this diagram for my page, but I don't have access in PMT to use the page macro 'HTML Include' like them. I also can't use table pivot. 

[Katerina Kovriga {Stiltsoft} · Accepted solution]

Hi @Sirbulescu Alexandra-Elena ,

You've mentioned the Pivot Table macro - do you mean the macro provided by the Table Filter and Charts for Confluence app?

This app is our add-on and its macros (Table Filter, Pivot Table, Chart from Table, etc.) support dynamic Confluence macros such as Page Properties Report, Jira Issues, Content Report Table.

Note that the app is a paid one.

If you want to create a pie chart using standard Confluence tools, you may check the Chart macro. This macro doesn't support dynamic tables but allows you to create beautiful graphs based on plain manually created tables.

[Sirbulescu Alexandra-Elena]

Thank you! I tried to use Chart macro, but I can't create a status chart like this. https://pmtapps-vni.conti.de:81/pmtr_project/PublicReport/393

[Katerina Kovriga {Stiltsoft}]

If you report on Jira Issues, you may try the standard Jira Chart macro. Hope it will help your case.

[Sirbulescu Alexandra-Elena]

What shoud I complete here? 

[Katerina Kovriga {Stiltsoft}]

If your Jira VNI instance is connected to Confluence, here you type in your JQL query. For example, project = "The name of my project".

The data from your Jira (issues, assignees, statuses, etc.) is pulled to Confluence, and you'll be able to create charts based on this data.

You may also google about JQL queries for Jira to pull specific data and create custom charts.

[Sirbulescu Alexandra-Elena]

Thank you very much!