Shared Filters on Single Value Charts Performance Technique

  • 11 May 2022
  • 1 reply
  • 326 views

Userlevel 3

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:

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.


1 reply

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.

Reply