Issue Counts plus Ave Closed per Days in the Month

[janis.plume]

Hi,

Please, check if this response can help you with finding the working days in the month:

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

Hi, The following custom formulas could be used for this report: The number of resolved issues for the previous day: ([Measures].[Issues resolved], [Time].[Day].DateMember('yesterday')) The MTD can be calculated similarly using the current month: ([Measures].[Issues resolved], [Time].[Month].CurrentDateMember) The daily average of resolved issues in the current month: ([Measures].[Issues resolved], [Time].[Month].CurrentDateMember) / DateDiffWorkdays( [Time].[Month].CurrentDateMem…

Kindly,
Janis, eazyBI support