Sum of Custom Field over the time

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:


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:

[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