All eazyBI for Jira eazyBI for Confluence Private eazyBI

Transitions and issues by type change
eazyBI for Jira

Calculated fields to analyze how many issues went through a specific type change and how many transitions of such happened in each Time period. The measures are also associated with the Time dimension.

Global calculated fields

Global calculated fields are defined in eazyBI's advanced settings.

Here are the global settings for the 3 new calculated field definitions. Keep the opening and closing quotation marks. ''', do not delete them.

[jira.customfield_ittrans]
name = "Issuetype transition"
data_type="string"
dimension=true
separate_table=true

[jira.customfield_it_chcnt]
name="Issuetype transition count"
data_type="integer"
measure=true
multiple_dimensions=["Issuetype transition","Time"]
javascript_code='''
var result=[];
for (hist of issue.changelog.histories) {
  for (item of hist.items){
    if (item.field=="issuetype") {
        result.push((item.fromString?item.fromString:"") + " => " 
                     + (item.toString?item.toString:"") + ","
                     +   hist.created.substr(0,10) + ",1"
                     );

    }
  }
}
return result.join("\n");
'''
[jira.customfield_it_chticketcount]
name = "Tickets with issuetype transitions"
data_type = "integer"
measure = true
sql_expression = "CASE WHEN {{customfield_it_chcnt_with_md}} IS NOT NULL THEN {{issue_id}} END"
measures_table_name = "jira_issues_measures"
aggregator = "distinct-count"

When eazyBI advanced settings are updated, navigate to Source Data view > Jira source application > import options page > custom fields tab and select all 3 fields for data import process.

issuetypech.png