Custom fields are grouped by the add-on which has defined these custom fields. User-defined custom fields with standard custom field types that are imported as dimension will appear in the dimension group "Other" when you create a new report or make changes to the existing one.
Standard custom field types
Currently, the following standard custom field types are available for import:
- Text Field (< 255 characters) - as property
- Free Text Field (unlimited text) - as property
- Number Field - both as property and as a measure
- Date Picker - both as property and as a measure
- Date Time - as property and as a measure
- Select List - both as property and as dimension
- Radio Buttons - both as property and as dimension
- User picker - both as property and as dimension
- Multi-User picker - both as property and as dimension
- Multi Checkboxes - both as property and as dimension
- Multi-Select - both as property and as dimension
- Labels - both as property and as dimension
- Cascading Select - both as property and as dimension
- Project picker - both as property and as dimension
- Single version picker - both as property and as dimension
- Version picker - both as property and as dimension
From the list of available custom fields, you can select which custom fields you would like to import as properties (corresponding calculated measure “Issue …” will be defined which will show custom field values for Issue dimension detailed members) and which custom fields you would like to import as dimensions (only list-of-values type custom fields are available for import as dimensions) or measures (see below). For custom number and date fields you can also select Import value changes (see below).
For example, if you have custom field Customer with Select List type then you can import it both as dimension and property. You will able to create reports by the Customer dimension as well as you will have Issue Customer calculated measure. If you will select Issue dimension all Issue level members on rows then on columns you can select Issue Customer calculated measure and will see Customer custom field value for each issue.
Add-on custom fields
Please read more about supported Jira Software (Agile), Jira Service desk, Zephyr Test Management, Xray Test Management, Elements Connect (formerly Nfeed), and Tempo Timesheets custom fields.
See advanced settings that are necessary to import of Multi-Level Cascading Select add-on custom fields.
If you need support for more custom field types then please contact eazyBI support and describe your needs.
Totals of custom number fields
If you would like to get totals of custom number fields then when doing Jira import in Source Data tab please select Import as measure for these custom number fields.
E.g. if you will import as measure custom field Story Points then after import you will have added three measures Story Points created (total is calculated for all issues and is assigned to issue creation date on Time dimension), Story Points due (total of all unresolved issues and is assigned to issue due date) and Story Points resolved (total of all resolved issues and is assigned to issue resolution date).
Additionally, there is a hidden measure "Issues with ..." imported for all custom number fields that show the total count of issues that have value in the custom field. These measures can be used for average calculations. For the Story points custom field this would create additional Issues with Story points created, Issues with Story Points resolved, Issues with Story Points due hidden measures.
Measures with custom date fields
You can select Import as measure also for custom date fields which will result in an additional set of measures for this custom date field. For example, if you have a custom date field with name Custom date and will import it as measure then, as a result, additional measure Issues with custom date will be imported which will show total of issues which have this custom date field specified and it will be assigned to the corresponding date on Time dimension.
In addition measures with prefix "with custom date" will be defined for all custom number fields which are imported as measures. E.g. if you have custom field Story Points which is imported as the measure then also Story Points with custom date measure will be imported.
Custom number of field value changes
If you would like to get totals of historical custom number field values then select Import value changes for this custom field in Jira import custom field selection.
For example, you would like to track Story Points changes and historical values. After the import of value changes for this custom field, you will get additional Story Points change measure (total positive or negative change of story points in selected Time dimension period) and additional Story Points history calculated measure (historical total of story points at the end of selected Time dimension period).
Custom date field old values
If you would like to see old values of custom date field then select Import value changes for this custom field in Jira import custom field selection (and select Import as property to see its current value).
For example, if you have Custom date field then you will get Issue Custom date calculated measure which will show current field value when used with Issue dimension detailed members (see above) as well as additional Issue Custom date old values calculated measure which will show concatenated list of previous dates that this custom field had (concatenated dates will be in format YYYY-MM-DD).