Creating a stacked Bar based on Isempty vs not empty

I am hoping that someone may be able to help, I am wondering if it is possible to create a stack bar chart based on if a property is empty or not? The field is a custom field and can only be imported as a property. what I would like to be able to show, is if this field has been completed, and be able to drill by project and time hierarchy.

I am new to this so any assistance would be hugely appreciated

Hi @GraceM ,
there are several options depending on how many issues and values you have for this custom field.

1. Import the customfield as a dimension.
Here is a custom field definition example, that overrides default setup and imports field as dimension:

data_type = "string"
dimension = true

Use the Jira custom field ID instead of NNNNN in the definition above.
Add the updated custom field definition to eazyBI advanced settings or ask Jira administrator or eazyBI administrator to do this for you. eazyBI advanced settings are common for all accounts and only Jira/eazyBI administrators have access to the settings.

Then you can create a calculated member in the newly created dimension to indicate that all non-empty values:


After that create two new calculated measures in the Measure dimension to indicate:

  • Issues without value
([Measures].[Issues created],
[Customfield].[Except none])
  • Issues with value
([Measures].[Issues created],
([Measures].[Issues created],
[Customfield].[Except none])

2. Create an MDX formula that checks whether the field is or is not empty.
Here is an example:

3. Create a JavaScript calculated custom field.
In case there are some performance issues because of many values, you can create a JavaScript field with Yes/No values depending on condition.

Kind regards,
Gerda //