Shared Filters on Single Value Charts Performance Technique

  • 11 May 2022
  • 1 reply
  • 472 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.


This topic has been closed for comments

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.