[EazyBI] Sum of time period in the unexpanded period.

[Alfonso Fornell]

Hello community

Is it possible that the result of a unexpanded period shows the sum of the sub periods?

In this case I need to know two qty:

• Overdue issues in end of period >> Got it in "Overdue issues (period)"
• Sum of overdue issues of all of days to know the qty that I have left unresolved but discriminating the repeated.

E.g. 10 issues on Day 1, 15 issues on Day 2 (5 of them appear on Day 1) >> Total: 20 issues

Thanks a lot for your help!!

[Janis Plume (eazyBI)]

Hi,

One solution would be to build a new measure on the top of your "Overdue issues (period)" with the following formula:

NonZero(Count(
Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
Sum([Time.Weekly].CurrentMember.Children,
[Measures].[Overdue issues (period)]
)>0
)
))

Note, however, this calculation might give timeout for a larger account. There might be other and more optimal solutions for this case, but that might need to see how your "Overdue issues (period)" measure is implemented.

Kindly,
Janis, eazyBI support