All eazyBI for Jira eazyBI for Confluence Private eazyBI

Transitions for issue priorities
eazyBI for Jira

This example creates two calculated custom fields for analyzing issue priority changes: a dimension listing each "from => to" transition, and a measure counting how many times each transition occurred over time.

Global calculated fields

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

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

[jira.customfield_prioritytrans]
name = "Priority transition"
data_type="string"
dimension=true
separate_table=true

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

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