Aggregate # of issues with multiple labels (Label 1 AND Label 2) and provide the count of issues per each release

Questions & Answers
, ,
2

Hi @jkamepalli,

I believe we had an internal support conversation regarding this :raised_hand: . I will post the conversation summary below for other users to reference if they have a similar question.

To get the combination of all label selections, I recommend defining and importing the Label field as a CSV (comma-separated-values) dimension, with parameters in the eazyBI advanced settings similar to the ones below:

[jira.customfield_labels1]
name = "Alternative labels"
data_type = "string"
dimension = true
multiple_values = true
split_by = ","
csv_dimension = true
javascript_code='''
   issue.fields.customfield_labels1=issue.fields.labels.join(",");
'''

Next, I suggested a calculated member in the newly defined dimension to get members where three specific labels are present. The formula was similar to the one below:

Aggregate(
  Filter(
    [Alternative labels].[Alternative labels].Members,
    [Alternative labels].CurrentMember.Name MATCHES '.*(^|,)app_1($|,).*'
    AND
    [Alternative labels].CurrentMember.Name MATCHES '.*(^|,)demo($|,).*'
    AND
    [Alternative labels].CurrentMember.Name MATCHES '.*(^|,)Development($|,).*'
  )
)

Here you can find more details about defining calculated members in other dimensions - Calculated measures and members.

Best,
Roberts // support@eazybi.com