Sum of Custom Field over the time

Questions & Answers
1

Hello community,

I am trying to create an report visualizing efforts over the time.

In our TaskBox project we record the planned efforts of each issue. In the report I want to display the the sum of the open efforts per month.

Can somebody help me to solve this problem?

Thanks in advance,

Kind regards from Germany :grinning:

2

Hi,

In this case, you could ensure that numeric custom field “Planned efforts” field is selected (via source application import options) and imported as measures and property.

Then you could define a new calculated member in “Measures” dimenson using similar calculation:

NonZero(
Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Open issues]>0
),
[Measures].[Issue planned efforts]
)
)

That would return the sum of planned efforts for issues which are open (not resolved) at the end of each month in your report.

Martins / eazyBI support

1 Like