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.