# Sprint items committed - list

**URL:** <https://community.eazybi.com/t/sprint-items-committed-list/19522>\
**Category:** Questions & Answers\
**Tags:** jira-reports, sprint\
**Created:** [February 14, 2025, 11:40am UTC](https://community.eazybi.com/t/sprint-items-committed-list/19522 "2025-02-14T11:40:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thaina\_Penha\_Baima\_V](https://community.eazybi.com/user_avatar/community.eazybi.com/thaina_penha_baima_v/32/13485_2.png) [@Thaina\_Penha\_Baima\_V](https://community.eazybi.com/u/Thaina_Penha_Baima_V)\
**Post date:** [February 14, 2025, 11:40am UTC](https://community.eazybi.com/t/sprint-items-committed-list/19522/1 "2025-02-14T11:40:32Z")

</div>

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](https://community.eazybi.com/uploads/default/original/2X/d/d0d5ce30482b4f95586b439bc5e8d19ee3c327f8.png)

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](https://community.eazybi.com/uploads/default/original/2X/4/4a08b1e71318bbb9b4971b401ee84f4fec8847e8.png)

Could you help me?

---

<div class="post-metadata">

**Author:** ![Nacho](https://community.eazybi.com/letter_avatar_proxy/v4/letter/n/7bcc69/32.png) [@Nacho](https://community.eazybi.com/u/Nacho)\
**Post date:** [February 17, 2025, 11:09am UTC](https://community.eazybi.com/t/sprint-items-committed-list/19522/2 "2025-02-17T11:09:27Z")

</div>

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](https://community.eazybi.com/uploads/default/original/2X/d/dd4b2d96b8cd6dc3b356c58db4b6c0de791b44a3.png)

---

<div class="post-metadata">

**Author:** ![Thaina\_Penha\_Baima\_V](https://community.eazybi.com/user_avatar/community.eazybi.com/thaina_penha_baima_v/32/13485_2.png) [@Thaina\_Penha\_Baima\_V](https://community.eazybi.com/u/Thaina_Penha_Baima_V)\
**Post date:** [February 17, 2025, 11:45am UTC](https://community.eazybi.com/t/sprint-items-committed-list/19522/3 "2025-02-17T11:45:34Z")

</div>

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!!!

---

<div class="post-metadata">

**Author:** ![oskars.laganovskis](https://community.eazybi.com/user_avatar/community.eazybi.com/oskars.laganovskis/32/5902_2.png) [@oskars.laganovskis](https://community.eazybi.com/u/oskars.laganovskis)\
**Post date:** [February 21, 2025, 9:58am UTC](https://community.eazybi.com/t/sprint-items-committed-list/19522/4 "2025-02-21T09:58:39Z")

</div>

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.

```auto
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](mailto:support@eazyBI.com)