Time dimension based on Create Date regardless of the issue status

Questions & Answers
,
1

I’m attempting to use this calculation to aggregate the number of issues based on the Create Date. Some of the issues are open, others are closed. NonZero(
Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateInPeriod(
[Issue].CurrentMember.get(‘Created at’),
[Time].CurrentHierarchyMember)
AND
([Time].CurrentHierarchy.DefaultMember,
[Measures].[Issues created]) > 0)
)
)
I have another measure in the report that shows resolved issues (tuple). When we attempt to view the report via a eazyBI dashboard, the report times out. When we open it directly it comes up fine. Not sure what’s going on but need to correct it so it comes up on the dashboard properly.

2

Hi @ShelPrice ,

Why do you need such a calculation? From the looks of it, it counts the number of issues created in the respective Time dimension period. So the predefined measure “Issues created” should already take care of that.

I recommend scrapping the calculated measure formula you shared and using the predefined measure “Issues created”. Provide more details if you can’t use the predefined measure.

Please visit the eazyBI documentation page for more details on how each measure works with the Time dimension - Jira Core measures and dimensions.

Best,
Roberts // support@eazybi.com