Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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 

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

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.

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.

Suggest an answer

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

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

177 views 0 6
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