Good afternoon. Looking for assistance on a quick problem. I’m building a report that shows Content (Issue Type) that is not assigned to a Sprint. The problem comes into play when I have team members that have tagged content issues types as tasks and stories. So I built a calculated member, [Issue Type].[Tasks and Stories] that sums up all the tasks and stories.
But having trouble filtering that to only include those that have the word “content” in their summary.
Please help.
Hi @rodjay5,
A summary is a free format text and not well suited for filtering data. Anyhow, there are several options to do this.
You can define a new calculated measure in Measures that would go through all issues and check on the Summary field for each. This is quite a resourceful calculation and might impact report performance. (More details here in the documentation: Calculated measures)
Please see this community post for more details on this solution:
A better solution would be to precalculate (group) issues with specific text pattern in a summary and import this grouping as a new dimension using a Javascript calculated custom fields. This is a better solution as it would not impact report performance and you may reuse this dimension with any Measure already available. (More details here in the documentation: Account specific calculated fields)
Please see this community post for a similar solution and JavaScript code example:
Best,
Zane / support@eazyBI.com