Count stories with specific text in Jira issue field "Description"

Hi, I am new to eazyBI and learning MDX. Could you please teach me how to count issues with specific text in a calculated member “issue property”: [Measures].[Issue Description] = [Issue].CurrentHierarchyMember.get(‘Description’) ?

Why this would not work?

SUM(Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]),
CoalesceEmpty([Issue].CurrentHierarchyMember.get(‘Description’), ‘’) MATCHES ‘.EAF.

[Measures].[Issues created]


Xiujun Guo

While this works fine:

SUM( Filter( DescendantsSet( [Issue Type].CurrentHierarchyMember,
[Issue Type].CurrentHierarchy.levels(“Issue Type”)
[Issue Type].CurrentHierarchyMember.Name MATCHES “Story”
[Issue].CurrentHierarchyMember.Name MATCHES ‘.EAF.
[Measures].[Issues created]

Hi @guox,

The issue description is not imported to eazyBI Issues cube by default. See similar question with possible resolutions here: Import JIRA Issue Description.
Additionally, if you only need to search for a particular value within the description, I would suggest options one or two to extract the word you are looking for from the description into a separate custom field and finally in the eazyBI dimension (see more about JavaScript calculated custom fields).

Lauma /