nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence Pie Chart auto updates the counts of complete versus open tasks WITHIN a given page

Michael Hudson_twgrri

I have a single confluence page for on-boarding a new program manager. Embedded in this page are tasks to complete. I would like to create a Pie Chart that keeps count of completed versus open (as the PM checks off tasks, the chart updates totals).

I think I need to create a table first then the chart but I don't know how to automate the count macro. Thanks.

Accepted answers

Andrey Khaneev _StiltSoft_

Hello Michael,

Here is a solution:

Add some label to pages with tasks you want to see in the Pie chart report
Add Those macros to the page where you want to see the Pie chart: two Task Report macros with the label (one for incomplete tasks and one for completed), Pivot Table macro and Chart from Table macro (Table Filter and Charts app)
Save the page and set "Description" column in Row labels field of the Pivot Table macro and save changes
Additionally you can hide source table in the Pie chart

All comments

Shannon S

Michael,

You might be able to use something like SQL for Confluence to connect to the database, query the number of tasks on the specific page (using pageID), and display this information (completed and incomplete) in the form of a pie chart.

Have a look at that add-on and let us know if you have any questions.

Regards,

Shannon

Andrey Khaneev _StiltSoft_

Hello Michael,

Here is a solution:

Add some label to pages with tasks you want to see in the Pie chart report
Add Those macros to the page where you want to see the Pie chart: two Task Report macros with the label (one for incomplete tasks and one for completed), Pivot Table macro and Chart from Table macro (Table Filter and Charts app)
Save the page and set "Description" column in Row labels field of the Pivot Table macro and save changes
Additionally you can hide source table in the Pie chart

Fernanda Luksic

Hi,

I cannot seem to get the Pivot Chart into the Chart from Table macro. Please suggestions. I have tried everything (copy paste, drag). It only lets me put the track report in the Pivot Chart and that is it.

Help!

Andrey Khaneev _StiltSoft_

Hi @Fernanda Luksic,

I suppose you are using Confluence Cloud where the new editor doesn't allow to use nested bodied macros. In this case, use the Table Toolbox macro.

Fernanda Luksic

Thank you! This worked perfectly!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-server

atlassian-marketplace

atl-adm