Regarding EazyBI Hours spent

[admin]

HI Team,

I am trying to calculate the Hours spent in different ranges like <1hr,>=2h and <=8h etc.

But i am not able to find how to write ranges in new calculated measures. 

Can you 

please help me here?

[Sir Mārtiņš Vanags]

Hi,

In this case, you could use eazyBI advanced settings to define a new calculated custom field using Javascript.

Then you could import this field as a separate dimension and use it in your reports.

Try this Javascript&colon;

[jira.customfield_hsgr]
name = "Hours spent interval"
data_type = "decimal"
scale = 4
dimension = true
javascript_code = '''
var timesp = issue.fields.timespent
if (timesp){
issue.fields.customfield_hsgr = timesp
}
'''
time_unit = "seconds"
time_interval = "duration"
intervals = "1,2,8"
interval_unit = "hours"

Martins / eazyBI team.