Deselect One Category From Dynamic Filter

Question

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.

AlexCertificati · Answer

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.

Sign up

Login to the community