Shared Filters on Single Value Charts Performance Technique

  • 11 May 2022
  • 0 replies
  • 165 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.


0 replies

Be the first to reply!

Reply