Sprint items committed - list

Questions & Answers
,
1

Hello,

I need to list all the activities that were committed in the beggining of the sprint, but I haven’t got there yet.

I have this formula:

Generate(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Sprint issues committed] > 0
),
[Issue].CurrentMember.Name, ", "
)

But it’s still not working because the information is repeating:

image
image1376×635 115 KB

Filters: project, sprint
Rows: issue type, issue
Column: the formula

When I take “issue” out, I have the information but it doesn’t appear organized. I nedd it per line:

image
image1374×427 64.7 KB

Could you help me?

2

If you only need to show the issues per Sprint and per type, why don’t you simplify and use only the “Sprint issues committed”?
Where “Sprint” Dimension can be either in Rows & Filter or directly in the filters.
And when you select the “noempty” in the rows and “Hide empty for Rows and columns” all of the not committed issues will dissapear.

Like this:

image
image2177×582 73.8 KB

2 Likes
3

Hi Nacho

Thanks for you contribution!!! It worked.

Just one point: could I hide the column with numbers? 'cause this information will be part of a report to my clients and this information it’s not important…

Thanks, so many thanks!!!

4

Hi @Thaina_Penha_Baima_V ,

If you remove the measure from the report, there is nothing the report should display.

However, if you only want to display the list of issues, you might adjust your initial expression by using newline character instead of comma for splitting of displayed strings.

The expression might then be as follows.

Generate(
-- filtered set of committed issues
 Filter(
-- set of selected issues
  Descendants(
    [Issue].CurrentMember,
    [Issue].[Issue]),
-- filter condition
  [Measures].[Sprint issues committed] > 0
),
-- string to display for each filtered member
[Issue].CurrentMember.Name,
-- split by newline character
 CHR(10)
)

Regards,
Oskars / support@eazyBI.com

1 Like