Conditional field in eazybi

Irene_z1lz56

Hello!

For setting issue categories we are using a conditional field (I hope this is the correct expression):

First we choose the main category and depending on the main category, we can select a value for the sub-category.

My problem is the reporting in eazybi:

I actually want to use rows where I can see a combination of the main and the subcategory.

 

At the moment I am only able to display like this:

MainCatA  5

SubcatA1 1

SubcatA2  4

MaincatB  3

SubcatB1  3

MaincatC   7

SubcatC1   3

SubcatC2   2

SubcatC3   2

etc.

 

The result I need would be like this:

MainCatA - SubcatA1 1

MainCatA - SubcatA2  4

MaincatB - SubcatB1  3

MaincatC - SubcatC1   3

MaincatC - SubcatC2   2

MaincatC - SubcatC3   2

 

Any help will be highly appreciated!

Thank you! 

Martins Vanags_eazyBI

Hi @Irene 

Please tell me the type for your conditional field in Jira.

Is that perhaps a Jira cascading custom field?

eazyBI would let you import cascading Jira fields as two-level hierarchy dimensions.

And with the help of advanced settings, you can define new calculated fields for eazyBI where you import each level as a separate dimension and then use them in reports.

YOu can try these codes but you must update the NNNNN with your Jira custom field ID and also the original Jira custom field must remain imported in eazyBI.

 

#cascading child level

[jira.customfield_cascf2ndl]

name = "Contract 2nd level"

data_type = "string"

dimension = true

separate_table = true

javascript_code = '''

if (issue.fields.customfield_NNNNN && issue.fields.customfield_NNNNN.child ) {

issue.fields.customfield_cascf2ndl =

issue.fields.customfield_NNNNN.child.value;

}

'''

 

#cascading parent level

[jira.customfield_cascf1stl]

name = "Contract 1st level"

data_type = "string"

dimension = true

separate_table = true

javascript_code = '''

if (issue.fields.customfield_NNNNN ) {

issue.fields.customfield_cascf1stl =

issue.fields.customfield_NNNNN.value;

}

'''

 

Don't forget to select both fields and import data after you updated advanced settings.

 

Martins / eazyBI