Issues created out of office hours

calculatedmembers

#1

Hi,

It would be possible to calculate the number of issues created outside office hours (in this example before 9 am or after 6 pm) in eazyBI.

Please create a new calculated member in “Measures” dimension using the following code:

NonZero(
Count(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
(
Datediffhours(
datewithouttime([Issue].CurrenthierarchyMember.get('Created at')),
[Issue].CurrenthierarchyMember.get('Created at'))<9
OR
Datediffhours(
datewithouttime([Issue].CurrenthierarchyMember.get('Created at')),
[Issue].CurrenthierarchyMember.get('Created at'))>18
)
AND
[Measures].[Issues created]>0
)
)
)

It will create a new measure that would return the number of “Issues created outside office hours”

Cheers!