Summarizing Questions

Dear eazyBI Team - greetings!

Hopefully this should be a very simple one for the eazyBI experts here. Please see this screenshot for my report design:

The report shows all issues that moved into a “Ready” status between two dates, then counts the issues and finally row totals the Story Points field. I want a summarized view of this report.

I basically want only the number 46.

I hope I was clear in my request for help. Please review and help me.

Many thanks!

Hi @ssh

In this case, you could try creating a calculated measure using the following code:

NonZero(
SUM(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Transitions to status issues count]>0
),
[Measures].[Issue Story Points]
)
)

This code would be general and will work also when the “Issue” dimension would not be used in the report.

Martins / eazyBI support