eazyBI Report to track Created, Completed, Canceled and Rejected Issues

Questions & Answers
,
2

Hi,

The following custom formulas could be used for this report:

  1. The number of resolved issues for the previous day:
([Measures].[Issues resolved],
[Time].[Day].DateMember('yesterday'))
  1. The MTD can be calculated similarly using the current month:
([Measures].[Issues resolved],
[Time].[Month].CurrentDateMember)
  1. The daily average of resolved issues in the current month:
([Measures].[Issues resolved],
[Time].[Month].CurrentDateMember)
/
DateDiffWorkdays(
     [Time].[Month].CurrentDateMember.StartDate,
     DateWithoutTime('today'))

Kindly,
Janis, eazybi support