Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Conditional field in eazybi



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



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! 

2 answers

@Sir Mārtiņš Vanags  Thank you sooo much for your answer. I provided it to my Jira Admin, and the problem is resolved!

0 votes
Sir Mārtiņš Vanags
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 13, 2023

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


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 =





#cascading parent level


name = "Contract 1st level"

data_type = "string"

dimension = true

separate_table = true

javascript_code = '''

if (issue.fields.customfield_NNNNN ) {

issue.fields.customfield_cascf1stl =





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


Martins / eazyBI

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events