Ability to add count of stories in an epic in custom dashboard

AT_qbizjp

Hello,

I have created a dashboard for the Product Owner and one of the gadgets I have used is: 

• Custom Charts: Custom Charts for Jira is a simple, powerful tool for creating customizable charts and reports on Jira Dashboards.

I am using label to filter and any epic that has this label is showing under this gadget. 

My question is how can I add the sum of no. of stories that the epic has as a column in this gadget? The column in red is what I would like to add. E.g. Epic 1 has 11 stories summing up to 100 points, Epic 2 has 6 stories summing up to 26 points. 

Please refer to the second image. The gadget allows adding more columns either using field name or smart label. This label can be JQL smart label or saved filter smart label. 

I could not find a way to sum the linked issues under each epic so that it would show in the gadget under number of stories. Any help is appreciated!

Pls note this is a company managed project. I thought about using an automation but there is no field under Epic that I can use to provide a sum of stories under it. So thats not an option. 

Pablo Brincat_3wki8l

Hello AT,

 

Creating a dashboard in Jira that includes a column showing the count of stories in an epic can be quite useful for product owners to have a clear view of their project scope. Since you’re using Custom Charts for Jira and have certain constraints in a company-managed project, let’s explore some possible solutions:

 

1. Custom JQL Function (Requires Scripting App)

If you have access to a Jira scripting app like ScriptRunner, you could create a custom JQL function to count the number of stories in each epic. This function can then be used as a smart label in your Custom Charts gadget. However, this requires scripting knowledge and the app installed in your Jira instance.

 

2. Automation to Update a Custom Field

Although you mentioned automation is not an option due to the lack of a relevant field in the Epic, you can actually create a new custom field for this purpose. Here’s how you can approach it:

 

• Create a Custom Field: Add a new custom field to your Epics, something like “Story Count.”

• Set Up an Automation Rule: Create a rule that triggers whenever a story is created, updated, or deleted. This rule would:

  • Find the parent epic of the story.
  • Count the number of stories linked to this epic.
  • Update the “Story Count” field in the epic with this number.

• Use in Custom Charts: Once the custom field is populated and updated through automation, you can use it as a column in your Custom Charts gadget.

 

3. Utilizing Advanced Roadmaps (If Available)

 

If you have Advanced Roadmaps, you can use it to create a report that shows the count of stories per epic. Advanced Roadmaps offers more sophisticated reporting features than standard Jira, though this might not integrate directly into your Custom Charts gadget.

 

4. Dashboard Gadgets that Support Issue Count

 

Explore other gadgets that might support showing issue counts by default. For example, a gadget that lists Epics and can display a count of linked issues (like stories) as one of the columns.

 

5. External Reporting Tools

 

If Jira’s internal tools don’t meet your needs, consider using external reporting tools that integrate with Jira. These tools often offer more advanced features for reporting and can handle complex data aggregation like counting stories within epics.

 

6. Feedback to Atlassian / Custom Charts for Jira

 

Lastly, providing feedback to Atlassian or the developers of Custom Charts for Jira about this requirement could lead to future enhancements that support this functionality natively.

 

Keep in mind that some of these solutions may require additional permissions, access to specific Jira apps, or assistance from your Jira admin. The exact approach will depend on your Jira setup and the resources available to you. Good luck with your dashboard configuration, and feel free to reach out if you need more assistance! 🚀📊🔧