Deselect One Category From Dynamic Filter

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
Is there a way to deselect one or more categories from a dynamic report filter? For example, When I open a report containing a dynamic filter for region and the region categories are as follows:
  • South
  • West Coast
  • Midwest
  • Northeast
I currently have to select South, Midwest and Northeast each in order to not view West Coast records.

I would rather deselect West Coast in order to perform 1/3 of the work required to view the pertinent information.

This is a simple example, but in some cases the options under a dynamic report filter may be a long list of items that a deselect function could provide a significant time savings when filtering. 
Photo of Adam Keever

Adam Keever

  • 1,994 Points 1k badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Depending on use case/workflow, probably other approaches are easier.

Here are two:
Spin up custom report versions with different combinations of values pre selected
Spin up a url formula button to pass values via url to the report you'll view

Oh, here's an even better one:
If the typical use case is more suited to deselecting than selecting, create your default report view with an Initial Filter set to display all the values. Use a url formula button to pass THAT url.

https://[domain].quickbase.com/db/[dbid]?a=q&qid=-1028357#dynamic/

{"sidebar":[{"facetid":14,"data":{"value":"HIGH"}},{"facetid":14,"data":{"value":"LOW"}},{"facetid":14,"data":{"value":"MEDIUM"}}],"searchString":"","ver":1}

Parse that one out and figure out how to pass everything you want into the url, then when that button calls the report, those dynamic filters will be pre-selected and you can de-select them using the X's in the in-report GUI.

(Edited)
Photo of Adam Keever

Adam Keever

  • 1,994 Points 1k badge 2x thumb
I was thinking more along the lines of the basic slicer functionality in Excel:
By selecting Multi-Select when all of the options are already selected, the behavior becomes deselect and it is very simple to deselect an option with one click: