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?
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