# Shared Filters on Single Value Charts Performance Technique

**URL:** <https://discuss.google.dev/t/shared-filters-on-single-value-charts-performance-technique/119309>\
**Category:** Technical Tips & Tricks\
**Created:** [May 11, 2022, 6:13pm UTC](https://discuss.google.dev/t/shared-filters-on-single-value-charts-performance-technique/119309 "2022-05-11T18:13:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikhailxu](https://avatars.discourse-cdn.com/v4/letter/m/6a8cbe/32.png) [@mikhailxu](https://discuss.google.dev/u/mikhailxu)\
**Post date:** [May 11, 2022, 6:13pm UTC](https://discuss.google.dev/t/shared-filters-on-single-value-charts-performance-technique/119309/1 "2022-05-11T18:13:18Z")

</div>

This is a technique for loading dashboards with single value tiles that have the same `WHERE` clause.

Instead of making a single query using filters for each Look and a single measure or dimension, this example returns an entire row with every single value desired:

From this single query, we can create multiple single-value visualization tiles for our dashboard. In this example we will call it Single Value Dashboard.

# We can do this by:

1. Hide every dimension and measure, except for the desired field we want to show in the Look:

2. Save the Single Value visualization in the same Dashboard, for each measure and dimension:

3. Then our dashboard will produce the different tiles or Looks (according to how you saved each visualization) off the same Explore query:

This greatly reduces the load time used in running parallel queries on the database which uses the same `WHERE` filters, so it improves performance and reduces database load.

---

<div class="post-metadata">

**Author:** ![anonymous8](https://avatars.discourse-cdn.com/v4/letter/a/7cd45c/32.png) [@anonymous8](https://discuss.google.dev/u/anonymous8)\
**Post date:** [July 28, 2022, 6:35pm UTC](https://discuss.google.dev/t/shared-filters-on-single-value-charts-performance-technique/119309/2 "2022-07-28T18:35:47Z")

</div>

Hi [mikhailxu](https://community.looker.com/members/mikhailxu-63), this is a great feature provided by Looker. Do you know in what version was this feature released? I can’t seem to get it working on my looker instance.
