PastWeek function in indicators
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?
Thanks!
Thanks Claire Findlay for posting here.
I've raised a Support ticket for you now and the team will be in touch shortly.
Elaine Community Team at Wrike Wrike Product Manager Learn about Wrike’s killer features and best practices with our Online Training Webinars
Elaine Wrike Team member Learn about Wrike’s killer features and best practices with our Online Training Webinars
Claire Findlay you do not need to use the PastWeek function. You can simply filter creation date to be last 7d (if you want a sliding window of the past 7d) or last week (if you want a static window)
Miron Mizrahi Community Team at Wrike Wrike Product Manager Learn about Wrike’s killer features and best practices with our Online Training Webinars
Miron Mizrahi Wrike Team member Learn about Wrike’s killer features and best practices with our Online Training Webinars
Claire,
Thank you for asking this, I had the exact question.
Miron,
This worked perfectly. Thank you!