Date in original estimated time by other date measure

Questions & Answers
2

Hi Jose Maria

Measure Original estimate hours are related to issue creation date only. If you need to retrieve Original estimated hours with any other date, you can create a new custom field measure with JavaScript code. This measure will automatically be related to all default dates and any other date you are importing into eazyBI as a measure.

Here is a JavaScript custom field definition for Original estimated hours:

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

Please add the custom field definition to eazyBI advanced settings or ask Jira administrator to do this for you, as only Jira administrators, has access to eazyBI advanced settings.

Open Jira import settings for edit after changes in advanced settings and select the custom field for import as a measure and as a property and run an import. Import will create new measures with any date (Original estimated hours with due date, Original estimated hours with custom date, etc.) and property Issue Original estimated hours in your account.

Daina/ support@eazybi.com

2 Likes