Count configuration item in issues

Gabika · June 27, 2023, 8:24am

Good day,
please, how to calculate the number of configuration items on tickets?

zane.baranovska · June 30, 2023, 3:21pm

Could you please elaborate on what configuration items are and how you see them in eazyBI?

Gabika · July 13, 2023, 8:57am

Thanks, one issues could have two or more configuration items. And i need no number of issues, but have many configuration items is on issues.

zane.baranovska · July 13, 2023, 10:25am

If the configuration item is some issue custom field, then:

Import configuration item field as dimension and as property in eazyBI (Jira custom fields).
For the report, define a new calcauted measure that would count unique configuration items for the selected projects, issues or other report criteria (Calculated measures).
Use functions Count() and DescendantsSet() to get list of all configuration items and count them.
```
Count(
  --set of configuration items
  Filter(
    DescendantsSet([Configuration item].CurrentMember,[Configuration item].[Configuration item]),
    --check that configuration item is related to report context
    [Measures].[Issues created] > 0
  )  
) 
```

Gabika · July 14, 2023, 7:50am

Thank you so much, it is ok for one last solver, but if i need for more last solver, so it is ended with error:

Please could you help me?

and what i need is not only count, but count for 1 week, 30 days, 3 months, 6 months, 1 year