Skip to Main Content
Status Shipped
Created by Chris Waters
Created on Oct 1, 2015

Add "not empty" or "has a value" report filter

When using the filters with reports and pivots, it would be helpful to filter all features 'with a tag', or 'not empty'. We use the tags feature to indicate features for given customers. This works great, and enables to have a transversal view of all requirements or improvements made for a given customer whatever the product. However, I wanted to include this view in a notebook (show features/products per tag); but the only way to exclude features without any tag from the pivot view was to select all tags. This is not really a problem, but I have to be sure to update the filter regularly in the saved view to include newly created tags. Having a "not empty" option would always ensure that new tags are included in the report.

  • Attach files
  • Deena Cannistraci
    Reply
    |
    Nov 30, 2016

    Yes and I would also like the reverse of this, I want to show empty too, both options would be ideal.

  • Nick Mariette
    Reply
    |
    Feb 9, 2016

    I would also like the related filter that could display all items without any tag.

6 MERGED

Not filter for custom fields

Merged
I have created a report showing custom fields and wish to have a filter of 'not blank' rather than add every entry to my filter because when new values are entered in my custom fields, I have to keep modifying the filters on my reports
Elliott Lack over 8 years ago in Reports 0 Shipped
4 MERGED

Filter by NO initiative set in reports

Merged
We need to be able to see all features that DON'T have an initiative set so that we can find the orphans
Kyle Carpenter almost 7 years ago in Reports 1 Shipped
4 MERGED

Exclude filter when field is empty

Merged
We often see situations where we want to exclude a record if a field is left empty. The advanced filtering which was added of All, Any or None doesn't support this situation. In order to get around this we have to end up adding custom fields which...
Dan Pohlman about 6 years ago in Reports 0 Shipped
4 MERGED

Filter for unassigned to do items

Merged
I'd like the ability to filter by to do items that are unassigned, much like being able to filter for unassigned features.
Guest over 6 years ago in Reports 0 Shipped