MDX - count issues if a group member logged cumulative work > 1min

Questions & Answers
,
1

Hi,

“Logged by” dimension is good for summing the hours spent per group/user. I want to see, for example, issues resolved when time spent per group is above 1 minute.

Any suggestions?
Thanks

2

Hi Adi,

In this case, you could try importing “Logged By group” as separate dimension via eazyBI import settings

Adi_Oz_Import logged by group
Adi_Oz_Import logged by group.jpg2104×724 229 KB

Links: https://docs.eazybi.com/display/EAZYBIJIRA/JIRA+Issues+Import

Next, you could create a new calculated member in “Measures” dimension that would count the number of resolved issues where group has logged at least 1 minute

NonZero(
  Count(
    Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
 DateinPeriod(
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember
    )
    AND
    [Measures].[Hours spent]>0.0167 --1 minute in hours
    )
  )
)

Then you could use “Logged By” group in rows and your new calculated measure in columns.

Please contact support@eazybi.com if you have further questions about this!

Best regards,
Martins / eazyBI support

3

Thank you Martins!
I got an answer from your support as well.

They offered another way to look at it by issues resolved:

NonZero(Count(Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
DateInPeriod(
[Issue].CurrentHierarchyMember.Get(‘Resolved at’),
[Time].CurrentHierarchyMember
)
AND
([Measures].[Hours spent],
[Time].CurrentHierarchy.DefaultMember) * 60 > 1.2
)))

If you want to see all kind of tickets:

NonZero(Count(Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
([Measures].[Hours spent],
[Time].CurrentHierarchyMember) * 60 > 1.2
)))