Feature Request: Filter by date-field > X days

Hi Tyler! I think this is a really great request and personally something I would find extremely useful, particularly for creating Dashboards and widgets. 

What would you use it to monitor?

I have a monthly meeting with the IT team and a weekly meeting with the web team. The first thing we hit on is what's been checked off the list and what new items have come up that may have distracted from other active tasks. I would find it very useful to have a widget that reports task created in the last X days and another that shows completed tasks in the last X days.

That's a great example use case, I hadn't thought about doing something like that before, but it makes a lot of sense.

Thank you for sharing :)

Hey Tyler! I guess you might also be interested in this feature request. Feel free to add +1 to it :)

I am trying to build a Report that I could choose to look at 'whenever' that would show me what tasks a team completed in the last few days.

My only filtering options for the "Completed Date" field are too 'absolute' (today, yesterday, this week, last week)... I'd like something relative to TODAY, but not just within this "week" - which seems to be Monday to Sunday or the like. I want "within the last week" - so a *rolling* 7 days.

If I build the report for "this week" or "last week" I'll always be missing something and have to look at BOTH reports when I want to know what happened in the last 7 days. Irritating and misleading.
Thanks for considering this improvement!

Hi Jamie! That's an awesome use case! Thanks a lot for sharing it here. Please feel free to upvote the original post to increase its priority for our Product Team. 

As a leader, its important to recognize the accomplishments of my team prior to focusing on the work to be done. It helps people feel appreciated (they are appreciated) and makes work less of a grind. It's very kludgy to generate a report that isn't very dynamic versus the dashboards where we can click into the completed work and potentially see what they did. Definitely up voting this one! 

Totally agree. Thanks for flagging this.

Hi everyone, thank you for your continued feedback here!

We did recently release two filters "7 days ahead" and "30 days ahead" which let you filter for future tasks which are 7 or 30 days out. Our team has been using these internally to keep track of tasks, would love to know if it helps with some of your use cases as well 👍

Stephen - we are looking for 7 days prior. The 7 and 30 days ahead are helpful but don't capture what's been accomplished in specific projects over the last 7 or 30 days in a dashboard.

Totally understand Joelle, thanks for coming back to me. We'll make the Product Team aware and post back here with any future updates 👍

+1 to the original request. 

I now to see at a glance the tasks that have been completed in the last 7 days. right now I need 2 columns to do this (this week+last week) and that actually includes tasks older than 7 days so definitely not ideal.

I believe the original request here would meet a need that I'm running into. I would like a widget on a dashbaord that shows any task that was due more than X days ago. The use case is that I want to keep track of any task assigned to my team or myself that has either fallen off our radar, or was potentially orphaned or made irrelevant and not cleaned up. My preference is for this to be implemented by an additional option in the due date filter of custom widgets that allow the input of a "greater than" parameter. Alternatively, if there was a way to have a widget group tasks by how overdue they are (e.g. "One week overdue", "Two weeks overdue", etc.) similar to the grouping of upcoming tasks, that would be helpful as well.

Hi! My use case is similar to Jake's. I would like to track any tasks for which the status has remained unchanged for X days.

We have a status called "Waiting for third party" and we chase the "third party" every 5 working days. Therefore, I would like to have a list of tasks with the status "Waiting for third party" unchanged for 5 or more days to know when to chase.

I'm back - and still incredibly frustrated by the way filtering works for dates. It's been over a year since I first responded to this and we still can't manage our workload effectively.

It's lovely, but irrelevant to me, that I can now look ahead 7 or 30 days. I'm too buried in overdue tasks to worry about tasks with Due Dates in the future, at the moment.

I really want to filter on the "last 30 days" (or last X days) - not "this month" when it's only the 3rd of the month!

I can't even filter by BOTH 'this month' AND 'last month' in order to fake the system into giving me what I want (the filters are mutually exclusive radio buttons despite looking like multi-select checkboxes).

😤😠😡

Product Team: It's time to start worrying about churn, and not just new-customer acquisition. Reports (Dashboards, Views ... mastering your data) matter to long-term customers (or should I say 'reference customers'?). Your product is not meeting the needs of someone like us who does long-term planning and non-repetitive projects, with resources that are over-loaded and thus not crossing-off tasks as fast as they're created.

Hi everyone, thanks for sharing your feedback here. For now I don't have an update for you, but I wonder whether the "Timeframe" filter option might help? 

I'll get back to here as soon as I have and update to share. 

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

Time frame is no good since it is fixed and not dynamic. This request if for configurable dynamic range. Today, yesteday, last month,.. are all dynamic but they only cover very basic needs. For example i need a filter for "created in last 7 days", but there is no point to spam so specific filters in UI, just make one dynamic that will cover everything. Similar to time frame but instead of "1.3 till 4.3". we would specify "-5 to -1".

Actualy we were so displeased generaly with filter, search and discoverability options on wrike that we are now dumping everything via Wrike API to onpremis database and are doing more and more reporting and dashboards from our own database... This tells you how dire current situation is.

@Robert

We're doing much of the same. We love the overall product, but are finding many cases where the reporting options fall short, so have hit up the API to mash that info into our on-prem database for better reporting and visibility to our customers and stakeholders.

@Wrike Team

Many of the feature suggestion threads I've seen or contributed to are 2+ years old. A quick sort of feature suggestions by number of votes are also 2+ years old. What do we need to do as a community of your loyal users to push for more frequent, incremental improvements to the things we all appear to want the most?

RS

@Randall Hi, thanks for posting 🙂 The best thing to do here is to keep voting; once a suggestion reaches 60 votes, we'll add a Product Feedback status to it. Please check out Product Feedback forum: Guidelines and Statuses and What happens with Product Feedback? posts for more info. 

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

+1

Indeed, please add the option to filter (create dashboard widgets ...) tasks based on a "sliding window" scenario (e.g. created/modified in the last X days).

+1

Would like the ability to see a custom time frame backwards and forwards in a report that might be more than 30 days.

Hi Patrick Kim, welcome to the Community! 🤗

I'm checking with the team now to see if there's an update here - I'll get back to you if there is 👍

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

+1 on this report request

We have a weekly project meeting on Thursdays. I would like to run a report that shows me "completed in last 7 days" (i.e. between last week's meeting and today's meeting) to get everyone up to speed on what's been done. 

'Completed last week' and 'completed this week' are the closest things, but its not quite what I was looking for since it would always cut off or overlap with a previous report.  

Hi Sean Martin, welcome to the Community! 🤗

Thank you for sharing your feedback, it's with the Product team now 👍 

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 Lisa

there are countless requests on making the filters more flexible in the community. Could you please update us on which functionality is planned to be added or isn't this a priority for the development team?

Hello to the Wrike community !
We are really interested in this kind of application. I'm developing reports to follow our workflow. 
I would find extremely useful to do the following:

• Filter projects according to a custom field with a formula. 
  It seems like the custom fields with formula cannot be used as filters in the reports . Is this the case?
  We have use simple formula such as: date of a CF + 90 days. The resulting Custom Field does not appear in the Custom Field lists of the filter
• Filter projects having a given Custom Field ( a date) older than X months.
  This should be a dynamic filter and not just a static time frame

Are any of these feature at present available on Wrike reports ?
Thank you for any insight
Alessandro