Date/Time Field reports

[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