All eazyBI for Jira eazyBI for Confluence Private eazyBI

Account specific calculated fields
eazyBI for Jira

Overview

The "Add new calculated field" option allows you to define new JavaScript calculated custom fields in the Jira import options. However, unlike defining new JavaScript calculated custom fields in eazyBI advanced settings, these custom fields are available for import into the particular Jira issues cube only.

This option is available for Jira system administrators, Jira trusted users, eazyBI admins, and eazyBI account users with roles allowing source data import. The settings are applied only within the specific Jira source application import.

New calculated fields are available in eazyBI for Jira Cloud and starting from version 6.6.0.

New calculated field

eazyBI can include new JavaScript calculated custom fields into the Jira source data import with the new calculated field option. You can [2] Add new calculated field from the eazyBI import options [1] "Custom fields" tab.

If you base your calculation on existing custom fields, you must first import these custom fields (at least as property) into the data cube.

First, specify the [1] Internal name for the new calculated field - a unique name using only lowercase letters, numbers, and underscores.

Choose a [2] Display name for this calculated field that will appear in the Jira import custom fields selection and be imported in the Analyze view.

Select which [3] Data type the calculated field will return - "string","text","integer","decimal","date","datetime". Depending on the selected data type, other custom field options will appear.

If necessary, you can [4] Add additional advanced settings for the calculated field. These settings are similar to the ones described in the custom field import options.

Finally, use [5] Custom JavaScript code to calculate and return the results with the JavaScript return  statement. The return statement is a major difference compared to how JavaScript calculated custom fields assign value to fields defined in the eazyBI advanced settings. The dialog is similar to the one described in the custom field import options.

Use the JavaScript return  statement to retrieve the value changed with custom JavaScript code.

Once you have defined the new calculated field and its options, click [6] Create and see how to apply them.

Custom Field Assistant

AI assistants are available in eazyBI for Jira Cloud and Data Center (since eazyBI version 8.0)

You can ask the custom field assistant to generate the JavaScript code for a specific purpose, explain already written code, or ask about custom field settings. 

Custom field assistant does not collect your data, only the prompts you are writing in the conversation window. For more details on privacy and how this works, see the eazyBI Assistants FAQ.

Examples

Here are several examples: