How to use a chart to show the Story Points remaining per Epic in a Product Increment?
Hello SS Community,
I need to represent a chart of the remaining story points per Epic within a Product Increment. I have a Report that Groups Product Increment and then Epic Names and Summarizes the Story Points, as below. Any ideas? At present, I'm only able to represent the Story Points remaining on the Product Increment. Thank you!
Best Answer
-
Hi @Kerri S
Currently Chart Widgets can only use the Top-level Grouping/Summary in a Report in order to create a Chart, as you've found. (See the announcement post on this feature.)
The way I would gather the data you're looking for is to create a helper column in my source sheet. In this column I'd write a column formula which brings together the value from both the PI Group and Epic Name into one cell, ex:
=[Pi Group]@row + " - " + [Epic Name]@row
Then I would add this column to the Report and Group by this helper column instead. This would then mean you only need one Grouping to show your second level, while still keeping the PI Group name associated with the Epic Name.
Once your Report only has one level, you can then use it as a source for your Chart Widget!
Let me know if this makes sense and will work for you.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
Hi @Kerri S
Currently Chart Widgets can only use the Top-level Grouping/Summary in a Report in order to create a Chart, as you've found. (See the announcement post on this feature.)
The way I would gather the data you're looking for is to create a helper column in my source sheet. In this column I'd write a column formula which brings together the value from both the PI Group and Epic Name into one cell, ex:
=[Pi Group]@row + " - " + [Epic Name]@row
Then I would add this column to the Report and Group by this helper column instead. This would then mean you only need one Grouping to show your second level, while still keeping the PI Group name associated with the Epic Name.
Once your Report only has one level, you can then use it as a source for your Chart Widget!
Let me know if this makes sense and will work for you.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
-
It makes sense and is now working. Thanks so much!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives