There are so many things you can do by setting up the right set of filter conditions on a dashboard.
- Use Visual Filters
- Use filter conditions that make the smallest SQL (think include or exclude)
- Use hierarchical filters instead of relevant filters when possible
- Use Wildcard filters vs. enumerated lists