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

Questions & Answers
,
1

I am trying to replicate a current Excel spreadsheet into an eazyBI report that tracks each Assignee (rows) with the columns of “Completed” (resolved) the previous day then MTD in the next column then Average Completed per Day, based on the number of Business Days in the month.

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