Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,285
Community Members
 
Community Events
165
Community Groups

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

Edited

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.

3 answers

1 accepted

2 votes
Answer accepted

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 Community Leader Dec 14, 2020

@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?

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 Community Leader Dec 14, 2020

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. 

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.

Fri 1-1.pngHere 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

Fri 1-2.pngFri 1-3.pngThen wrap your Table Transformer in the Pivot Table macro:

Fri 1-4.pngThe last step is to visualize your pivot with the help of the Chart from Table macro:

Fri 1-5.pngHope this may help your case.

0 votes
Mykenna Cepek Community Leader Dec 10, 2020

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.

Did you find a solution?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

727 views 5 21
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you