I’m trying to calculate the average amount of resolved issues from Example 2 (Avg):
--test avg debug (new)
, but with additional Date filter. I see that my results not applied with that filter, how can I fix this?
Thanks in advance!
CurrentDateMember function is fixed to the current week in your formula.
There is another formula that refers to the respective time member from the report context. Please, try the formula by replacing the function with
This function will not work at the “Last 26 weeks” member level, so we should safeguard the code from trying to find “previous” members from the “Last 26 weeks”:
Janis, eazyBI support