# How to get the number of issues which are passed certain specific status by some custom field options?

**URL:** <https://community.eazybi.com/t/how-to-get-the-number-of-issues-which-are-passed-certain-specific-status-by-some-custom-field-options/8117>\
**Category:** Questions & Answers\
**Created:** [October 19, 2021, 2:52pm UTC](https://community.eazybi.com/t/how-to-get-the-number-of-issues-which-are-passed-certain-specific-status-by-some-custom-field-options/8117 "2021-10-19T14:52:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Suchithra](https://community.eazybi.com/user_avatar/community.eazybi.com/suchithra/32/5376_2.png) [@Suchithra](https://community.eazybi.com/u/Suchithra)\
**Post date:** [October 19, 2021, 2:52pm UTC](https://community.eazybi.com/t/how-to-get-the-number-of-issues-which-are-passed-certain-specific-status-by-some-custom-field-options/8117/1 "2021-10-19T14:52:11Z")

</div>

Hi Team,

My requirement is to get the number of issues present in specific sprint v/s committed. Committed will depends on the passed status by some custom field options.  
For example–\> passed status in the sense, issue was in “Dev Complete” status.

Regards,  
Suchithra S

---

<div class="post-metadata">

**Author:** ![martins.vanags](https://community.eazybi.com/user_avatar/community.eazybi.com/martins.vanags/32/8905_2.png) [@martins.vanags](https://community.eazybi.com/u/martins.vanags)\
**Post date:** [October 20, 2021, 9:38am UTC](https://community.eazybi.com/t/how-to-get-the-number-of-issues-which-are-passed-certain-specific-status-by-some-custom-field-options/8117/2 "2021-10-20T09:38:35Z")

</div>

Hi @Suchithra

First, make sure that you imported your custom field as dimension to group report results by field values.  
Then create, new user-defined [calcualted measure](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures) to count issues that reached the “Dev Complete” status.

```auto
(
[Measures].[Transitions to status issues count],
[Transition Status].[Dev Complete]
)

```

Later, add the custom field dimension to split the measure by custom field value options. eazyBI will group results based on the current custom field value, unless you import field with [change history](https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-custom-fields/advanced-settings-for-custom-fields#Advancedsettingsforcustomfields-Importchangesofcustomfielddimensions).

Martins / eazyBI

 ![image](https://community.eazybi.com/uploads/default/original/2X/b/b3c0a395b2ba92b2613c1f32105dd77dd9acc9c8.jpeg)