Hi I’m trying to create a report where we can see a team’s completed story points by sprint, which I can do, except that our management would like to see the Bugs called out specifically. Our management would like to see a stacked bar chart for each team’s last few sprints, with the issue types grouped as Bugs and Everything else.
I am currently using the Sprint Story Points Completed calculate member, but am trying to figure out how to create two calculated members or calculated measures, one that specifically exclude Bugs and one that only includes bugs.
I know that I can add the Issue Type to the Pages but that means that I won’t be able to have both values in the same report, which means I won’t be able to create the stacked Bar chart.
As stated above I am using the Sprint Story Points Completed, which uses this:
(
[Measures].[Sprint Story Points at closing],
[Transition Status.Category].[Done]
)
Is there a way for me to add a filter to this to show only bugs?
Is there a way for me to add a filter to this to specifically exclude bugs?
Any help would be appreciated.