Hi @cybertachikoma,
The total calculation gets confused when expanding the various Issue dimension hierarchy levels. Instead, I recommend filtering the report in the report pages to display only the desired issues with other dimensions. And use the “All” level of the Issue dimension to display the totals.
I recommend replacing the calculation for returning the number of child issues of a specific type and in a particular status category with a tuple. The formula could look similar to the one below:
([Measures].[Issues created],
[Issue Type].[CTE],
[Status.Category].[To Do])
See an example with “Story” type issues in the picture below:
We have a bug regarding the total calculation behavior with the row dimension hierarchy levels in our backlog. I added your vote to it. Unfortunately, I don’t have any estimates. We will update this post once there are any developments.
Best,
Roberts // support@eazybi.com