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:
[jira.customfield_NNNNN]
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:
Aggregate(
Except(
[Customfield].[Customfield].Members,
{[Customfield].[(none)]}
)
)
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],
[Customfield].DefaultMember)
-
([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 // support@eazyBI.com