Calculate Capacity Automatically based on "Today"
Hello Community,
I have my value field for employee "Capacity" (target of hours). To showcase the same capacity for all employees, I must select a specific timeframe on the "User Schedule Date" filter (From April 10 to Jun 6).
Is there a way I can have an automatic formula or "advanced" filter so that the latest date (Today) updates automatically always and don't require me to change the date to today manually?
Thanks
I'd like to hear more about this too!
Hey folks, it looks like there is an advanced filter that can be used in a command (copying it from your conversation with our Support experts Christian Lugo, hope you don't mind 🙂):
{
"and": [
{
"from": "04-10-2023"
},
{
"exclude": {
"next": {
"count": 365,
"offset": 0
}
}
}
],
"custom": true
}
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
Lisa is there some sort of easy access cheat sheet with these codes for more advanced filters? :-)
Hi Maria Hermansen, let me put you in touch with our Support team. They should be able to assist further and advise on this 👍
Elaine Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Elaine Wrike Team member Become a Wrike expert with Wrike Discover