Shared Filters on Single Value Charts Performance Technique

Looker will not be updating this content, nor guarantees that everything is up-to-date. 

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:

510c076a-1a67-4a82-a07f-203e29d82050.png

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:

    c59aee7a-1503-4345-876b-95f56c953100.png
  2. Save the Single Value visualization in the same Dashboard, for each measure and dimension:

    d1f1425e-a69b-4344-ad94-f1e7126e770a.png
  3. Then our dashboard will produce the different tiles or Looks (according to how you saved each visualization) off the same Explore query:

    73583ab5-60d2-4343-894b-6b0e03ef9e49.png

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.

Comments
Justice_Beaver
New Member

Hi mikhailxu, 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.

Version history
Last update:
‎05-11-2022 11:13 AM
Updated by: