Hi Michael,
With the help of eazyBI calculated measures, it is possible to create your expected calculation.
As I understand your question, you would like to create two calculated measures:
You could use formulas below. But be aware of calculated measure names in formulas.
Please also find documentation how to create calculated members in eazyBI:
Issues resolved before due date:
NonZero(Count( Filter( Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]), [Measures].[Issues resolved] > 0 AND DateDiffDays([Issue].CurrentMember.get('Resolved at'), [Issue].CurrentMember.get('Due date')) > 0 ) ) )
Issues resolved before due date % from all resolved issues:
CASE WHEN [Measures].[Issues resolved] > 0 THEN [Measures].[Issues resolved before due date] / [Measures].[Issues resolved] END
Please contact support@eazybi.com if you have further questions regarding this!
Kind regards,
Martins Vanags / support@eazybi.com
You may be able to create a calculated field for Overdue and use that for your pie chart (which will give you percentages)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.