I want to create a pie chart that shows the % of stories with and without a Story point assigned.

[Shyam Ganesh kandasamy]

I am creating a dashboard to display the status of refinement for a release, which pulls the data from a Jira filter. In the project, if a story has a Story point, it is refined for development.

Right now I am not able to find a logic to make the chart that shows only the

% of stories refined - i.e. with a story point

% of stories not refined - i.e. without a story point

Thanks in advance.

BR,

Sam.

[Vinod Ramadoss · Accepted solution]

Hi,

Edit your confluence page, and follow the below steps:

Step-1 - Select "Jira" macro and map your Jira query filter name in the search field, click Display Options and select the maximum issue numbers and columns to be displayed

Step-2 - Use a "Table Filter" macro and embed Step-1 outcome into it

Step-3 - Use "Pivot Table" macro and embed Step-2 outcome into it

Step-4 - Use "Chart from Table" macro and embed step-4 into it (this macro will allow you to select multiple chart types such as Pie, Column, Bar etc), in this case select Pie

Step-5 - Click "Save"

Step-6 - In Pivot Table settings, input values to "Row Labels", "Column Labels", "Calculated Column", "Operation Type"

The Pie chart will be displayed accordingly, the chart also allows feature to select individual sectors, there by only the data from selected sector will be displayed (in this case - user stories with or without story points)

Hope this helps.

Confluence Macro reference - https://confluence.atlassian.com/doc/macros-139387.html 

[Mykenna Cepek]

@Vinod Ramadoss - Your link above gives me a 404 error. Also I don't see "Table Filter" or "Pivot Table" macros in Confluence Cloud. What am I missing here?

[Katerina Kovriga _Stiltsoft_]

The Table Filter, Pivot Table, Chart from Table and Table Transformer macros are provided by the Table Filter and Charts for Confluence app. Please check if the app is installed for your instance.

[Mykenna Cepek]

No, our instance does not have that (paid) app installed.

I'll stand by my answer (below) that Confluence Cloud doesn't support the original request without paying more for an additional app.

The way that the accepted answer was moved to the top of this discussion was confusing, since it didn't mention the app. 

[Katerina Kovriga _Stiltsoft_]

Hi @Shyam Ganesh kandasamy ,

As @Vinod Ramadoss has recommended, you can solve your case with the help of the Table Filter and Charts for Confluence app.

As your hosting type is Cloud, I decided to take screenshots for the new Confluence editor.

At first, wrap you Jira Issues macro in the Table Toolbox macro.

Here I wrap manually created table, but it is just for an example - we don't use story points in our Jira.

Then go to the Table Toolbox settings and wrap you table (Jira Issues macro for your case) into the Table Transformer macro and use the following custom SQL query:

SELECT *,
CASE WHEN 'Story Points' IS NULL THEN "With Story Points"
ELSE "Without Story Points"
END
AS 'Points'
FROM T1

Then wrap your Table Transformer in the Pivot Table macro:

The last step is to visualize your pivot with the help of the Chart from Table macro:

Hope this may help your case.

[Mykenna Cepek]

The two standard pie chart macros in Confluence Cloud ("Pie Chart", and "Workload Pie Chart") do not look like they can be customized to show the data you want to display.

The closest macro I could find is the "Issue Statistics" macro. However...

• Unfortunately it's a horizontal bar chart, not a pie chart.
• Unfortunately it will break out each Story Point value into a separate bar.
• However, it will show all the unpointed issues and a percentage. So a little mental math can tell you, for example, if 30% are unpointed, the 70% have points.
• Set the "Statistic Type" to "Story Points", and the project / filter as needed.

I'm sure there are Confluence add-on Apps that can do a lot more. I tried to find a solution for you that is part of the standard Confluence cloud offering.

[Sirbulescu Alexandra-Elena]

Did you find a solution?