Multi labels dimension table

Hi, I was trying to make some table using labels like below:

lable1 lable2
label3 12 34
label4 56 78

I expected above like i counted manually but, it measures little wired

It shows sum of all labels I guess.

image

I tried that Jan-2021 as Time dimension but, Its number is not exactly what I want.
( reason : Jira creation day is not matched with what I want to issues on each month)

So, I want it to make that label X label dimension table.

Please anyone help me this.

Thanks!!

Hi @Aiden,

I understand that you would like to check on label combinations.
In this case, you might want to import all applied label combinations as dimension members. If you have a significant issue amount, this option will work faster and do not require custom calculations.

  1. Go to eazyBI advanced settings and add the JavaScript calculated custom field for creating new dimension “Label combinations.”

    [jira.customfield_eazybilabels]
    name = "Label combinations"
    data_type = "string"
    dimension = true
    javascript_code = '''
    issue.fields.customfield_eazybilabels = issue.fields.labels;
    '''
    

    For more details on JavaScript calculated custom fields and how to add them, please see the documentation: Advanced settings for custom fields - eazyBI for Jira.

  2. Go to import options, tab Custom fields, and select “Label combination” for data import as a dimension. Import data.

  3. In the report, set Measures on columns and select measure “Issues created”. Use dimension “Label combinations” on report rows and filter combinations of interest.

  4. Set "Label" dimension on pages and filter labels of interest. If you like, you can set Label dimension on report columns and pages at the same time: Create reports - eazyBI for Jira
    The report might look like in the picture below.

Best,
Zane / support@eazyBI.com