You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have created a dashboard for the Product Owner and one of the gadgets I have used is:
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.
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:
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.
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:
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.
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.
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.
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.
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! 🚀📊🔧