Date/Time Field reports

[auto98]

Hi all,

We use Jira for Change Management, as part of that we have a custom date/time field called “Actual Window Start”.

I’m being asked to produce a report on “In Hours” and “Out of Hours” changes (6am-10pm / 10pm-6am).

I’m struggling to work out how to do this, I can see two options for the output but cant work out how to get to either of them:

1. Use a start date and end date, then between those dates come up with two numbers, one for IH and one for OOH

2. A table that lists it over time, to produce a graph of “Times in AWS field” per issue over time

Any ideas?

[martins.vanags]

Hi @auto98

See a similar calculation here:

Issues created out of office hours

There are a couple of ways how to calculate the number of issues created outside office hours. First, let us look at an example to find issues created before 9 am or after 6 pm in eazyBI. To do this, you can define a created hour breakdown dimension with advanced settings: [jira.customfield_hodc] name = "Hour of Day Created" data_type = "integer" dimension = true javascript_code = ''' issue.fields.customfield_hodc = parseInt(issue.fields.created.match(/T(\d\d):/)[1]); ''' Further, select the…

Once you have imported your AWS field in eazyBI as property and measures, there would a few new measures created that you can use to calculate the expected result.

It would be something like this for out of office hours

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
(
Datediffhours(
datewithouttime([Issue].CurrenthierarchyMember.get('Actual Window Start')),
[Issue].CurrenthierarchyMember.get('Actual Window Start'))<6
OR
Datediffhours(
datewithouttime([Issue].CurrenthierarchyMember.get('Actual Window Start')),
[Issue].CurrenthierarchyMember.get('Actual Window Start'))>22
)
AND
[Measures].[Issues with Actual Window Start]>0
)
)
)

And a similar you can create for office hours.

Martins / eazyBI support