Original estimate hours in Dimension

Questions & Answers
1

Hello,

How can i get original estimate hours in Dimension instead of measures.
In business day format instead of hours,

Regards,
Rohitkumar

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
3

Thank you for your reply.
Can you provide a javascript code to get time in days format like 8 hours = 1day for original estimate dimension.

4

Hello @zane.baranovska,

One more thing to add , in need Original estimated hours with sub-tasks.

Regards,
Rohitkumar

1 Like