How to get issue count based on a custom field value

We have 2 custom fileds one is a checbox which is to define whether the issue is reported by customer or not other is a text box to have support issueID
Want to get the number of issues reported by customer during a sprint based on the checkbox value set to Yes or custmer issueID field is not empty

Hi @Chinmay

Welcome to the Community! :slight_smile:

You can build a report like this by adding the Sprint dimension in the Rows section and defining a custom calculated measure “Customer issue counter” with the following formula:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateBetween(
      [Issue].CurrentMember.GetDate('Created at'),
      [Sprint].CurrentHierarchyMember.GetDate('Start date'),
      [Sprint].CurrentHierarchyMember.GetDate('End date')
    )
    AND
    (
      [Issue].CurrentMember.Get('checkbox') MATCHES "Yes"
      OR
      NOT IsEmpty([Issue].CurrentMember.Get('customer issueID'))
    )
  ),
  (
    [Measures].[Issues created],
    [Sprint].DefaultMember
  )
)

This formula will iterate through all of the issues and count how many of them match the filter criteria. Be sure to use the correct Issue property names instead of the “checkbox” and “customer issueID”.

Best regards,
Nauris / eazyBI support

Thank you @nauris.malitis :+1: