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.
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
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.
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:
CASE WHEN 'Story Points' IS NULL THEN "With Story Points"
ELSE "Without Story Points"
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.
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...
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.
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...
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