Hi
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
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:
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.