Hi,
I have created two calculated member for Dimension Status, one that aggregates all status before status Done ([Status].[Before Done Total])
and the other aggregates status Done and statuses after ([Status].[After Done Total]).
I can create a new calculated member that gives the sum of them:
[Status].[Before Done Total] + [Status].[After Done Total]
This gives me correct result.
When I try to get the percentage of status [Status].[After Done Total] / ([Status].[Before Done Total] + [Status].[After Done Total])
I get a faulty result, why?
I am using EazyBI in Jira Cloud.
br
Elisabet
Hi,
The calculated members in other dimensions than Measures cannot perform the division operation. The “+” operation is allowed meaning the “aggregate” or total for the members, but the division has no meaning in the Status dimension (although you can save such formula).
The solution for the percentage is to create a similar formula as a measure. The recommended way of doing that is to explicitly mention measure in the formula with tuples reusing your members in the status dimension.
A formula like this would do that:
([Measures].[Issues created],
[Status].[After done])
/
(
([Measures].[Issues created],
[Status].[Before done]) +
([Measures].[Issues created],
[Status].[After done]))
If the members before/after covers the full set of statuses, you may write it shorter:
([Measures].[Issues created],
[Status].[After done])
/
([Measures].[Issues created],
[Status].CurrentHierarchy.DefaultMember)
Kindly,
Janis, eazyBI support