Filtering Multi Labels

Questions & Answers
, ,
1

Hi there,

I’m facing some challenges when trying to create a report with filtering multi labels. I have 5 labels: X, A, B, C and D. X defines the issue category, while A, B, C and D define the situation of each issue. I need to create a filter to show the X issues and their status. I tried to create a measure filtering the label X: ([Measures].[Issues created count], [Label].) and the Rows as the labels A, B, C and D. But, what happens is that the report doesn’t differentiate the X labels for each one of the status labels, that means, I’m getting the total number of X labels for all the rows. For example, if the total number of X labels is 10, I’m getting the number 10 for all the rows A,B,C and D. How can I solve this?

2

Hi @guilhermepass7,

Welcome to the eazyBI community!

The dimensions are used to categorize issues. These categories work fine for slicing data on the database level.
However, if you need multiple simultaneous conditions on the same multi-value dimension - the solution is not that simple.

The possible options are as follows:

  1. iterate through all issues and inspect each issue separately for compliance with the conditions - easiest to build, does not require data admin role for implementation, but there are limitations and the report will be slow on larger datasets

  2. use calculated customfield dimension to duplicate the Labels dimension and then you can use that other dimenson to filter issues that comply with the conditions of both selections - relatively simple to implement (i line of JS code), more flexibility, inexplicit categories

  3. use calculated customfield dimension where you assign issue a category based on the presence of the label X - a bit more complex to implement (2 lines of JS code), explicit usage, neat look of the report

Please read more about creating calculated customfields here - Account specific calculated fields.

The JS code for the 2) might be as follows.

return issue.fields.labels;

The code for the 3) might be something like the following.

if (issue.fields.labels && issue.fields.labels.indexOf("<label X>")>0){
 return "<category name>"}

I would suggest that you create an additional category dimension for explicit usage.

Regards,
Oskars / suppor@eazyBI.com