Original estimate hours in Dimension

Questions & Answers
2

Hi @rohit,

You may import “Original estimated hours” also as a dimension using JavaScript calculated custom field. Then you will be able to group or filter issues by the “Original estimated hours” category (value).

  1. In eazyBI advanced settings, add this piece of definition with JavaScript code to retrieve original estimated hours from issue data.

    [jira.customfield_oeh]
name = "Original estimated hours"
data_type = "decimal"
dimension = true
javascript_code = '''
if (issue.fields.timeoriginalestimate) {
  timeoriginalestimate = issue.fields.timeoriginalestimate / 3600.0; 
  issue.fields.customfield_oeh = timeoriginalestimate; 
}
'''

  2. Then in import options, select custom field “Original estimate hours” for data import as dimension and property. And import data.

  3. After successful data import, you will have a new custom field dimension “Original estimated hours” for your report (see picture below).

    Dimension Original estimated hours
    Dimension Original estimated hours1652×1094 132 KB

More details on JavaScript calculated custom fields are in the documentation:
https://docs.eazybi.com/eazybijira/data-import/custom-fields/javascript-calculated-custom-fields

You may use a similar approach if you would like to group or filter issues by their size in Story Points or other numerical values. Here is a use case for Story Points:
Sprint Point Wise categorization.

Best,
Zane / support@eazyBI.com

1 Like