Filter issue types combined with a label

Questions & Answers
1

Hello, I’m trying to report a pie chart with different issue types.

All the issue types are common except one of them. I need to filter issue type “task” with label “example”.
If I use one of the typical label filters it does not work because the pie chart needs all the values within the same dimension (I can’t mix issues with labels).

How could I set an “issue type” calculated field combining issues belonging to a determined type with one or more tags?
For example "All the issues with type incident and label ‘service’ "

Thank you in advance

2

FYI I have cooked this small algorithm as calculated member of IssueType.

Aggregate(Filter(
  Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
  ([Measures].[Issues created],
  [Label].[stabilization]) = Count(ChildrenSet([Label].[stabilization])))
)

I put this as column and Measures->Hours-spent-with-subtasks as Row in order to get the total hours spent in determined issue-types combined with determined labels.

I have double-checked it and seems to work fine. Please validate this workaround :slight_smile:

Best regards

3

Hi,

We usually recommend creating such calculations only in “Measures” dimension.

Then the calculated member could be the following:

CASE WHEN
[Issue Type].CurrentMember.Name = "Incident"
THEN
Nonzero((
[Measures].[Hours spent with sub-tasks],
[Label].[stabilization]
))
ELSE
Nonzero([Measures].[Hours spent with sub-tasks])
END

This approach should work if you use “Issue Type” dimension in rows.

Best regards,

1 Like