You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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?
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:
[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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.