[Status: Coming Soon...๐Ÿ•‘] Filtering by Custom Column Values- AND/OR logic

Em destaque

It would be immensely helpful in creating new Dashboard widgets to be able to make a widgetย including two values of a column. So if Column Division has values of CAC, CLE, CTR, PEN, and FCT, I want a widget for one person to be able to track CLE and CTR, while another person wants to track CAC and FCT. Right now, those each have to be a separate widget

So if Column Division has values of CAC, CLE, CTR, PEN, and FCT, I want a widget for one person to be able to track CLE and CTR, while another person wants to track CAC and FCT. Right now, those each have to be a separate widget (one for CLE, one for CTR, etc), cluttering up Dashboards of not-so-power users who just want to see their stuff.

There's not enough in common with the field values to use Starts with, Ends with, or Contains, and commas or andsย don't join two search terms. It needs to be a little more complex.

Upvote 73
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
47 comentรกrios

Hi Sarah, thanks for posting this on the Community! Our Product Team is currently discussing possible ways to improve the Dashboard functionality, and your feedback is definitely helpful.

While at the moment itโ€™s not possible to create a Dashboard widget that would include tasks with 2 different values of the Custom Field, itโ€™s possible to achieve that using Reports. Please note that it will work only for dropdown-type Custom Fields.

Hereโ€™s how you can do it:

  1. Click โ€œReportsโ€ at the top of the Workspace and select โ€œNew Report From Scratchโ€.
  2. Choose โ€œTasksโ€ on the first step of the Report Builder.
  3. Select Folders and Projects you would like to include data from.
  4. The third step allows you to apply filters. Click โ€œAdd more filtersโ€ if you donโ€™t see the Custom Field you want to use for filtering tasks and select the necessary values of the Custom Field (in your example youโ€™d choose โ€œCACโ€ and โ€œFCTโ€).
  5. Choose the โ€œTableโ€ layout and click โ€œSave and Viewโ€.

The Report will show you tasks with values โ€œCACโ€ or โ€œFCTโ€:

Do you think it could work for you? Let me know if you have any questions about it, Iโ€™m always happy to help!

Anna G Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores prรกticas em Wrike com o nosso Treinamento Webinar Online

Anna G Wrike Team member Aprenda sobre as funcionalidades e melhores prรกticas em Wrike com o nosso Treinamento Webinar Online

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hey! ย I'd like to second the request for Boolean Operators when creating a dashboard. ย I thought it would be simply to have a widget of tasks assigned to both UserA and UserB, But, instead I get all tasks assigned to UserA and all tasks assigned to UserB.

5
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

I'd love to have options for and/or logic in the forms, similar to matching all or matching any criteria.

ย 

I have forms that I would like to view custom fields (dates) by last week, this week, etc. But I want it to bring back results that match any criteria.

(i.e. if Job A has delivery date 1 as this week, but Job B has delivery 2 date this week, and Job C has delivery 3 date this week)

ย 

I was to see all those delivery dates in one view regardless of when the other delivery dates are. If any hits this week I want to see it in one report.

ย 

+1!!

2
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Filters on lists and grids don't allow operators either. ย These would also be nice to have.

2
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Definite votes for AND/OR logic to be added to filters on reports.

ย 

7
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
Avatar
Stephanie Westbrook

@Prentiss I just want to clarify quickly to make sure I understand. Would you like to see and/or functionality when filtering for Custom Fields in the List and Table Views?

2
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Yes! ย And not to pile on, but it would also be nice if the List and Table Views used the Date drop down for filtering rather than the string drop down. ย In list and table views, when filtering on custom date fields you can't choose a range of dates.

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
Avatar
Stephen

Hi Prentiss, thanks for the clarifying Stephanie's question. For your other suggestion about date ranges for Custom Fields, I really like this idea and would recommend posting as a stand alone Feedback post with more detail so members can upvote and discuss the idea.ย 
ย 
Also, you're never piling on! This is the right place to share your feedback and we really appreciate it ๐Ÿ™‚
0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

