Filter issues by Summary text

Questions & Answers
1

I’ve built a report that correctly displays avg resolution time of an issue. What I’d like to do is zero in a specific, repeating sub-task of those issues. The only way I can think of to filter them is by Summary, as they all have the same summary. How would I go about doing this?

2

You can apply the condition in your measure to filter off issues by the issue summary. Note that issue summary is a part of the issue dimension member name and you can apply the MATCHES function to it:

CASE WHEN
  [Issue].CurrentHierarchyMember.Name MATCHES '.*any.*' THEN 0
ELSE
  NonZero([Measures].[Average resolution workdays])
END

You can use the pattern matching string to filter your issues as provided above. See here for more on the regular expressions: https://docs.eazybi.com/eazybi/analyze-and-visualize/regular-expressions

Kindly, Janis, eazyBI support

1 Like