Ability to include a field more than once in report filters
When applying a filter on some fields we can choose a custom value or 'is blank'. As an example some of the fields we created to capture estimates can either be blank or 0. I'm wanting to create a report picking up 0 or blank records, but I can't ...
over 2 years ago
Be able to Filter on all EXCEPT
I want to be able to use the filter for Organisation in a report I have built and would like to exclude 1 organisation. There is no button for this and so I am having to either export the data or click 100s of radio buttons for the organisations I...
11 months ago
Enhance Filtering on Feature Tags
When in the Feature List view, you can add a filter to select Feature Tags, but this is an OR filter which isn't specific enough. Would you consider adding the option to filter on specific tags only using AND logic? In the absence of this, I have ...
over 1 year ago
Ability to choose AND OR on Ideas Tag filter
When applying 2+ filters, would like to be able to define logic e.g Filter 1 AND Filter 2; Filter 1 OR Filter 2
over 3 years ago
More robust filtering logic
I require the ability to use the same filtering parameter in multiple ways, to explicitly show or hide certain information more granular. For example I want to be able to create logic to say "show me a feature with feature status=market released, ...
almost 5 years ago
Add complex filters for tags in list views and reports
It would be great to have more complex filtering options with tags fields (default and custom).
Right now when I use a tag filter it shows me features that have ANY of the selected tags. It would be very helpful to have options for ALL of the se...
over 4 years ago
Exclude filter capability
When selecting any field criteria, we have the option to search on Is blank, is not blank, but it would also be good to have the ability to define exclusion clause in the same place. For example - I want to search on say a TAG. This feature may ha...
over 2 years ago
I need the ability to filter on tagA and not tagB. This seems like a very simple case that should be supported.
I need to use this for
We have tags to indicate month reviewed like, reviewed Oct, reviewed Nov. I want to see an item marked reviewed Oct but not if it has been reviewed after than, say reviewed Nov. Given that I can't form this query (barring a solution that doesn't use
tagsat all), my Plan B is to manually change all the reviewed Oct, to instead say "rev Oct" so it doesn't match to begin with. A terrible hack.
Lack of this capability makes the use of the free form
tagsfield much less valuable.
I'm trying to create a filter to show me ideas where (category is blank) || (category = "+1" AND assigned team is null)--trying to use the category field in two different places in the query and can't :( :(
Totally agree that we need more ability to not only select by tag, but deselect by tag... i had a bunch of items that were all tagged "CSF" (Country Specific Functionality), and i wanted to exclude them from my list. The only way to do this was to tag all the others as NOT_CSF... but that just adds clutter.
We need exactly same feature as mentioned by Art Wynn. This feature is especially important in pivot reports.
There must be an opportunity to filter on tags using AND connector, i.e. tag-A AND (tag-B OR tag-C OR tag-D)
A reporting engine that can't reference a field more than once in a query? Inconceivable!
Argh. Me too. Or just let me access Idea Tags in logic on calculated columns, and then filter by those. That would help solve my use case of a report only showing ideas without a certain tag.
Echoing what everybody else has said. For me, not being able to apply a NOT filter is really time consuming. If I want to report on all organisations, execpt our own, I have to tick 100s of radio buttons (all accept ours!). Seems a basic requirement of filtering
Really important for us trying to filter a report that is missing fields unless it's because of some combination of that field e.g.
AND (field1 isBlank OR field2 isBlank OR field3 isBlank) OR NOT (field1 = value1)
Agree - having the AND operator for filtering tags is especially valuable!
We use tags a lot being being able to do this is a major pain and is making me rethink what fields we will have to create so we can handle AND and OR filtering correctly. This is a major pain.
Similar issue - looking to do something like:
Release = release1 OR (Release = release2 and Custom Field = is not blank)
Yikes, this one is rough to not have. Having to have 10 reports for a text field because of various spellings/values is intense. We can't correct them all in a bulk update because the values themselves are not wrong. Coca-Cola, Coca Cola and Coke are all the same entity, for example. Would love to see this added.
I need this in order to do a filter such as:
Workspace = WS1 OR (Workspace = WS2 AND Tag = TAG1)
currently I cannot do this because I cannot select workspace name twice
The main requirement is to be able to create an AND filter with a multi-select field but having the abiliity to use filters more than once in Advanced Fiilters would provide a lot of other flexibility for tuning reports.
The specific requirement I have been trying to report on is to be able to select to-do due dates that are either blank OR within a set period. Implementing this general requirement would solve that.
It's REALLY frustrating to not be able to filter to only Ideas tagged with "TagA" AND "TagB". Please provide additional logical operations to be used within/between tags.
We have started to really standardize on tags to maximize the value of feedback company-wide. I'll need to do a funky export thing and a bunch of tag fields to make this happen.
Yes, we too would LOVE this function to support our alignment efforts across organizations. We created a multi-select tag field to track organizational commitments for annual planning, and now we'd like to report out the list where TWO orgs are aligned on the work (said differently, both tags are present); however, we can't do that without using the same filter twice.
I even tried a work-around by using a calculation column in list view, but tagging fields aren't supported in calculations.
I too keep hitting this issue. Unable to do a simple filter ( has tag A, not tag B ) for example is very limiting.