[From Wrike] Using the NOW() function to reference today ๐
Mobeen Tahir Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores prรกticas em Wrike com o nosso Treinamento Webinar Online
Mobeen Tahir Wrike Team member Aprenda sobre as funcionalidades e melhores prรกticas em Wrike com o nosso Treinamento Webinar Online
Hi Mobeen,
Thank you a lot for this useful article related to Analyze and NOW function! I have one questions if I may.
I wanted to see when was the last and only last change in any of the task within the project (to see the latest activeness). Is this possible? So far I created the below formula, but the numbers of days are really high and I think they might not capture only ONE, LAST change from all task status changes:
DDIFF (NOW ([Days in Task Status Change History Previous Change Date]),[Days in Task Status Change History Previous Change Date])
Kind regards,
Mateusz
Hello Mateusz Pawlak,
Thank you for your feedback and I am glad you found the article useful!
Your use case is quite interesting and a good use of the NOW function to calculate that. First thing I'd like to mention is, it would be better to use the field "Task Status Change History Change Date" instead of the field you used ""Task Status Change History Previous Change Date". The latter gives the date of a previous change and since we want to calculate the latest change, we should use the first field I mentioned. You can find more information on these fields here: Wrike Analyze - Available Data
To calculate the time difference between the the status change and the current time, you are on the correct path. The base formula you have is correct (by replacing the field as I mentioned above) and your use of NOW is set up correctly. But to make sure we only capture the latest change we would need to define that in the formula with the help of multi-pass aggregation. Your formula would look like this:
To explain, I am using the MIN function (minimum) to group all my status change dates and capturing only the smallest one. The smallest value should represent the latest status change that happened. If you are using a pivot table with task names as one of your columns of the table, this will automatically run one by one for each task and capture the minimum value of the date difference between NOWย andย Task Status Change History Change Date.
Please let me know if this formula works for you, or if you have any more questions.
Thank you.
ย
Mobeen Tahir Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores prรกticas em Wrike com o nosso Treinamento Webinar Online
Mobeen Tahir Wrike Team member Aprenda sobre as funcionalidades e melhores prรกticas em Wrike com o nosso Treinamento Webinar Online
Hi All,
ย
I used the following formula to find the number of days past due date. DDIFF([Days in Project Due Date],NOW([Days in Project Due Date]))
For the first few times it was showing an error to populate the data with error message it could not populate for live data.
Now the data is populated but is showing wrong values. could you help to tweak the formula to get the right values.
Or kindly advice how to achieve the required data in analyse.
Thank you very much for your support
Hi Nishanth Joseph, welcome to Wrike forums ๐ย
I've now asked our Wrike Analyze experts from the Support team to reach out to you about this, they should be in touch soon.
Let me know if there's anything else I can help you with and be sure to check out our New to Community forum ๐
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
Hi! Can the now function be used to set the start date? I have a Blueprint for a project where some tasks need to be started as soon as the project is created, but I don't want the entire project to be based on today's date.
Hi Amber Vollmar, welcome to the Community ๐
I've asked our Support team to reach out to you about this ๐ Please feel free to post the answer here after you speak with them, and let me know if you need help with anything else!ย
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover