How to keep your filters from immediately resetting your query!

I have this standard, boring dashboard that shows details for 1-5 IDs at a time. The data source is HUGE (it takes ~10 seconds to query) and the query would run every time I selected an ID. So, if I needed to look at 100, 101, and 201 the process would look like this:

Open Filter, Select All

Cancel Query

Open Filter, De-select All

Cancel Query

Open Filter, Select 100

Cancel Query

Open Filter, Select 101

Cancel Query

Open Filter, Select 201

Done!

It was frustrating enough that editing the filter was easier than using the filter card. Not quite good enough for sharing!

Then I noticed that a production workbook wasn’t doing this! By looking at the filter I discovered how to add the Apply Button to filters.

custom

Now the process looks like this:

Open Filter

Select All

De-select All

Select 100

Select 101

Select 201

Apply

Done!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s