Checklist Unique Combinations

We have a checklist field and a manager wants to see how many of each combination we have.
For example how many issues have only A, how many have A & B, etc.
Is there a calculation or a way to import the checklist as a single select type list to do this?

Hi @Kat_Jansen

eazyBI offers default import options based on a detected custom field type. You could override the custom field definition by adding additional options on how to import the custom field.

​Parameter csv_dimension = true can be used with custom fields that have dimension and multiple_values enabled. If enabled then an additional Custom field CSV dimension will be created where used combinations of values (as comma-separated string) will be imported.

For example, if an issue has a custom field with values one and two, then in the multiple values dimension Custom field two separate members (one and two) will be created and the corresponding measure values for this issue will be stored for each of these members. If csv_dimension is enabled, then in the Custom field CSV dimension one member with comma-separated values (one, two) will be created and the corresponding measure values will be stored for this member. You can use this additional CSV dimension if you want to filter measure values for issues that have both values in the custom field.

Here is a custom field definition example, that overrides the default setup:

data_type = "string"
dimension = true
multiple_values = true
csv_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.

Gerda //