I am trying to make an indicator that shows the number of tasks created in the past week and the number of tasks completed in the past week and I can't get the formula to work.
PastWeek((COUNT([Task ID]), [Days in Task Creation Date])) and PastWeek((Count([Task ID]),[Task Status Group]))
These are the formulas I am using and in my mind it should work, but I am only getting #N/A in return. The formula works without the PastWeek part, but then is shows all time which is not helpful. Does anyone know what I'm doing wrong?