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

[Michael Hudson]

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.

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hello Michael,

Here is a solution:

1. Add some label to pages with tasks you want to see in the Pie chart report 
2. 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) 
3. Save the page and set "Description" column in Row labels field of the Pivot Table macro and save changes
4. 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! 

[Fernanda Luksic]

Hi @Andrey Khaneev _StiltSoft_ ,

I was wondering if you know a little more about sorting the data here. I want to potentially create a report to see how we are doing as a company in terms of completion of tasks. Do you know if I can sort the completed/incompleted tasks in other ways? like date, label? 

Thank you  in advance for your help! 

[Andrey Khaneev _StiltSoft_]

Hi @Fernanda Luksic,

There are three sorting options in the Task Report macro:

Or you can wrap Task Report macros with the Table Transformer macro and sort it by any column:

SELECT * FROM T1 ORDER BY T1.'Description'

[Fernanda Luksic]

Thank you Andrey. I have a few more questions and will not bother you again! After I sorted the data with the three labels is there a way to sort (so to show in the same table) like sort by date + sort by  completed and incompleted so as to show for the same date how many are completed or not. So basically  sort by two types. Does this make sense? 

Please let me know! 

Thank you!! 

[Andrey Khaneev _StiltSoft_]

You are welcome, Fernanda!

I suppose you can create a Pivot Table to show the number of completed and incomplete tasks for each date:

Then you can build a chart on the basis of the pivot table.

[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