+1 on the OR/AND logic in dashboard AND in the search bar please. (if you have to do one before the other, dashboard definitely first!)

We are (about to be) using the professional version of Wrike and therefore have no access to reports so this is a really mandatory feature for us that will actually decide whether we are going all-in with Wrike or not. At least knowing that it's being developed would be good.

Regards,

Romain

3
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

We really need the AND/OR Logics built in for Dashboards, Reports, and Calendar features.ย  It is real discouraging missing feature with new team in Wrike (+250 users).ย  Is there a timeline for adding this feature?

3
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Our dashboard are becoming quite clutteredย with increasing usage of custom attributes. We are forced to make many seperate dashboards, with AND/OR filtering conditions we could combine them.

This filtering overhaul should of course be across the board, for example the Edit functionality in Dashboards does not cover all functionality, also advanced filters like "notin" should be available like any other filter not hidden inside search field.

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

We really need the and/or logic built inย the Dashboard widget "Add more filters" - to best utilize the custom "Fields" we have in place.ย 

My team members need to build their own dashboards including custom fields to best see their workloads.ย 

thanks!

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Itยดs really importante to have this feature, is in the pipeline??

ย 

Thks

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

+1 Vote for an AND/OR optionย to be added in Dashboard widgets! Would be great for our users to be able to track projects they have either been assigned to or submitted for execution in 1 "My Projects" Widget on their dashboard, rather than having to have 2 separate widgets for projects they've been assigned to & another for ones they've authored.

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Would like to make a report that allows me to search on custom "build number" where I can use a comma delimiter to query multiple build numbers in one report.

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hey @All, thank you for adding your comments and upvoting the suggestion, it really helps our Product team assessing popularity and possibility of the feature. I don't have an update to share, but I'll get back to you if/when I have news.ย 

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

3
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Really need this feature. 'OR' function!

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Yes! Boolean logic for filters in all views would be SUPER helpful!

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

HI Lisa,

Any updates on this?

Thanks

Diana

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

In addition to AND/OR also NOT of course needs to be amongst the operators in order to make filtering, reports etc flexible enough.๐Ÿ˜…

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
Avatar
Hugh

Hey everyone, apologies for the delay in response here.ย 

The Product team is interested in implementing this suggestion into Wrike, but it is currently not on the short-term roadmap. Once I have further information about this, I'll be sure to let you know hereย ๐Ÿ‘

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Need this feature. Boolean logic is there on most apps for filters. Basic requirementย 

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

I agree this is a super important feature that is missing!

It is really unfortunate that this is not getting a higher priority...

1
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
Avatar
Hugh

Hey everyone, thank you for your feedback here! It's been passed on to the Product team.

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

+1 that this would be a very helpful feature.ย  Incomplete filtering options clutters and limits the usefulness of the dashboards.ย ย 

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
Avatar
Hugh

Welcome to the Community, Darrin Laudenbach!

Thank you for sharing your input here. If you need anything else, be sure to let me know.

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

+1 for AND/OR logic feature. Super important for condensing dashboards! Do we have this feature underway?

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Hi Gabe Schur, thank you for reaching out! I don't have any updates from the team regarding this suggestion; this isn't on their short-term roadmap at the moment. As soon as I have any news, I'll make sure to let you know here.ย 

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

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

+1 AND/OR logic feature. Any updates on this feature? Thanks.

0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos
Avatar
Cansu

Hello Sumanan Jeya, welcome to the Community ๐Ÿ˜Š
ย 
I'm checking with the Product team and if there are any updates in relation to this, I'll be sure to let you know.
0
๐Ÿ‘ Spot On ๐Ÿ’ก Innovative Approach ๐Ÿ’ช Stellar Advice โœ… Solved ๐Ÿช„ Remove Kudos

Folllowing List for Post: [Status: Coming Soon...๐Ÿ•‘] Filtering by Custom Column Values- AND/OR logic
[this list is visible for admins and agents only]

Alto
Didnโ€™t find what you were looking for? Write new post